Billing Template allows automatic generation of billing information to be configured for each document. It also includes the double-entry presets to be used for accounting posting purpose.
Template for Bill Items
Item Template Reference
- {BillAmt} – Amount to be billed
- {BillDesc} – Standard billing description (from S/F)
- {BillNo} – Current billing number
- {BillingTotal} – Total number of billings
- {DelPrice} – Price of item/target stated in deliverables
- {DelUPrice} – Unit price of item/target stated in deliverables
- {DelQty} – Qty of item/target stated in deliverables
- {OrdStart} – Order start date
- {OrdEnd} – Order end date
- {MthYear} – Month and year (user will be prompted later)
- {PrjTitle} – Project Title / Contract Remarks
- {LastSvcDate} – Recent service (actual date, if N/A, uses sched.)
- {NextSvcDate} – Next Schedule Date
- {SetAmt} – Amount from Order Set
- {SetTitle} – Set Title
- {StartDate} – Date Start (based on Main Form, otherwise based on the details if Main Form is empty)
- {EndDate} – Date End (Same as above)
- {svcaddr} – Service Address
- {SvcDesc} – Service / Treatment Description
- {targets} – List of targets for selected location
- {SFNoAll} – Show all service form number
- {SFTotalAmt} – Get total amount from all service form
- {SFNo} – Service Form Number
- {SFSetTitle} – Order Set Title whereby a Service Form being attached
- {SFDate} – Service Form Date
- {SFTag} – Service Tag
- {SFLastQty} – Last Meter / Qty Billed
- {SFCurrQty} – Current Meter / Qty
- {SFTargets} – List of Targets in Service Form
- {SFItems} – List of Tracked Items in Service Form
- {SFRemarks} – Remarks entered in the Service Form
- {SFTeam} – Teams in Service Form
- {/n} – Empty Row
- {header} – Followed by default header wordings
- {footer} – Followed by default footer wordings
- {donotes} – Followed by default D/O notes wordings
You can now specify the {targets} tag as below:fixed keywords:
{targets freq \ntargets}
whereby:
{targets = opening tag
/targets} = closing tag
targets = to show the targets
freq = to show the frequency per annum
\n = new line on every targets
\, = comma on every targets
For example:
{targets freq X / Annum\n/targets}
it will shown as:
Cockroaches 12 X / Annum
Rats 6 X / Annum
However, you can only specify one format per billing templates.
Template for GL Accounts
To access the definition of GL and Trade mappings, click on the Total label in Bill Items page to reveal the footer box for editing (as below).
