Merge Fields

Merge fields allow you to include transaction-specific information in the parts of the invoice template that can be edited. As with many standard mail merge systems, you simply include the field with parentheses around it, ensuring the text has the correct case.

Note: Each of the below sections have their particular applicable merge fields. They do not work in other sections.

Sales and Purchases

The following merge fields should only be used in the line item section of the theme. They MUST be enclosed within the following comment tags:

1
2
3
4
5
6
7
8
9
10
11

<!-- Begin Service Invoice Line Items -->
<!-- Begin Service Invoice Line Item -->
--- Line item merge fields could only be used here ---
<!-- End Service Invoice Line Item -->
<!-- End Service Invoice Line Items -->
 
<!-- Begin Item Invoice Line Items -->
<!-- Begin Item Invoice Line Item -->
--- Line item merge fields could only be used here ---
<!-- End Item Invoice Line Item -->
<!-- End Item Invoice Line Items -->

Also note that ALL the comment tags above MUST exist in the sale and purchase theme. Otherwise, your theme will only work with either a service invoice or an item invoice, but not both. See the existing theme for sample implementation.

Item Invoice Line Items

Service Invoice Line Items

Date Merge Fields

With Date merge field you can display dates using merge fields that can calculate. Calculations are done based on the transaction date.

Some examples are:

1. {Date+0D}
2. {Date+7D}
3. {Date+2W}
4. {Date+1M}

UPDATE:
You now have the ability to combine a range of calculations. For example :
{Date+1M-1Y+15D} or {Date+2W-10D+5w+3M-2M+5D} etc.. you get the idea.

Basically you can keep going with the addition and subtraction of time periods.

Also, there are now 2 new functions:

• {FirstDayOfMonth(“…”)}
• {LastDayOfMonth(“…”)}

These new functions expect a string as the argument. For example:
{FirstDayOfMonth(“23 Aug 12”)} will equal “1 Aug 12”
{LastDayOfMonth(“15 Sep 2012”)} will equal “30 Sep 12”

These new functions provide most benefit when combined with the previous Date calculation. For example:
{FirstDayOfMonth({“Date+1M”})} ß if run in Aug, this would result in “1 Sep 2012”
{LastDayOfMonth({“Date+3M+1Y”})} ß if run in Aug 2012, would result in “30 Nov 2013”

You can use Date merge fields in:

1. description and summary fields in Sales or Purchases.
2. also use them in your Templates and Themes.

This is very useful if you bill for fixed time periods. e.g. If we have an Automated Sale invoice on the 10th of each month that will be recurring we can set up an Automated Sale with the Summary field set to “For {Date+0D} to {Date+1M}” then it will display as “For 10Jan12 to 10Feb12″.

Remittances and Receipts

NOTE: For remittance and receipt templates, add ‘BillingContact’ to the beginning of contact related merge fields. For example, to display the full name of the billing contact, use {BillingContact.FullName}.

Remittance and Receipt Line Items

Contacts

NOTE: For invoice templates, add ‘BillingContact’ or ‘ShippingContact’ to the beginning of the merge field. For example, to display the full name of the billing contact, use {BillingContact.FullName}. This is different to ‘statement’ templates, see the next graph below for instructions on using contact merge fields on ‘statement’ templates.

{AcceptCheque}Returns “true” or “false”

Statements

The following merge fields should only be used in the line item section of the theme.

Outstanding Invoices

Payslips

The following merge fields should only be used in the line item section of the theme.

They MUST be enclosed within the following comment tags:

1
	2
	3
	4
	5

<!-- Begin Wages And Salaries Pay Item -->...<!-- End Wages And Salaries Pay Item -->
	<!-- Begin Deductions Pay Item -->...<!-- End Deductions Pay Item -->
	<!-- Begin PAYG Witholding Pay Item -->...<!-- End PAYG Witholding Pay Item -->
	<!-- Begin Employer Contributions Pay Item -->...<!-- End Employer Contributions Pay Item -->
	<!-- Begin Entitlements Pay Item -->...<!-- End  Entitlements Pay Item -->

Please see the existing payslip theme for sample implementation.

Common Merge Fields

The following are merge fields that could be used across all Templates and Themes.

Using Sales and Purchase Merge Fields

For example, if you were to include the text,

Remittance advice for invoice number {InvoiceNumber} dated {Date}. The amount outstanding is {BalanceDue} {Ccy.Code}.

Then this would appear on the PDF,

Remittance advice for invoice number 001 dated 01-Jul-02. The amount outstanding is 100 AUD.

Referencing Image Files

You can upload and reference image files in Saasu to add images to your documents. Follow these steps:

1. Select View > Templates > Open the template you wish to add images to.
2. Use the Upload link beside your logo file to load one or more images into your Saasu file.
3. When you have finished uploading these files, change this back to your standard logo image before saving.
4. In your HTML code template (or in your theme code), use the following merge field: {Image.Url} followed by your image name. For example:

   1	<img alt="" src="{Image.Url}MySecondImage.jpg" />

5. Click Preview to check that your image file is displaying.

Merge Fields Rules

• Case sensitive – {Date} is not the same as {date}.
• Merge fields don’t always match the field caption in the screens. Only use the merge fields listed in the tables above.

Dynamically displayed information

You are able to display information dynamically an example would be to show certain information based on the type of transaction. For example: you want to show a certain block of text when printing Quotes, but a different block of text when printing Invoices. This would be reflected as such:

<span class=”show-inline-{IsInvoice}”>invoice text</span>

<span class=”show-inline-{IsQuote}”>quote text</span>

This is achieved through the use of the standard CSS class (which is included in inbuilt Themes):

.show-inline-true, .hide-inline-false {
display: inline;
}

So if you add the above HTML within the tag it should display fine, but feel free to contact our service team if you have any issue with this.