Extracting Data via ODBC during Mapping
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 us, and we will walk you through the specific steps to accomplish this task.