Keywords - Sales quotes

Available Custom Fields for a Sale

For use between {{#foreach Sale}} and {{/foreach Sale}} blocks

Keywords	Notes
Organisation
{{Organisation.Name}	Ref: GlobalSettings->Company->General(Tab)->Organisation(Section)->CompanyName
{{Organisation.Address}}	Ref: GlobalSettings->Company->Sales&Purchases(Tab)->Invoicing(Section)->PostalAddress
Customer
{{Customer.Name}}
{{Customer.CombinedPostalAddress}}	A concatenation of the customers postal (invoicing) address, containing the "non blank" fields of ... Address1,Address2,Suburb,(City and PostCode), State
{{CustomerRef}}
{{SupplierNumber}}
Customer - Contact
{{Contact.Name}}	The details of the contact specified on the SO OR the default specified in the Customer profile
{{Contact.Phone}}
{{Contact.Mobile}}
{{Contact.email}}
Delivery Details
{{LocationName}}
{{LocationCode}}
{{DeliveryAddress}}
{{SpecialInstructions}}
Order Details
{{SaleNo}}
{{UserName}}	The Sales Person creating the Sales Order
{{Description}}
{{Status}}
{{PricingLevelCode}}
{{PricingLevelName}}
Dates
{{CurrentDate}}	Always the now date , at the time of printing
{{EnteredDate}}	Date the Sales Order was initially created - format = d Mmm YYYY (e.g. 4 Jan 2021)
{{EnteredDateLong}}	- format = DoW d Mmm YYYY (e.g. Monday 4 January 2021)
{{EffectiveDate}}	The optionally modified date (e.g. retrospective SO entry)- format = d Mmm YYYY (e.g. 4 Jan 2021)
{{EffectiveDateLong}}	- format = DoW d Mmm YYYY (e.g. Monday 4 January 2021)
Values
{{Currency}}
{{TaxCode}}
{{TaxName}}
{{TaxRate}}
{{TotalTax}}
{{TotalExclTax}}
{{TotalInclTax}}
Invoice
{{ExternalInvoiceNo}}	The Xero Invoice Number generated when the SO is submitted to Xero
{{InvoiceNote}}
{{BrandingThemeId}}	The Xero Branding ID
{{ExtAccTrackinId1}}	As per Xero Tracking Category
{{ExtAccTrackinId2}}

Available Sale Line fields:

For use between {{#foreach SaleLines}} and {{/foreach SaleLines}} blocks

Keywords	Notes
Structure
{{RowOrder}}	Integer value
Item Details
{{ItemCode}}
{{ItemName}}
{{Description}}	As above (Item Name), optionally, modified on a Sale Order line
{{ItemCategoryName}}
{{ItemReference}}	Original item reference as set up in the material item if no item associated, this is null
{{itemSku}}	SKU value from Material Item details
Values
{{Quantity}}
{{DiscountAmount}}	The discount percentage
{{Discount}}	as above, dollar formatted
{{TaxRateAmount}}	Original item cost as set up in the material item if no item associated, this is null
{{Tax}}	dollar formatted
{{LineTotalExTax}}	dollar formatted
{{LineTotalIncTax}}	dollar formatted
Values - Charge
{{ItemChargeAmount}}	Original item charge as set up in the material item if no item associated, this is null
{{ItemCharge}}	as above, dollar formatted
{{ItemChargeCurrency}}
{{ChargeAmount}}	The actual per item price as recorded in the sales order
{{Charge}}	as above, dollar formatted