Blog & News

Back to Posts

Choosing and Implementing an ERP System (Part 2)

Posted on October 1, 2022

By Josh Chernin, Business Improvement Group

Enterprise Resource Planning (ERP) Systems connect all functions of a business so that information is entered only once, everyone has the information they need when they need it, and calculations and many simple operations, and much of the accounting, are performed automatically. They are big systems and can improve organizational productivity greatly. Most of them now are in the cloud.

ERPs include Material Resource Planning (MRP) Systems, which manage your purchasing and inventory, and time purchases so that you have what you need when you need it.

Recently, a lot of power has been put in the hands of users. Users can customize reports and write work flows (which make the system do what you want it to do) without knowing programming. They can also connect to outside Application Programming Interfaces (APIs) which can automate interactions with vendors, customers, and delivery services.

In Part 1 we covered how to choose an ERP, the idea being that you need to first decide how you want to run your business and what features you’ll need before even talking with vendors. Now, having chosen a vendor, we’ll talk about implementation.

To begin with, you’ll need a project plan. Many vendors supply theirs, but you’ll need to modify it. It should state all the steps, who is responsible, what help they’ll need, and due dates. Plan on roughly six months to cutover. There will easily be 300+ tasks.

You will also need an internal project manager. This person doesn’t need to know programming, but does need to learn the capabilities of the whole system and how actions in one module affect the others. They also need to be highly organized, good communicators, willing to pester people, and have the full support of the President. Most important, they need to have a good background in business in general, and in yours specifically.

The major steps are:

  1. Training, training, training. This will be done by the vendor.
  2. Creation of “sandbox” sites, which allow you to practice and play with the system and configure it to your needs.
  3. Data gathering, sanitization and upload: This can be the biggest challenge. You’ll need to gather all the customer, suppliers, part, part number, inventory, financial, and all other data into .csv formatted files. Then, either you or the vendor will upload those files into the ERP.
  4. A series of workshops, guided by the vendor, where you will make dozens of decisions about how to configure the system to your needs. For instance, will you use standard, average or actual costing? Which parts are to be inspected? Etc., etc.
  5. Moving documents into the ERP. Many organizations have work procedures, quality procedures, quotes, all sorts of documents in Word or Excel form. Usually these get housed in the ERP system where they can be more easily accessed or attached to other forms.
  6. Mock trials. In the old days, cutover meant running your old and new systems in parallel for a month or so to prove out the new system. But that’s a lot of extra work. Now, the vendors will lead two or three mock trials of the new system, with your people all assembled in a conference room, taking orders through the system from sales to invoicing. A gap analysis will be performed each time. Usually there are many gaps the first time through, and nearly none by the third.
  7. Just prior to cutover, all open transactions—open A/R, A/P, work orders, etc.—are moved manually into the new system. Then you press the button and off you go! The vendor will be on site to help.

It’s a long process which will consume much of an organization’s time, and there can be other big challenges—for instance, you may want to put bar-code labels on all of your inventory to facilitate system transactions. But the rewards in productivity, reduced errors, less time looking for information, and customer service are huge.

Josh Chernin is a Partner with Business Improvement Group, LLC, Consultants to Manufacturers, and has more than 30 years of manufacturing and operations leadership experience in the US and Europe. He’s had P&L responsibilities in printing, metals, converting, contract manufacturing of medical devices and aerospace modules, and textiles, built three plants, consulted to many manufacturers, performed several turnarounds, and visited over 300 manufacturing plants. Josh is an expert project manager. Josh has a BA in Economics from the University of Massachusetts, Amherst, and an MBA from the Harvard Business School. He can be reached at Josh.Chernin@bizimprovementgroup.com.