In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Import EFT information
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: