All Systems Go

Over the last several months, software applications have reached new heights in functionality and sophistication. Integrating these applications to produce the desired results, however, is another story.

[From iSource Business, March 2001] The mandate handed down by the board of directors at your company is clear: To cut costs, the research and development necessary to create the next line of the company's computer components must be done in part by your suppliers. Intimate planning, strategizing and collaboration will be required over the next several months. And it's a smart strategy. Studies have shown that this type of collaboration leads to a better product as well as greater supply chain efficiencies.

In the short run, however, it means a lot of work.

It means the company must re-evaluate suppliers and perhaps identify new companies that are better able to conduct such activity. It means the company must integrate with said suppliers for more sophisticated demand planning. It must collaborate with them on a whole new level  product design and even marketing. It must incorporate these external functions into the company's own, internal back-end operations, such as accounting, cash management and transportation.

Most of all it means, as director of procurement operations, you are in the hot seat.

Time to cash in the options and finally retire to the Bahamas?

Not quite. In at least one respect the timing for your new responsibilities could not have been better. Over the last 16 months or so, software applications for direct and indirect e-procurement, strategic sourcing, supplier allocation, demand planning, configuration, personalization, catalog management, channel management, and supply chain management have reached new heights in functionality and sophistication  and some combination of these applications can surely handle the task at hand. Integrating these applications to produce the desired results, however, is another story.

True, as a procurement or supply chain professional that may not officially be your headache. But, in reality, it is. While you can hire a systems integrator (or as the second generation of such IT service providers are known today, enterprise application integrator) to do the wiring, you are still responsible for the end result. Is the purchasing data integrated properly into your accounting functions? Is your supplier able to access your internal demand projections? Are you able to access your supplier's system to check the progress of your order? You need to know the answers to questions like these, because, in the end, you will be accountable, fairly or not.

"When e-transactions are 'misplaced' or mishandled in an operational environment, years of relationship-building and business dealing can be damaged," says Chuck Phillips, a partner with Forest Hill Consulting, a Chicago-based management consulting firm that specializes in business integration. "Oftentimes, your company's credit and business reputation is on the line."

Nor is this strictly a tech project anyway, he says. Any successful e-procurement or supply chain implementation requires input from the purchasing department. "Bolting on an 'e-anything' to a company's legacy system requires extensive business design and planning," says Phillips. "Business rules, procedures and decision-making processes must all be analyzed to determine if and/or how the new e-business environment can fit into the existing purchasing or supply chain environment."

So because these seemingly 'tech' issues have become integral to supply chain planning strategies, iSource Business magazine has decided to develop a primer for non-technical management on all the different ways your $100,000 e-procurement project may go wrong and what you can do to prevent such glitches. We also talk about what can go right  for as software systems become ever more able to interact among companies, the possibilities to create new supply chain efficiencies and intra-company collaboration are growing exponentially.

Understanding the Problem

The problems of systems integration are not new. Most companies became painfully acquainted with the difficulties of creating interfaces and points of integration for application and data sources when ERPs were installed a decade or so ago. At that time, their functionality was nothing short of amazing. They were able to integrate all the major business processes of a company, such as finance, accounting, human resource functions, customer service management, manufacturing resource planning and scheduling, materials management, and data warehousing. But actually implementing these systems was costly, both in time and money, and glitches often remained no matter how customized the configuration was.

Now we have second and third generations of best-of-breed applications that do everything better. The e-procurement and supply chain applications that have been introduced over the last two years can make a phenomenal business case, with promised rates of return averaging 300 percent over the life of a system. But the issues surrounding systems, or enterprise applications, integration are largely the same as before. And so the lessons learned a decade ago need to be reviewed.

"If you have to copy files off of a legacy ERP to run an e-procurement system, there needs to be a lot of thinking and planning before designing that type of interface," Phillips says. "Ask yourself, 'What are the business rules that make my legacy systems work? Is that data sufficient to run the e-procurement system?'"

Unfortunately, many companies find it is not.

"Most ERP applications are not built to support an e-procurement function," says Dale Peterson, general manager of eSourcing management technologies in eBreviate's Plano, Texas office. Common problems, he says, include data that is not cleaned up before it is loaded, difficulty in aggregating spend, and difficulty in integrating procurement cards and travel and entertainment cards into the system. Too often "you lose visibility to a good part of your spend. And all of this information is necessary for strategic sourcing."

