Global ERP: You can get there from here, but should you?

Is it worth the angst? Three multi­nationals say yes.

Since Colorcon Inc. consolidated all of its global offices and seven manufacturing sites onto one ERP system in 2001, the benefits have been indisputable. The specialty chemicals manufacturer has increased its annual inventory turns by 40%, closes its books each quarter more than 50% faster than it once did and has improved its production lead times. It was a significant improvement, says CIO Perry Cozzone.

But getting to a single, global instance of Oracle Corp.s 11.5.10 E-Business Suite has also been fraught with challenges for the West Point, Pa.-based company. Those included cleansing and verifying data from legacy systems, standardizing business proc­esses globally and getting buy-in from business leaders in locales as disparate as Brazil, Singapore and the U.K.

It was hard work, says Cozzone, who oversaw the final stages of the system implementation.

Perry Cozzone

Perry Cozzone Transitioning to a single, global instance of an ERP system is a heady challenge for large and midsize multinationals alike. Its a real struggle for many companies to have consistency around their business processes because of differences in regional business requirements, says Rob Karel, an analyst at Forrester Research Inc.

But companies that have achieved a single instance say its worth the struggle to streamline financial reporting and increase the visibility of operations around the world, because doing so allows executives to make decisions faster.

Change Management

For many organizations, the toughest challenge in moving to one ERP system is change management. The organization has to reach consensus on business processes, says Jim Shepherd, an analyst at AMR Research Inc. in Boston. Thats far and away the most challenging aspect of these projects.

Goss International Corp. began moving to one instance of SAP AGs ERP system in 2002 in an effort to consolidate its global financial reporting, close its books faster and have greater visibility into operations such as manufacturing. Following its 2004 acquisition of Heidelberg Web Systems, Goss implemented the SAP system in its Bolling Brook, Ill., headquarters in 2005 and at facilities in the U.K. and Shanghai earlier this year.

Because Goss had stuck to SAPs industrial machinery and components industry template, there was a 95% correlation among its sites in how the SAP software was preconfigured and how the company ran its operations, says Mike Masters, director of global applications and solutions at the printing press manufacturer.

Still, the project team had to work through regional differences. For instance, the French government requires that businesses report their inventory figures as a moving average. So the ERP project team had to adjust the SAP general ledger system used by its French unit so it could report one set of figures to the French government and a standard set to the company.

The experience at Millipore Corp. was similar. The toughest part of all of this was implementing a change management policy, says Tom Roy, manager of application services at the Billerica, Mass.-based life science products and services provider.

Tom Roy

Tom Roy The changes associated with Milli­pores consolidated ERP effort started in 1999, when the company established central, round-the-clock support for Oracle ERP users in 32 countries. It was difficult for workers in the U.S. to replicate the IT support service that employees in Japan were receiving locally, says Roy, so we had to put different business processes in place.

Millipore placated many users by assigning three database administrators on rotational schedules to handle support calls from its international offices.

One of the biggest pieces of the change management puzzle is gaining buy-in from local business leaders accustomed to suites tailor-made to support their unique business processes, says Forrester analyst Paul Hamerman. Theres often reluctance among business units to give up the systems they use, he says.

To work through those issues, the Colorcon project team had two forums for business leaders to advocate for their organizations needs. Business process owners participated in regular discussions with the project team to make sure their requirements were being met. And director-level executives were able to track the project through the project management office and add their input. Cozzones team also gained acceptance by reminding business leaders that the change was going to globalize businesses once confined to operating in a single country.

Data Integrity

The most common technical challenge that project teams face is verifying the integrity of legacy data and moving it to the ERP environment. One of the lessons learned is that you can never spend enough time on ensuring data quality, says Cozzone.

Early in Colorcons project, when there were questions about the quality of a set of data, team members and executives didnt always agree on what needed to be done. There was inconsistency about how to measure [quality] and manage it, says Cozzone.

So the project team developed a data-quality dashboard to illustrate to business leaders why compromised data needed to be fixed before being entered into the Oracle environment. The dashboard demonstrates, for instance, how poor-quality customer contact information could lead to an increase in erroneous orders. The dashboard includes steps that business users can take to correct faulty data, and it quantifies monthly business improvements achieved by reducing bad data.

Each of the companies also had to work through minor issues in retiring legacy systems and so-called ghost systems those used in various business units but unknown to corporate IT.

Were not a multibillion-dollar company, but we still had ghost systems, says Cozzone. We made these a high priority and got rid of them quickly.

At Goss, when data from a legacy system was migrated to the SAP environment, the system would then be retired, explains Masters. Data from reporting applications that were needed and supported locally was retained and formatted for the SAP environment, but it didnt become part of the central transactional system, he adds.

Millipore encountered relatively few data-integrity problems, since most of its operations were already running on Oracle when it transitioned to a single global instance of the ERP system in 1999, says Roy. But it did have to make big investments in high-speed bandwidth connections to help far-flung offices connect more easily to the centralized Oracle system in the U.S.

You have to invest significantly to get some big [network] pipes, says Roy. Before this move, some of our offices were accessing a computer in their own data room. Now, theyre connecting with a system thats 5,000 or 6,000 miles away.

But its all been worth it for Milli­pore. Like Colorcon, the company is now closing its books faster than before and has a much better global view of its inventory and financial data. The only way we had that view before was either to query each database online separately or to run and print reports from each system, says Roy.

Goss has gone from closing its financial books in seven days to five days, says Masters. But for it, too, the global view was the big payoff. The single biggest value weve received from the single instance is increased visibility across the board, says Goss CIO Bill Rogers. The bill of materials is visible; manufacturing orders are visible; financial reporting is visible. This all leads to more timely and more effective decision-making.

Copyright © 2007 IDG Communications, Inc.

7 inconvenient truths about the hybrid work trend
Shop Tech Products at Amazon