Question

Import scenario for AR payment and apply to invoice

  • 18 March 2021
  • 4 replies
  • 92 views

I need to have an import scenario that records the payment and applies the payment to the related invoice or invoices.  I started using the one included but I am getting the error:

The system failed to commit the adjustment rows.

Here is a screenshot of the application section of my import.

 

Any help would be appreciated.

Thanks...coleen


4 replies

Userlevel 6
Badge +3

HI @coleenmcnally22 

I tried in my local instance and working as expected. Please find the attached screenshot for import scenario.

 

Hope this helps!!

 

Hi @Naveen B 

are you applying to multiple invoices or just one invoice?

Userlevel 6
Badge +3

@coleenmcnally22  I did verify the above import scenario with only one invoice and observed working as expected!

@coleenmcnally22 

We have an import scenario working for applications to multiple invoices in version 2020 R2 but we are not applying cash receipts to specific lines of the invoices. 

The one notable difference is in our scenario the Financial Details → Link to GL row is positioned before the Payment Summary Payment Ref. row before the Documents to Apply section.

Also we do not have the Commit check box selected on the Documents to Apply Doc Type row.

I recall having similar issues with the out of the box import scenario in 2020 R2 and we ended up creating a custom one.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved