Skip to main content
Question

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

  • January 20, 2023
  • 1 reply
  • 127 views

Forum|alt.badge.img

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

DavidEichner
Captain II
Forum|alt.badge.img+13

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.

Best,

David