EDI -- what went wrong?

Daily Newsletters

Sign up to ZDNet UK's daily newsletter.

ANALYSIS
It's a reality of business that companies often create the appearance of orderly operation by off-loading their logistical troubles on smaller, weaker trading partners. When the grocery industry sought to implement EDI as a standard means of communicating pricing and promotional information, such shortcomings became apparent. Trading relationships that had been in place for decades were suddenly threatened by a technology that was supposed to improve operations for everyone. Instead, inherent weaknesses were amplified and a new operational philosophy had to be considered. These lessons, reviewed by a best practices committee (of which I was a part), offer guiding principles for any large-scale EDI implementation between partners in a supply chain. They changed my thinking about how to apply EDI: I learned that the on-paper implementation plan is not always the best, and that practical considerations in partner relationships are far more critical to success than the elegance of the software solution. The original suggestions for best practices in this project came from a consortium of key manufacturers and retailers, with some brokers invited to offer input. Here's a rundown of lessons that the grocery industry learned and some thoughts on how they can be applied to other EDI-related contracts. "EDI will solve everything" Often in EDI supply chain work, companies see the value of handling all master data electronically, eliminating data entry errors and verbal misunderstandings. Perpetuating this belief is part of the EDI trade. I hope that none of us is naïve enough to buy into the fallacy that EDI will resolve every problem. But that was the goal with the Universal Character Set II (UCS II) initiative, which was intended to get everyone who was involved in the grocery industry--manufacturers, distributors, brokers, and retailers--on the same page, all with product/pricing databases that matched. Before EDI, the relationship worked like this: promotional data was taken from the manufacturers and faxed or phoned by the sales rep to the broker, who then typed it into the broker's database (more potential for error). From there, the broker faxed or phoned the information to the retailer. Often, the end result was misunderstandings over regional pricing, promotion dates, and other conditions, and the manufacturer ended up with a stack of amended invoices and an unpleasant loss. The belief was that if everything came straight from the manufacturer's database via EDI, all these errors would be cleaned up. Putting the solution before the problem The UCS II initiative, designed to solve the invoicing errors problem, was thorough but overly so. It took three standard EDI documents -- two master/maintenance documents and a transactional document -- and outlined very specific uses for them.
  • The 888 Item Maintenance document would set up and amend all product master records in a supply chain.The 879 Pricing document would modify the pricing data stored in those master records.The 889 Promotions document would distribute promotional conditions.
    • It's hard to fault this solution in concept. It addresses the root of the problem by generating all master records and modifying information from a single source, eliminating mismatched master records and communication problems in distributing transactional data. It's simple and elegant. And it turned out to be unworkable. Infrastructure defects UCS II couldn't work as a canned solution, not because the proposed documents and procedures wouldn't do the job (they would), but because the relationships of the supply chain participants placed a huge burden on brokerage firms. In the grocery industry, a retailer requires products from dozens of manufacturers. Because it's logistically impossible for the retailer to deal directly with this many partners, middlemen -- brokerage firms -- do the job for them. A retailer can deal with a handful of brokers, and thereby have access to a huge number of manufacturers, with the logistical burden shifted to the brokers. It looks the same way on the other side of the supply chain. Manufacturers have potentially hundreds of retail outlets for their products, more potential partners than they could ever realistically deal with. So they, too, deal instead with a handful of brokers. I visited many of these brokerage offices personally. The middleman in many supply chains is a humble participant, valued only for the willingness to do this massively complex networking with minimal resources. I found many brokerage offices to be very marginal operations, with modest offices, few computer resources, and minimal personnel. On paper, it looked like EDI would make their lives easier; in reality, it was a gargantuan burden, from a cost-of-implementation and training standpoint. A retailer, then, has a one-to-many relationship with brokers. A manufacturer, likewise, has a one-to-many relationship with brokers. In the middle, however, everything is many-to-many. Each broker supplies many retailers, from many manufacturers. In EDI terms, a retailer or manufacturer generally has a single in-house EDI system cranking out orders or invoices and uses a single value-added network (VAN). The broker, however, must accommodate every last one of these partners, interconnecting to all their different VANs, in order to keep their business. This situation is made far worse by the fact that retailers and manufacturers tend to be large and cash-rich, while brokers tend to be small, existing in very slim margins. The implementation of UCS II, then, with the broker serving as the critical clearinghouse for data flying in both directions, placed the bulk of the expense and responsibility on the party in the supply chain with the least money and the fewest resources. Lessons learned, round one Right out of the gate, two things are clear. First, in the ever more dynamic world of supply chain management, the need to be lean and mean generally invalidates any canned solutions to data distribution. Flexibility is a must, of course, and any solution that can't be very specifically tailored to the actual distribution scenario is probably a poor solution. And flexibility here doesn't just mean software and procedure; it also means the building up of infrastructure and the distribution of the burden of putting it together. Second, it's clear that the age of synchronised data is upon us. The goals of the UCS II initiative are pursued vigorously in supply chains serving most industries at this point. The benefits in error reduction are obvious, and the competitive advantage is irresistible. EDI does offer the means to coordinate data distribution throughout a supply chain: It's just a matter of avoiding the wrong ways to do it, and finding the right way. The "right way," in this case, is to abandon preconceptions going in--the value of EDI's flexibility is lost if a canned solution is preordained. Data synchronisation is worth all manner of inconvenience to achieve for the long-range savings realised from error reduction. But, like all partnerships, it hinges more on cooperation than elegance.
      Have your say instantly, in the Tech Update forum. For a weekly round-up of the enterprise IT news, sign up for the Tech Update newsletter. Find out what's where in the new Tech Update with our Guided Tour. Tell us what you think in the Mailroom.

