Skip to main content
Solved

(ACH data) Default Payment Settings for Vendors Import Question


martingaxiola
Varsity I
Forum|alt.badge.img

Dear Community,

 

I am pulling my hair with this one, I am trying to import ACH information for a Client, but I am getting my import scenario not working and putting information on other rows of the ACH table. Also, the name is givinme issues, but I feel is related to the same problem as I am getting that the data does not pass validation. This is my Payment Method Details:

ID Description Required Sort Order Entry Mask Validation Reg. Exp.
1 Beneficiary Account No: False     ^\d{1,17}$
2 Beneficiary Name: False     ^([\w]|\s){0,22}$
3 Bank Routing Number (ABA): False   000000000 ^\d{9,9}$
4 Bank Name: False     ^([\w]|\s){0,22}$
5 Account Type (Checking/Saving) False      

 

attached is the import scenario, I look at the other discussion, but could not understand the solution in that one. 

 

Thank you.

Best answer by Laura02

Hello, I tested your import scenario.

In my demo, I made only 2 changes on the Import by Scenario screen: I changed vendor ID and I changed Checkbook ID (Payment method) from AP To FEDWIRE (to match similar payment method in my Demo).

For this first test, I made no changes to your Import Scenario. The scenario imports successfully, shows no errors, but imports only the Payment Method & Account type.

Next I made 2 changes to your import scenario: I added single quotes around the Line Numbers, and I matched the Commit column checkmarks to the sample import in the community post link you provided.

Now the Vendor is updated:

 

View original
Did this topic help you find an answer to your question?

4 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3101 replies
  • Answer
  • August 16, 2022

Hello, I tested your import scenario.

In my demo, I made only 2 changes on the Import by Scenario screen: I changed vendor ID and I changed Checkbook ID (Payment method) from AP To FEDWIRE (to match similar payment method in my Demo).

For this first test, I made no changes to your Import Scenario. The scenario imports successfully, shows no errors, but imports only the Payment Method & Account type.

Next I made 2 changes to your import scenario: I added single quotes around the Line Numbers, and I matched the Commit column checkmarks to the sample import in the community post link you provided.

Now the Vendor is updated:

 


martingaxiola
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 101 replies
  • August 16, 2022

Thank you, yes, I was about to come back to leave a feedback here. Also, important that we found out testing with Rodrigo from Acumatica, that the import has to be into no data inputed before for the Payment Method and Cash Account, if not, it will give you an ID error not found or BAAccount error. I did a quick delete payment method import before I started again with my import and that did the trick. Also, my Payment Method Detils from Payment Methods setup are set to NOT REQUIRED.

 

 

Thank you so much for your response!!


  • Jr Varsity II
  • 9 replies
  • February 3, 2023

Can someone advise me why instead of <Line Number>, @@DetailID is used here? I mean, how do you know @@DetailID is the field name?


Forum|alt.badge.img
  • Jr Varsity III
  • 42 replies
  • April 11, 2023

@totochow 

 

It’s looking at the Payment Method Details on the “Setting For Use In AP” tab of the Payment Method screen. It’s calling out that ID column on the import scenario by using the @@DetailID. 

 

Hope this helps. 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings