Import Scenario - Payment - AR 0Field: Payment Amount, Value: 720.69, Warning: The document is out of the balance.

  • 20 January 2023
  • 1 reply

Userlevel 5

Good day,

I have a giant payment import for over 746 invoices. The invoice totals = payment amounts.  I am trying to produce one payment for all these invoice in one payment record.  The total payment equals the total invoice.

Any suggestions?   I want one payment for 746 invoices.

Thank you 

@Evan G 


1 reply

Userlevel 7
Badge +11

Hi @EvanG 

Take a look at your data connector and specify a key field that is the same value for all of the invoices.  You might have to add a field called payment number and populate it with the same value.  You then would mark that field as the key field and map it in the import scenario profile (even if you have auto numbering turned on).  It then will consider that payment ID as a single payment with the invoices as the data for the apply section.




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 — 2024  Acumatica, Inc. All rights reserved