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.

Extracting Data via ODBC during Mapping

Monday, May 10, 2010

Have you ever needed a piece of data for an Outbound Invoice that is not included in your backend system, but you know it was on the original Inbound Purchase Order? Or you would like to verify that the Inbound Purchase Order contains valid Item Numbers.

EDI Complete and EDI/HQ both have the ability to use an SQL statement to extract data from a previously stored transaction or from other tables within the database. It is as easy as building the necessary SQL Select statement, using the Select statement operator within the map designer and setting up the ODBC connection to the database table. When your trading partner requires information that your back-end system does not store, one solution that may easily satisfy both you and your trading partner is in-map retrieval. If this is something you would like to do, please contact your EDI Consultant at 1 EDI Source, Inc. and he or she will walk you through the specific steps to accomplish this task.

Page Title: EDI Tips & News | 1 EDI Source, Inc. - Extracting Data via ODBC during Mapping