“KMF has steadily evolved from a local provider of basic sheet metal products to a supplier of complex engineering services supporting hundreds of companies across Europe,” said Keith Nicholl, operations director, KMF Group. “Future plans call for exceeding $50 million in sales by 2021. The thorough understanding of customer needs combined with the ongoing investment in the finest technologies is expected to fuel our growth for the next decade and beyond.”
Rich reporting with Epicor ERP
This commitment was reinforced several years ago when KMF implemented the Epicor enterprise resource planning (ERP) system to manage processes, develop “rich performance reports” across departments, and automate communications both companywide and with customers. Other immediate benefits included the ability to instantaneously track jobs from order through delivery, while alerting KMF to issues that can be readily resolved before becoming problematic.
Uniting three independent operating systems
Most recently, the Epicor ERP solution proved integral to uniting the operating systems of all three KMF companies under the Group umbrella. Using the Epicor Data Management Tool (DMT), historical data from three separate databases were imported into Epicor, simplifying the future integration process should KMF decide to merge all three sites into one.
“Data is absolutely everything,” explained Nicholl. “The inability to absorb not only an entire organization, but their detailed files into our system had stunted our growth for a long time. The language barriers and differing monetary and legacy systems were too much to overcome until we launched Epicor DMT. It literally took just four days to download the information from our latest acquisition into Epicor ERP. We turned off the old system on Thursday, did the transfer on Friday, and began working with all the new, fresh data on Monday.”
Epicor DMT was developed to import, update, and delete application data safely and efficiently. Many companies implementing a new ERP system have vast amounts of information to transfer, and to enter this data manually would be far too time-consuming. Epicor DMT uses a template builder to help understand the customer entity and establish the required fields. The extracted data is then formatted into CSV, Excel Microsoft, or similar files for import into the Epicor ERP system.
Epicor DMT-the pipeline for mass data migration
“We needed a way to synchronize the information between all three companies to better understand each organization's customers and develop methods for selling companywide solutions rather than single jobs,” said Jeng Lim, systems analyst, KMF. “The chore was to migrate the data from multiple distinct systems. Epicor DMT provided the pipeline for verifying and validating these details on a cell-by-cell basis as well as cleansing the data for use in a user-friendly manner without gaps. Once the templates were set all you had to do was press 'go.' It was just that easy.”
“We've heard about systems that had to be shut down for weeks to transport and store this type of information,” added Nicholl. “Epicor DMT did the job in one weekend without duplicating efforts. With the ability to analyze complete customer histories in a single summary, we can now create solutions that wouldn't have been possible beforehand. Plus, we've built checks into each new site that now alert us to various forms of errors. This alone has increased our bottom line by lowering shipping order mistakes at these locations from 10 percent to zero.”