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.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Remittance Payment amount expression for email subject line.
Remittance Payment amount expression for email subject line.
- Sage 50 Accounts Professional 2016 Subscription
- Sage 50 Payroll
- Sage 50 HR 2010
- Sage 50 Forecasting 2007
- Sage 50 Payroll
- Sage 50 HR 2010
- Sage 50 Forecasting 2007
- brucedenney
- Site Admin
- Posts: 4629
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Remittance Payment amount expression for email subject l
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 :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 11 guests