Post your comment

In order to post a comment you need to be registered and logged in.

You can also log in with Facebook. Log in or create your ZDNet UK account below

  • Login

Will not be displayed with your comment

By signing up for this service, you indicate that you agree to our Terms and Conditions and have read and understood our Privacy Policy. Questions about membership? Find the answers in the Community FAQ

Get ZDNet UK's daily newsletter

Enter your email address to sign up

ZDNet UK Live

bordero

ike fuelband is great for every healthminded person ! to work out! theres this website called textme4free.com that you can use to text anywhere in...

6 hours ago by bordero on Nike's FuelBand wristband gamifies exercise
BrownieBoy

> I'm told it's somewhat annoying when people have their Macs stolen > and Apple stores treat the thief as the owner, but there you go. Ouch,...

8 hours ago by BrownieBoy on AMD Ultrathins to challenge Intel Ultrabooks
Moley

@kevinmchapman. OK, I acknowledge that 'most' was a gratuitous throwaway comment as an afterthought and too presumptuous. As to proof, as you...

13 hours ago by Moley on A tale of two distros: Ubuntu and Linux Mint
Jack Schofield

@BrownieBoy > Works really well for thieves.... >> Nice attempt to deflect the argument by tossing in a point that's totally >> irrelevant, even...

14 hours ago by Jack Schofield on AMD Ultrathins to challenge Intel Ultrabooks
raskolnikof

fantastic that the so called piracy bills have been withdrawn. however, these anti-democracy supporters are still in the shadows so lets be alert...

15 hours ago by raskolnikof on SOPA, Protect IP support wavers in face of online protest
Tony Douglas

Please God no; teach them anything you like - thinking rationally, the uses and misuses of data, what data is and what it's not - but leave the...

17 hours ago by Tony Douglas via Facebook on Kids are the future. Teach ’em to code.
BrownieBoy

@Jack, > Works really well for thieves.... Nice attempt to deflect the argument by tossing in a point that's totally irrelevant, even it were...

1 day ago by BrownieBoy on AMD Ultrathins to challenge Intel Ultrabooks
bootlegger

Make that 13 people now - I got refused today at Manchester airport. I thought I was up to date on this legislation - I knew of the EU ruling from...

1 day ago by bootlegger on UK airport body scans will not be opt out
tinycg

Don't forget to check out apps like GoodReader or SlideShark either, they're indispensible for people on the go in presentation situations. Best...

2 days ago by tinycg on Four top iPad apps for people on the move
TerryRK

Well it seems there is something a number of us agree on. Why is the Ubuntu Unity launcher so ugly? I thought perhaps it was something to do with...

2 days ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
Freebies202

Duplicate comments are not made intentionally. Its very good to know that now you are keeping check on this problem because sometimes a commenter...

2 days ago by Freebies202 on Microsoft fixes blog comments, speeds up blogs with open source
kevinmchapman

"the very significant number of users" and "many (most) of us" - you have no evidence for these statements. It is a fact that most users are saying...

2 days ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
Marg Menzies Harrison

Another grammar faux pas is the improper use of "you". When sitting down down in a restaurant, for example, I get cringe when the waitress...

3 days ago by Marg Menzies Harrison via Facebook on 10 flagrant grammar mistakes that make you look stupid
zdnetukuser

And NOW, folks, for Canonical's next trick... Kubuntu is late. Here's a pencil. Draw your own conclusions. cf.:...

3 days ago by zdnetukuser on Linux Minterface
Moley

@kevinmchapman. The discussion here reflects the very significant number of users who really do like the traditional menu system and who wish to...

3 days ago by Moley on A tale of two distros: Ubuntu and Linux Mint
kevinmchapman

Er, no... It is an efficient means of finding the application/file/setting you need in one place. The icons are a simply a fallback for when you...

3 days ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
TerryRK

Isn't the provision of a text based search an admission by the developers that the mass of icons approach does not work? I don't need to use a...

3 days ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
kevinmchapman

"Unity and GNOME 3 both abandon the old text-based cascading menus in favour of a graphical icon-driven system." Point truly missed. Both use a...

3 days ago by kevinmchapman on A tale of two distros: Ubuntu and Linux Mint
TerryRK

whs001 - Thank you, I'm glad you liked the article. I absolutely agree with you on your first point. I should perhaps have made it clearer that...

3 days ago by TerryRK on A tale of two distros: Ubuntu and Linux Mint
Dennis Nilsson

If we allow corporate interest to dictate the way our government circumvents due process against foreign entities then we should accept the same...

3 days ago by Dennis Nilsson via Facebook on ACTA stumbles in Germany