Good morning!
I am hoping for some help please with constructing a new expression to determine the subject line of an email when sending 1 or multiple invoices.
On both of the templates I mainly use, the current expression under Report; Email Settings; Subject is:
"Invoice " + INVOICE.INVOICE_NUMBER + " from " + COMPANY.NAME
So if I am just sending one invoice, say no 123, the email subject line will read "Invoice 123 from *our company name*" which is fine.
However, if I am sending multiple invoices to one customer the invoices will attached as a file per invoice all to the same email - I am happy with this as I think customers would get annoyed receiving 10 emails for 10 invoices. Annoyingly though, the subject bar only picks up the 1st invoice number, and will still read "Invoice 123 from *our company name*" even if invoices 456 & 789 are also attached.
One of our suppliers uses sage (assuming so as they have a sage pay button), and their subject bar varies depending on how many invoices are attached. So if they just sent one invoice it's "Invoice 112233 from *their company name*", but if they send multiple it's just "Invoices from *their company name*"... Can you please help me to construct an expression so that our subject line would read something similar to theirs?
It probably doesn't seem like it's that big a deal, but a customer recently used it as an excuse to only pay 1 of 3 invoices attached to an email
I am on version 25.1.128.0 if that helps.
Any help would be greatly appreciated!!
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
Emailing Invoices - Subject Line
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Emailing Invoices - Subject Line
The issue is that the invoice.invoice_number variable is a number so you are trying to add a number to a string and that doesn't work.
You can fix this by using the cstring function to convert it to a string.
CSTRING(INVOICE.INVOICE_NUMBER)+" my text" + TABLE.STRING_VARIABLE
You can fix this by using the cstring function to convert it to a string.
CSTRING(INVOICE.INVOICE_NUMBER)+" my text" + TABLE.STRING_VARIABLE
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.
Re: Emailing Invoices - Subject Line
Thank you brucedenney
I'm not familiar with the CSTRING function and that doesn't seem to want to work for me
I'm not familiar with the CSTRING function and that doesn't seem to want to work for me
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Emailing Invoices - Subject Line
I think your other supplier must be using 2 different layouts as it is not possible to "know" how many invoices are attached.
Think about a scenario such as 2 invoices a credit note a proforma and a quotation all on one email.
Sorry about the confusion I need to read things more thoroughly.
Think about a scenario such as 2 invoices a credit note a proforma and a quotation all on one email.
Sorry about the confusion I need to read things more thoroughly.
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.
Re: Emailing Invoices - Subject Line
No problem thank you for your help
Who is online
Users browsing this forum: No registered users and 5 guests