Skip to main content
Solved

ACH Remittance - Formula to add multiple Invoices on a Email Notificaiton Business Event


alevy
Freshman I

I have a ACH Payment Business Event going and I need a way to show multiple RefNbr (Invoice)
on the Notification Template Email that goes out. Single Invoice Paid in a Batch Payments I have no problem it when I select Multiple Invoices.

What is the formula to show multiple invoices on a email notification for ACH Payment?

Here is what I am working with

A ((Document.PaymentMethodID)) Payment has been made by ADMAR Construction Equipment & Supplies.

Payment Reference Number: ((Document.RefNbr))

Payment Date: ((Document.RefNbr.DocDate))

Payment Amount: ((Document.CuryOrigDocAmt))
 

Vendor Ref: ((Adjustments_print.AdjdRefNbr))   ← this works with 1 invoice in a batch and shows the Invoice Ref # we need to show


I tried this below but it breaks the Business Event.

<foreach view="APPost"> ((APPost.SourceRefNbr)) - ((APPost.SourceRefNbr)) </foreach>

Anyhow if anyone has any ideas that would be great. Thank you


 

Best answer by MShields61

The formua works with BE and template, this is how it prints out on the email: 000023 and 000024 are the two invoices being paid with the ACH, so formula needs some adjustments,but it worked!

I know this is an old post,  but I was looking to do the same thing, and came across this post and tested.

View original
Did this topic help you find an answer to your question?

  • Freshman II
  • February 20, 2025

The formua works with BE and template, this is how it prints out on the email: 000023 and 000024 are the two invoices being paid with the ACH, so formula needs some adjustments,but it worked!

I know this is an old post,  but I was looking to do the same thing, and came across this post and tested.


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

@alevy I am using this formules to show all AP invoices/

Invoice Amount

<foreach>

((APInvoice_invoiceNbr))

 </foreach>

<foreach>

((APAdjust_Formulab62b3528a1bb4c3599f995337bfce305))

 </foreach>


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings