We have a situation here where we have an external database that is the 'source' for Vendor records as well as Customer records. The Vendor/Customer is entered and can be flaged as either Vendor or Customer or both, information is then created in this database, and will include a unique Vendor ID or Customer ID as needed. The information is then transferred to Dynamics GP via means of Integration Manager.
Issue
When IM is created for the Customer we are able to import the Email Address for the Customer from the database source. This is found under Customer >> Addresses >> Options and there is Email To: field and we are able to import the needed email.
When we look into the Vendor >> Addresses >> Options there is no Email To: field and therefore we are not able to import the needed email. We are able to import to the Internet Information field, however this is not the field from which the various internal email operations draw data from.
Problem
We want to use EFT Purchase - where we send EFT to the bank, and then EMAIL to the Vendor the record of the transaction. When we populate the Internet Information field for Email - INET1 - it fails unless we also populate the EmailToAddress field.
It appears that the INET1 field is available for both Customer and Vendor while the EmailToAddress field appears to only be available to the Customer integration.
Request
We would like to use the Integration to draw the email address to the correct field - option 1
If option 1 is a no go, then we would need a script to run against the SY01200 table where it searches for only VEN Types and then sets the EmailToAddress field equal to the INET1 field.
Brain Drain
I know I have done this hundreds of times in the past, but I can not for the life of me get my head around the script to set the EmailToAddress = INET1 where Master_Type = 'Ven' and well, you get it - I am drawing a blank.
Thanks in advance for your assistance.
