Remittance Payment amount expression for email subject line.
Posted: 14 Nov 2013, 12:15
Hi,
I have the following expression generating the subject line of e-mails for my remittances:
"Remittance Advice (Payment Date: " + CString(REMITTANCE.DATE) + " - Ref: " + CString(REMITTANCE.URN) + " - Amount: £" + CString(Sum(Reversed(REMITTANCE.PAYMENT))) + ")"
My intention (for example if sending a remittance for two invoices, one for £100, one for £50, total payment of £150) is to have a subject of:
Remittance Advice (Payment Date: 14/11/2013 00:00:00 - Ref: 0000000 - Amount: £150.00)
however, my expression, using the same example is returning the amount as £100.00? I've reversed it so that the amount doesn't display as a minus and I've summed it so that it displays the total, but I can't figure out why it's only displaying the value of the first item on the remittance instead of the total payment.
Any ideas on what I am doing wrong?
Best regards,
Steve.
I have the following expression generating the subject line of e-mails for my remittances:
"Remittance Advice (Payment Date: " + CString(REMITTANCE.DATE) + " - Ref: " + CString(REMITTANCE.URN) + " - Amount: £" + CString(Sum(Reversed(REMITTANCE.PAYMENT))) + ")"
My intention (for example if sending a remittance for two invoices, one for £100, one for £50, total payment of £150) is to have a subject of:
Remittance Advice (Payment Date: 14/11/2013 00:00:00 - Ref: 0000000 - Amount: £150.00)
however, my expression, using the same example is returning the amount as £100.00? I've reversed it so that the amount doesn't display as a minus and I've summed it so that it displays the total, but I can't figure out why it's only displaying the value of the first item on the remittance instead of the total payment.
Any ideas on what I am doing wrong?
Best regards,
Steve.