This manual is deprecated. Please visit for the latest documentation.

Billing E-mail template variables

From Group-Office Groupware and CRM Documentation
Jump to: navigation, search

Order data

{company_id}		 The company id
{contact_id}		 The contact id
{id}			 The database id of the order
{order_id}		 The textual order ID
{po_id}			 The purchase order ID
{btime}			 The date of the order
{reference}		 The order reference
{total}			 The gross amount of the order 
{subtotal}		 The nett amount of the order
{due_date}               The due date field value (Since 6.0.31)
{due_days}               The due days field value (Since 6.0.31)

Custom fields

Lookup the database name in the custom fields module and use {col_x}.


{customer_countryname} (since 4.1.30)


Combined address field tag:


Separate attribute tags:


Logged in user

For the logged in user fields see this page: Addressbook#Document_templates

Invoice items

You can generate a table of the invoice items like this:

<table style="width: 100%;">
        <td style="text-align: center;"><strong>Amount</strong></td>
        <td style="text-align: right;"><strong>Unit price</strong></td>
        <td style="text-align: right;"><strong>Price</strong></td>
        <td style="text-align: center;">{item_amount}</td>
        <td style="text-align: right;">{item_unit_price}</td>
        <td style="text-align: right;">{item_total}</td>
        <td colspan="3" style="font-weight: bold;"><br />
        Totaal (including VAT):</td>
        <td style="border-top: 1px solid black; font-weight: bold; text-align: right;"><br />
        € {order_total}</td>

Invoice item rows in ODF templates

{vat} VAT Percentage. eg. 19 for 19%
{unit_total} The unit price including VAT.
{unit_list} The unit price from the catalog.
{unit_price} The unit price without VAT
{unit_cost} The unit cost price without VAT
{item_total} The localized item total (amount*unit_total) incl. VAT
{item_subtotal} The localized item total (amount*unit_price) excl. VAT