Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Remittance Payment amount expression for email subject line.

Report design issues and solutions.
Post Reply
Posts: 19
Joined: 17 Jun 2011, 07:51
Sage Version: v2013 19 UK/Europe/Africa

Remittance Payment amount expression for email subject line.

Post by iStevie » 14 Nov 2013, 12:15


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,
- Sage 50 Accounts Professional 2016 Subscription
- Sage 50 Payroll
- Sage 50 HR 2010
- Sage 50 Forecasting 2007

User avatar
Site Admin
Site Admin
Posts: 4237
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Remittance Payment amount expression for email subject l

Post by brucedenney » 14 Nov 2013, 13:02

The PAYMENT field is not a sum, it is just the one that is present at the time the subject in the email is generated. (Probably the first or the last)
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests