This manual is deprecated. Please visit https://groupoffice.readthedocs.io for the latest documentation. |
Billing E-mail template variables
From Group-Office Groupware and CRM Documentation
Contents
Order data
{order_company_id} The company id {order_contact_id} The contact id {id} The database id of the order {order_id} The testual order ID {po_id} The purchase order ID {order_date} The date of the order {reference} The order reference {order_total} The total amount of the order {order_subtotal} {order_vat}
Customer
{customer_salutation} {customer_name} {customer_address} {customer_address_no} {customer_zip} {customer_city} {customer_state} {customer_vat_no} {customer_country}
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:
{items_table_start} <table style="width: 100{;"> <tbody> <tr> <td><strong>Description</strong></td> <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> </tr> <tr> <td>{item_description{</td> <td style="text-align: center;">{item_amount}</td> <td style="text-align: right;">{item_price_with_vat}</td> <td style="text-align: right;">{item_total}</td> </tr> <tr> <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> </tr> </tbody> </table> {items_table_end}
Invoice item rows in ODF templates
{amount_delivered} {markup} {cost_code} {discount} {vat} VAT Percentage. eg. 19 for 19% {amount} {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 {description} {item_total} The localized item total (amount*unit_total) incl. VAT {item_subtotal} The localized item total (amount*unit_price) excl. VAT