Here are some of the other problems that can potentially arise:

  • Incorporating information from a purchase order into a financial system or general ledger. "It can be difficult to come up with a common interface from an e-procurement application that meets all of the data requirements of an ERP's financial applications," says Alex Milward, senior manager in Andersen Consulting's European eProcurement Leadership Council, based in London. "It all depends on how each business unit has configured the ERP. Some will require very little information from the purchase order. Other businesses may have configured its ERP system to require such information as delivery lead times. You have to make sure that information can be captured from the purchase order, and that means having a good understanding of the business requirements of both the procurement and finance departments."


  • Contract compliance. "This is probably one of the major objectives of any procurement organization," says Milward, as well as the main driver behind most e-procurement implementations. "And ERP systems have a lot of information that can be stored around preferred contracts and suppliers." So it is doubly ironic that oftentimes after an integration project "the purchase order doesn't contain reference numbers of that contract so the procurement organization can track how much spend went through a specific supplier contract." This can be a problem, especially if an organization has multiple contracts, he says.


  • Materials management. "Companies are currently wrestling with how they can take advantage of all the good things e-procurement offers and then integrate that with their materials management systems," Milward says. So far, they have been largely unsuccessful.

    Traditionally, materials management systems automate a work task that needs to be performed on a routine basis  a particular maintenance service that needs to be done to a certain machine, for example. "There could well be a piece of equipment that needs to be replaced as part of the maintenance," Milward says. And, of course, there are other items that may be needed to perform this task, such as safety glasses or certain cleaners or chemicals  all of which are listed in a bill of materials. "This is an area where e-procurement systems can help. You may want to associate those expenditures back to that particular maintenance job, so you can track the true costs of your maintenance program." Unfortunately, integrating these two functions and separate sets of data "is still a challenge that is very difficult to overcome," Milward says. "In the ideal world there would be one set of data and one system."


  • Supplier allocation and other front-end planning. "Many e-procurement systems have sophisticated sourcing functions that allow companies to find new suppliers based on cost or delivery times or capability," says David Bassuk, senior manager of the New York-based Kurt Salmon Associates e-commerce practice. But these front-end capabilities often don't integrate well into back-end planning functions such as tax planning or transportation management. "When you make a purchase you have to understand what the implications will be on the company's overall strategic plan. Right now there is not a lot of integration of that sort of information."

This is not to say such e-procurement activities are impossible to integrate into a larger legacy environment. They do, however, take some special expertise.

Choose the Right Integrator

The term systems integrator has really been around for over 10 years. So it's only natural that, as e-business applications have evolved to the point they have, the new generation of integrators would have a new name. Today they are called enterprise application integrators. Emphasis used to be placed on the actual system or software itself; today's enterprise application integration providers tend to focus more on the seamless exchange of information between applications within and between companies.

Unfortunately, in the heyday of the ERP installations, some integrators earned a dubious reputation among clients. Common complaints included projects that had doubled in costs and time from the original quotes promised at the start of the project, sales teams that used bait-and-switch tactics during presentations, and performance and tech capabilities that had been grossly overhyped.

But those days are over, right?

Not exactly says John Gonsalves, who heads the Technology Enabled Strategy practice of ADVENTIS, a Boston-based business strategy consulting firm. "We still see the same problems in current integration projects."

To be fair, the majority of integrators are companies that abhor such practices. Also, a successful integration depends just as much on the client as the integrator. Companies have to be pro-active in the planning before the integration even starts. "If you are going to insert an e-procurement into your operation you have to spend a considerable amount of time understanding the impact on your overall business model," says Phillips.

Nonetheless, most will agree that the integrator is the ultimate key to success and must be chosen as carefully as the e-procurement package itself.

"Once you hire a systems integrator you can't fire them if the project is already underway," says Gonsalves. "They are too entrenched. So you pretty much have to choose the right partner from the very beginning of the project."

Gonsalves suggests researching very carefully an integrator's track record. "How much do they invest in innovation? Do they have an idea lab or product testing lab? Ask them about accounts that did not go well, and what they did to make it better. This is more telling than accounts that went well from the beginning."

