Skip to content
logo Knowledgebase

Common email subject expressions

Created on  | Last modified on 

Summary

Some common expressions for use with Sage 50 Accounts and Sage 50 Payroll.

Description

You can enter plain text into the subject line, or you can click Subject and enter a dynamic expression into the Expression Editor. We've listed the most common expressions below.

Resolution

Sage 50 Accounts

When applying detailed email settings in Report Designer, you can customise the subject of the email you’re sending.

Description Expression Example
Company name with custom wording COMPANY.NAME + " - your text" Stationery & Computer Mart - Your customised wording
Invoice number and company name INVOICE.INVOICE_OR_CREDIT + " " + INVOICE.INVOICE_NUMBER + " from " + COMPANY.NAME Invoice 246 from Stationery & Computer Mart
Invoice number company name and invoice date INVOICE.INVOICE_OR_CREDIT + " " + INVOICE.INVOICE_NUMBER + " from " + COMPANY.NAME + " - " + DateTimeToFormattedString(INVOICE.INVOICE_DATE, "dd/MM/yyyy") Invoice 246 from Stationery & Computer Mart - 01/01/2019
invoice number for Account x INVOICE.INVOICE_OR_CREDIT + " " + INVOICE.INVOICE_NUMBER + " For " + INVOICE.ACCOUNT_REF Invoice 25 for abc123
Invoice Customer order number and company name "Order" + " " INVOICE.CUST_ORDER_NUMBER + " from " + COMPANY.NAME  Order 123 from Stationery & Computer Mart
Sales Order number and company name SALES_ORDER.ORDER_OR_QUOTE + " " + SALES_ORDER.ORDER_NUMBER + " from " + COMPANY.NAME Sales Order 246 from Stationery & Computer Mart
Sales Order Customer order number and company name SALES_ORDER.ORDER_OR_QUOTE + " " + SALES_ORDER.CUST_ORDER_NUMBER + " from " + COMPANY.NAME Order 123 from Stationery & Computer Mart
Purchase Order number and company name "Purchase Order - " + PURCHASE_ORDER.ORDER_NUMBER + " from " + COMPANY.NAME Purchase Order 246 from Stationery & Computer Mart
Purchase Order Supplier order number and company name "Order - " + PURCHASE_ORDER.SUPP_ORDER_NUMBER + " from " + COMPANY.NAME Order 123 from Stationery & Computer Mart
Statement with company name COMPANY.NAME + " - Statement" Stationery & Computer Mart - Statement
Statement with company name and date

COMPANY.NAME + " - Statement" + " - " + DateTimeToFormattedString(REPORT.DATE, "dd/MM/yyyy")

 Stationery & Computer Mart - Statement - 01/01/2019

Sage 50 Payroll

When applying detailed email settings in Report Designer, you can customise the subject of the email you’re sending.

Description Expression Example
Company name CompanyDetails.Name + " payslip" Stationery & Computer Mart payslip
Full employee name and pay date Employees.Forename + " " + Employees.Surname + " payslip " + DateTimeToFormattedString(DateParameters.ProcessDate,"dd/MM/yyyy") Joe Bloggs payslip 01/01/2026
Employee title, initial, surname and pay date Employees.Title + " " + Employees.Forename + " " + Employees.Surname + " payslip " + DateTimeToFormattedString(DateParameters.ProcessDate,"dd/MM/yyyy") Mr J Bloggs payslip - 01/01/2026

If you don't see the expression you need, you can create your own expression.