When sending out documents such as Invoices and Purchase Orders to Customers and Suppliers via email, the email ‘subject’ and ‘body’ requires some politely worded text. Within that ‘fixed’ text you often want to insert some ‘variable’ words pertaining to the document being sent. For example, you may want to highlight your invoice number and the customer’s order number for reference purposes: ‘Please find attached invoice. Our Reference: 1234. Your Order Number: ABCD.’
To achieve this, a special syntax is used where you enter a ‘placeholder’ in the email text that signifies the point where ‘data’ should be inserted. When the email is sent, the placeholder is replaced with the relevant data within the fixed text defined for the particular document email.
The placeholder terms must be surrounded by two sets of brackets so that the system can identify them and replace them entirely with the data when required. For instance, to show the document number being emailed, include the syntax ((DOCNO)) in the subject, body or attachment name section.
Below is the list of ‘placeholder’ terms that can be used for each type of document. Use the exact case as noted and surround the inserted syntax with double parentheses.
AR Debtors Statement
- CUSNO – the customer code/number whose statement is being sent
- DATE – the date of the statement
- DOCNO – the statement number
- USERCODE – the user code of the user sending the statements
- USERNAME – the user’s name of the user sending the statements
- BRANCHNAME – the name of the branch the customer is associated with
AR & Order Management – Invoice/Credit Reprints
- DATE – the date of the invoice/credit being sent
- DOCNO – the reference number of the invoice/credit being sent
- ORDNO – the original Sales Order/Docket number of the invoice/credit being sent
- USERCODE – the user code of the user sending the invoice/credit
- USERNAME – the user’s name of the user sending the invoice/credit
Order Management – Order Dockets – individually submitted
- DATE – the date of the order docket being sent
- BRANCHNAME – the Name of the Branch the Customer on the order docket belongs to
- DOCNO – the reference number of the order docket being sent
- ORDNO – the reference number of the order docket being sent
- CUSORDNO – the customer’s order number of the docket being sent
- USERCODE – the user code of the user sending the order docket
- USERNAME – the user’s name of the user sending the order docket
- QUOTEDATE – for quotes – this is the date the quote is valid until
Order Management – Order Dockets – a batch run
- DATE – the date of the order docket being sent
- DOCNO – the reference number of the order docket being sent
- ORDNO – the reference number of the order docket being sent
- USERCODE – the user code of the user sending the order docket
- USERNAME – the user’s name of the user sending the order docket
Order Management – Back Order Statement
- CUSNO – the customer code/number whose statement is being sent
- DATE – the date of the statement being sent
- DOCNO – the reference number of the statement being sent
- USERCODE – the user code of the user sending the statement
- USERNAME – the user’s name of the user sending the statement
AP Remittance Advice
- CRNO – the Supplier code/number who’s being paid
- DATE – the date of the remittance
- DOCNO – the remittance number
- USERCODE – the user code of the user sending the remittance
- USERNAME – the user’s name of the user sending the remittance
Purchasing Request for Quote
- CONTACTNAME – contact name of contact set to received document
- DOCNO – RFQ number
- BUYERNAME – buyer’s name
- USERNAME – user’s name
- REQDATE – date a response to the RFQ is required by
Point Of Sale (POS) Dockets
- USERID – inserts the user code of the logged in user
- REP.CODE – inserts the till operator code of the signed in operator
- TODAY – inserts current system date
- TIME – inserts current system time
- TIMEDATE – inserts current system time and date
- ABN – inserts ABN as set up in company details
- CO.NAME – inserts company name as set up in company details
- CO.PHONE – inserts phone number as set up in company details
- CO.ADDR – inserts address as set up in company details
e-Commerce – Order Confirmation
- CUSNO – the customer code/number from the order docket being sent
- CUSNAME – the customer’s name from the order docket being sent
- CUSORDNO – the customer order number from the order docket being sent
- DATE – the date of the order docket being sent
- DOCNO – the reference number of the order docket being sent
- ORDNO – the reference number of the order docket being sent
- USERCODE – the user code of the user sending the order docket
- USERNAME – the user’s name of the user sending the order docket
- SUBMITTEDBYNAME – Contact name as entered for the e-commerce order
- SUBMITTEDBYPHONE – Contact phone as entered for the e-commerce order
- SUBMITTEDBYEMAIL – Contact email as entered for the e-commerce order
e-Commerce – Price List
- CUSNO – the customer code/number related to the B2B user requesting the price list
- DATE – the date of the request to send the price list
- USERCODE – the user code of the B2B user who requested the price list to be sent
- USERNAME – the user’s name of the B2B user who requested the price list to be sent
e-Commerce – B2B User Registration
- ACCNUM – the customer code/account number requesting user registration
- ACCNAME – the customer/account name of the customer requesting user registration
- PASSWORD – the user password automatically allocated to allow them to login to the B2B portal
- USERCODE – the user code of the B2B user allocated by the user registration process
- USERNAME – the user’s name of the B2B user allocated by the user registration process
Use Standard Stationery Messages to set up the email text for each document.