1EDI Source

Your business situation is unique. You need your EDI solution to work for you and your particular needs. 1EDISource is the best source for helping you to get there.

Home  chevron  About Us  chevron  News Room
Error You are using an unlicensed and unsupported version of DotNetNuke Professional Edition. Please contact sales@dnncorp.com for information on how to obtain a valid license.

Bad Data - It Happens – Part 1

Tuesday, January 06, 2009

In a perfect world, all the data that we send to our trading partners - and that which they send back to us - would be valid and error free. In reality, however, bad data is bound to happen at some point. The question isn’t really “will I ever see bad data?”, but rather, “when will I see bad data?” - and, more importantly, “once I have bad data, how do I handle it??”

Scenario: You are sending invoices to your trading partner, and realize that one invoice has failed to transmit. Closer examination shows that an item on the invoice is missing a required item number. The invoice in question has the UPC code, but not the buyer’s item number as required. What can you do when you have one piece of required information, but a related piece is not available on your outbound application data? Not to Worry! EDI Complete has a solution for every need. In this case, a data conversion table can be used to populate the buyer’s item number based on the UPC Code already provided in your application data. The setup can be seamless, and can update the buyer’s item number upon mapping. Data conversions can be used to supply data in any case where you are sending or receiving data where only part or related pieces of information exist. Additional examples include updating Carrier SCAC codes based on the shipper name, updating ship-to and bill-to codes so that you can link data between your company and your trading partner, and many other uses. Please call your experienced EDI Consultant today to see how using data conversions can help you!

Page Title: EDI Tips & News | 1 EDI Source, Inc. - Bad Data - It Happens – Part 1