This manual is deprecated. Please visit https://groupoffice.readthedocs.io for the latest documentation.

Difference between revisions of "Billing E-mail template variables"

From Group-Office Groupware and CRM Documentation
Jump to: navigation, search
Line 1: Line 1:
 +
==Order data==
 
<pre>
 
<pre>
 
{order_company_id} The company id
 
{order_company_id} The company id
Line 10: Line 11:
 
{order_subtotal}
 
{order_subtotal}
 
{order_vat}
 
{order_vat}
 +
</pre>
  
Address fields:
 
  
 +
==Customer==
 +
<pre>
 
{customer_salutation}
 
{customer_salutation}
 
{customer_name}
 
{customer_name}
Line 22: Line 25:
 
{customer_vat_no}
 
{customer_vat_no}
 
{customer_country}
 
{customer_country}
 +
</pre>
  
 +
==Logged in user==
 
For the logged in user fields see this page: [Addressbook#Document_templates]
 
For the logged in user fields see this page: [Addressbook#Document_templates]
</pre>
 
  
 +
 +
==Invoice items==
 
You can generate a table of the invoice items like this:
 
You can generate a table of the invoice items like this:
  

Revision as of 14:13, 24 September 2012

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}