I have an excel file that has our external payment reference numbers and our acumatica payment reference numbers but I’ve been unable to successfully import these onto a bank deposit. I’ve been using a mash of 2 older import scenarios with varied success. I can create the bank deposit no problem but adding the payment lines is where I fall short. Here is my latest import scenario version. The Action Save line is on the bottom and not showed in the screen shot. XML attached.
Best answer by SBaldwin
Hey there! I got the import scenario to work. For this import you need to edit the summary details, or you could include them in your data provider.
XML Attached
Utilizing the Payment Ref instead of the Reference Nbr will at least bring lines in, but not the correct payment lines. Highlighted blue
Hey there! I got the import scenario to work. For this import you need to edit the summary details, or you could include them in your data provider.
XML Attached
Thank you for sharing your solution with the community
Posting an update here for any other Import Scenario users who encounter this; Currently in 26R1 Import Scenarios for bank deposits will fail unless Payments are added using the above @@ExtRefNbr mapping.
Acumatica is working on a solution to restore the ability to add payments using other values such as Reference Nbr.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
