Skip to main content

The GI created using the ARPayment table shows the correct amount of the payment.  However when there are multiple invoices being paid by that invoice, that amount showing as being the amount of the payment is equal to the last invoice, not the total payment made by the client.  This is regardsess of whether or not the formatting equations are used or just the data field.

Notification Generated

The amount shown should be $25876.26

 

Hi @susane18 Is the GI grouped? Is $707.01 a data element that makes up the $25,876.26?

@DConcannon There is no Grouping on the generic inquiry.  Yes, the $707.01 is one of the invoices paid.  

 

We figured out the issue and added a condition to the GI that the payment had to have the status closed.  That fixed the problem.

Thank you for sharing your solution with the community @susane18 !

Reply


Terms & ConditionsCookie settings
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