One of the most common reasons we receive calls in Support is Data Lookups (aka translation tables). Incorrect or missing Data Lookups can prevent orders from posting to your Accounting Application or cause outbound documents, such as invoices or ASNs to be rejected. Here is a brief overview of eBridge Data Lookups and what to do if you encounter problems.

What are Data Lookups?

eBridge Data Lookups match up the codes sent by your Trading Partner to the codes in your Accounting Application. Typically, your Accounting Application does not store information the same way as your Trading Partners do. For example, you may sell an “ItemABC” to your Trading Partner, but your Trading Partner may refer to the same item as “Item123”. eBridge Data lookups allow you to match up these items codes, so your orders can post to your Accounting Application with your item code and your outbound documents, such as invoices, can be sent back to your Trading Partner with their item code . There are 3 types of Data Lookup: Partner, Ship Address and Items. Anytime a new Partner, Ship Address or Item is added, you will need to remember to update your Data Lookups, or you may encounter problems.

Troubleshooting tips

The most common problem encountered is your order fails to post. You will receive an error similar to the following:

“Error: item Item123 not found in translation table”

First, you need to check to see if the Data Lookup is setup and is correct.  The most common mistakes are:

• Incorrect IDs: The external ID in the translation table and the ID sent from the trading partner must match exactly. Internal ID must match ID from Accounting Package exactly. Any extra characters or space can cause the problems
• Status Inactive or On hold. If status of Translation is Inactive or On hold, it will not translate
• Trading Partner not added to Partner Group. Partner groups are often used to minimize maintenance of ship address and item lookup tables. An individual trading partner is assigned to a group based on some commonality between it and the group. People often forget to add the trading partner to the Partner Group, causing the translation to fail.

If you need further information on how to setup Data Lookups, please refer to the Data Lookup Tables maintenance guide. To request a copy of this guide,please email support@ebridgesoft.com. Of course, you if you encounter any problems, just call the Help Desk.

Nazma
Team Leader, Support Services

EDI Integration, Education ePortal, errors, help, Support