Some other tips to help your company choose the right integrator:

  • Use scripted scenarios when choosing an integrator. Instead of having the company give a canned presentation based on a general request for proposal, develop a scripted scenario that is similar to the business model you wish to develop for your organization.

  • Check references, but try to find clients of the integrator beyond those provided by the company itself. Ask if the integrator delivered all of the productivity promised at the start of the project and if it transferred essential project knowledge to the client company at the end of the project.

  • Have checks and balances incorporated into the contract. If certain benchmarks are not met by a specific period of time, then penalties should kick in. At the same time, be willing to offer incentives for reaching certain goals or promised ROI.

Communicate With Your Suppliers

A company's supply chain operations may function very well in routine circumstances, but an unforeseen event  a normally reliable supplier can't meet your order this month for instance  can easily throw a just-in-time manufacturing schedule into chaos.
Of course, there are always alternative suppliers to turn to. The company can contact one, see if it has the necessary parts, place an order, and then schedule delivery. Which, incidentally, would have to be for the day after tomorrow, if the company wants to keep its production schedule.

Conceivably it can be done, says Bill Harrelson, chief technology officer for Canopy International, an e-business company that offers consulting and integration services. It would involve using a registry to find an alternative supplier and then sending the exact same purchase order to that supplier. The supplier would then have to send back an advanced shipping notice, which the company would forward, along with a bill of lading to a logistics provider, who would be able to download the receivables information, preferably on the loading dock, using a handheld RF device.

In this scenario, Harrelson is assuming that all the parties involved can read and transmit the information in these documents without extensive adjustment to their systems. In some industries, that isn't possible. For example, "In the automotive industry, to become a supplier there are stringent IT requirements for EDI transactions, which take a long time to put into place," he says.

However if all the participants' applications were based on a common XML format, it would be no problem. This above scenario, in fact, was demonstrated with off the shelf software from major application suppliers, using industry standard XML from the Open Application Group (an industry association) at the B2B Vendor Challenge trade show held late last year.

Extensible Markup Language: Strictly speaking, it's a standard for defining descriptions of structure and content in electronic documents, making it easy to share them among business partners. For procurement executives "it's just another three letter acronym in the IT Tower of Babel," says Gonsalves.

Yet as supply chains become ever more complex, many see XML as the best way to connect. "Because companies have different systems, there has to be a way to talk, Gonsalves says. "A common language to cut across enterprises and enable enterprise-to-enterprise integration is necessary."

Again, many procurement managers might say this is not their particular headache. And at one time they would be right. But not anymore though, counters Bob Sutor, director of e-business standards strategy for IBM. "Integration is now on a higher level and you don't necessarily know which application will ultimately be using the data. This is a great tool for linking applications."

However, it is only one tool among many, Gonsalves says. "Today many software suppliers are focusing on XML. But don't forget the bulk of transactions are still done via EDI. People read about the Aribas and Commerce Ones and think most transactions now are done online. And that's not true."

One major problem with XML is that standards development in this area has been confusing, with different suppliers favoring different specifications.

By some point, however, most believe these issues will be settled. "Eventually I think XML will become the dominant standard," says Gonsalves.

Future Scenarios

Right now all companies have to worry about is integrating their internal operations, and integrating their communications with key business partners. Yet some analysts envision more of a free-for-all in the future, with companies that have even a casual relationship exchanging data and integrating certain functions. In other words, if you can't master today's integration challenges, you definitely won't be able to handle tomorrow's.

Karl Wilhelm, chief technology officer and co-founder of SBI, an e-business services company based in Salt Lake City, Utah, points to a project that is in the works between Ariba, IBM and Microsoft that could push sourcing and procurement to even further heights. It's a free e-commerce service called UDDI (Universal Description, Discovery and Integration). It is, according to company information, "a global, platform-independent, open framework to enable businesses to 1) discover each other 2) define how they interact over the Internet and 3) share information in a global registry that will more rapidly accelerate the global adoption of B2B e-commerce."

Some analysts liken it to a single online phone book with product and contact information for every company in the world. Wilhelm says it reminds him "a little bit of the shopping bots for consumers. The only difference is there is enough capability behind the bot that a virtual business relationship can be created."

Instead of using a reverse auction to get the best match with a supplier, a procurement manager can go Web crawling to find what he needs, Wilhem says.

"Personally, I think over time we will see the business world head in that direction." Of course, he adds, the future is nearly impossible to predict in the e-economy. "What people were doing a year ago and what they are doing today is literally almost a generation of difference. Who knows what will be possible a year from now?"

Surely by that point it will be possible to send a purchase order through to an accounting department with minimal hassle.
Companies in this article
Latest