Your EDI Resource

EDI Consulting: All in a Week's Work

Posted by Roger Curtis on Fri, Sep 11, 2015 @ 02:39 PM

8685449189_7594d1b6e2_z_1

Picture appears courtesy of Wicker Paradise.  Whether you are an EDI Coordinator or Consultant it takes a lot of talent, patience and determination to do a good job.  When you're consulting with clients in a variety of industries, a good consultant has to wear many hats.  I was thinking over the last week of the many things I touched on and what it really takes to do this job.

My week started helping the Health IT department of a university rework a ten year old set of processes that was processing EDI 837 Health Care Claims by converting them into XML to be loaded into a giant SQL Stored Procedure for further processing before being loaded into a database for submission to the state for payment. Somewhere between the XML and the database, some claims were simply lost with no helpful logging available. To resolve this I proposed using the Delta/ECS EDI tools to go directly from the EDI 837 into the database where we would have solid logging of the transactions.

With another client, a freight logistics distribution company supporting electronic component suppliers to Toyota, Nissin and Subaru, was required to send copies of EDI 830 order forecast documents to the suppliers. They elected to use their existing Liaison Technologies EDI VAN connection and ECS to create and route the documents and copies. The initial tests were failing because the software used to create the documents was adding extra control characters after each EDI segment record. To diagnose this I had to look at the data with a hexadecimal text editor on their server and on the VAN with the VAN LENS browser and document it for the customer so the corrections could be made. EDI today has a lot of powerful tools which can be used to diagnose problems with data and to keep the supply chain moving.

One issue I see is that the EDI coordinator needs to know customer service order entry, A/R invoicing, warehouse shipping, the customers, trading partners, IT and many other business functions in order to do an effective job.  This is not always the case and that's where I come in to save the day.

My week ended out with sitting in on meetings at a sports equipment supplier customer that decided to get into the sports apparel business and suddenly needed to outsource their shipping functions to a 3PL company in order to meet the demands of several major retailers, followed by a JDEdwards Oracle customer doing a major upgrade whose EDI system needed hand holding through the process.

Either way it is rewarding work because we get to touch on so many things for this important business process to so many organizations.  It is fortunate we have good tools available and expert consultants to wield them.

Click below to read a case study on how we helped Quibids.com move their business to the next level.

Download  Case Study

Tags: EDI integration, EDI Technology, EDI software, EDI provider, JD Edwards, Oracle