Scribblings of a Microsoft Dynamics GP MVP
Translations in Integration Manager
Let’s say you need to do an integration from a third party system to integrate purchase orders and that the Vendor ID in the other system is in a different format from your GP Vendor ID. Integration Manager provides a translation tool to convert the Vendor ID during the integration process. In the POP Transaction integration, open the Destination Mapping window and select the Vendor ID field. In the pane on the left, change the Translation Option from No to Yes, then click on the ellipsis button to open the Properties (Local) window.
When you click the ellipsis button, the following prompt appears:
* click image to enlarge
Answering ‘Yes‘ will cause the values in the source file to be populated in the ‘From‘ column in the Translation table so you don’t have to manually enter the ‘From‘ values. Choose ‘Yes‘.
Enter a Description for the translation and choose the appropriate Options. Select the Translation tab and enter your translations.
*click image to enlarge
After entering all your ‘To‘ values, click ‘Apply‘ and ‘OK‘. When you run the integration, the Vendor ID will be automatically translated to the values you specified in the translation table.
Read the original:
Translations in Integration Manager