Skip to main content
Solved

Import Scenario to import Vendor ACH information


Forum|alt.badge.img

I am trying to create an Import Scenario to import ACH information on a Vendor.  I am using Payment->Default Payment Settings->Payment Instructions to bring in the Account number, Beneficiary Name, Routing Number and Bank name.  Here is my import scenario.

 

The error I am getting is that the 'PaymentMethodID' cannot be empty.

Anyone have any ideas or have an example how you accomplished this?

 

Best answer by MRoszkowski15

I was able to get some help and figured this out.  The line that adds the line number, the Active checkbox needed to be cleared.

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

6 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 29 replies
  • Answer
  • August 31, 2021

I was able to get some help and figured this out.  The line that adds the line number, the Active checkbox needed to be cleared.


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 98 replies
  • January 17, 2023

@MRoszkowski15 , I just had to do this & found this article. 
This was extremely beneficial.
 


Struggling for a few hours and I just found this!! Thanks so much!


  • Jr Varsity I
  • 6 replies
  • November 4, 2023

I would like to add to this post, because I am a visual person and so it gets more hits in the future.  The poster is 100% correct.  But I fell in the trap of not fully reading the post and understanding the post (that part is on me) and I unchecked the wrong box. This is the box to uncheck. It feels contradictory to other import scenarios where Acumatica inserts required system lines for the import to work.  This is the first one where I’ve had to inactivate that line.

Further, the advice in this post applies equally to CAD Canadian localization (and likely other localizations) installed for importing CAD EFT banking info.  The determiner of matching ID’s to lines is determined on the payment method screen » For use in AP Tab.  The Canadian localization will offer the appropriate masks for a typical CAD EFT file syntax.  The Source Field/Info is determined in the Import scenario above based on the title you used in your import Excel file in row 1, but it must match/compliy with the mask information shown below.

I hope this helps more people.  Thanks to the original poster for this post.


Forum|alt.badge.img
  • Jr Varsity II
  • 34 replies
  • May 8, 2024

I have done my scenario exactly like it is above. I keep getting the error. Can someone help?

 


Forum|alt.badge.img
  • Jr Varsity III
  • 42 replies
  • November 15, 2024

@kwilson03 usually that means the vendors not in the system. 


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