Hi Community and thank you for your support.
I am using Integration Manager within our Payables department to pick up a .csv file and drop fields such as 'Batch ID', 'Vendor ID', 'Document Number' and 'Purchases' to the Payables Transaction Entry window. So far so good. However, I would like to go a step further by including vendors' 'Account Number' and 'Routing Number' within the .csv in order to map to the Vendor EFT Bank Maintenance window. Our vendors' bank information can change with each payable, therefore it is important to our department to capture the change within the .csv rather than setting and forgetting each vendor's information. The Vendor EFT Bank Maintenance window is not a destination, nor are these window's fields included within Destination Mapping.
Therefore, my research has led me to believe that I need to develop an After Document script to pick up the 'Account Number' and 'Routing Number' fields from the .csv and input these fields into the SY06000 table. For simplicity, my .csv refers to these fields as 'AccountNum' and 'RoutingNum', respectively. I do not have eConnect nor SmartConnect. I am very comfortable with VBA, and I've navigated to Integration>Properties>Scripts, where then writer's block strikes hard.
Can someone please provide a snippet of code that captures something along the same lines, where fields are picked up from a .csv and input into a specific GP window's fields? I can manipulate the code thereafter - I really just need something to get the gears turning.
Thank you very much.
