Skip to main content
Answer

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

  • September 28, 2022
  • 4 replies
  • 244 views

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

 

Best answer by susane18

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.

4 replies

DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • September 28, 2022

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


  • Author
  • Jr Varsity II
  • September 28, 2022

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

 


  • Author
  • Jr Varsity II
  • Answer
  • September 28, 2022

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
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • September 28, 2022

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