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.

Note: Cannot use {OrdStart/End}, {MthYear} and {RecSvcDate} together within same template.
Note: Cannot use {SFNoAll} and {SFTotalAmt} together with {SFxxx} or {Delxxx} in same template.

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).

GL Mapping Editor Box
You can view the GL mapping info for each document such as Invoice, Cash Sales and more. The info is generated dynamically based on the Bill Items selected.
Tagged:

Leave a Reply

Your email address will not be published. Required fields are marked *