Solved

Email Notification template does not pull in the same numbers as appear in the GI that it is based on.

  • 28 September 2022
  • 4 replies
  • 159 views
S
Rank

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

 

icon

Best answer by susane18 28 September 2022, 23:55

View original

4 replies

DConcannon
Rank
Userlevel 6
Badge +2

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

S
Rank

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

 

S
Rank

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.

Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

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