By using this website, you agree to our Terms of Use (click here)
We need to import the banking information for vendors and we arent able to find those tables anywhere on the vendor import. Does anyone have a clue as to where I could find them?
Michael, We did this for a customer in version 2017 R2. The target Object in your import scenario is found in Payment Settings -> Remittance Address. Be sure to set the 'Payment Method' field on the vendor record in Target 'Payment Settings -> Default Payment Settings' to a Payment Method that is defined as ACH. Otherwise the fields are not displayed or accessible on the Vendor Maintenance screen.
Here is an XML definition of the Vendor Import Scenario we created which includes settings for import ACH remittance information.
Here is the XML definition of the Data Provider used to load Vendors.
I hope this helps.
This is exactly what I needed to see, and it's still relevant almost 2 years later! Thank you.
I am trying to perform this same function but I am getting an error message that the PaymentMethodID cannot be empty. (I had to go into the payment method and clear the checkbox for required because I was getting a message that the This field is required) Any rate, here is my Import scenario. I must be missing something or something has changed (I am doing this in 2021 R1). Any help would be appreciated.
Michael - As a consideration, ours scenario omits the 4th step:
@mikerosz No, the 4th line in your screenshot just above the Account Number row. My screenshot shows both the Active and Commit boxes as unchecked - only your Commit box is unchecked by comparison.
@rbrink, were you able to run it? I am trying to run this but only the last column was being imported to payment instruction. I had the line number turned off. Can you share more?
Online Members
