Skip to main content

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?

 

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.


@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!


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.


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

 


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


Reply