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 28: Line 28:
 
<pre>
 
<pre>
 
%items_table_start%
 
%items_table_start%
                    <table style="width: 100%;">
+
<table style="width: 100%;">
                        <tbody>
+
<tbody>
                            <tr>
+
    <tr>
                                <td><strong>Description</strong></td>
+
        <td><strong>Description</strong></td>
                                <td style="text-align: center;"><strong>Amount</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>Unit price</strong></td>
                                <td style="text-align: right;"><strong>Price</strong></td>
+
        <td style="text-align: right;"><strong>Price</strong></td>
                            </tr>
+
    </tr>
                            <tr>
+
    <tr>
                                <td>%item_description%</td>
+
        <td>%item_description%</td>
                                <td style="text-align: center;">%item_amount%</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_price_with_vat%</td>
                                <td style="text-align: right;">%item_total%</td>
+
        <td style="text-align: right;">%item_total%</td>
                            </tr>
+
    </tr>
                            <tr>
+
    <tr>
                                <td colspan="3" style="font-weight: bold;"><br />
+
        <td colspan="3" style="font-weight: bold;"><br />
                                Totaal (including VAT):</td>
+
        Totaal (including VAT):</td>
                                <td style="border-top: 1px solid black; font-weight: bold; text-align: right;"><br />
+
        <td style="border-top: 1px solid black; font-weight: bold; text-align: right;"><br />
                                &euro; %order_total%</td>
+
        &euro; %order_total%</td>
                            </tr>
+
    </tr>
                        </tbody>
+
</tbody>
                    </table>
+
</table>
                    %items_table_end%
+
%items_table_end%
 
</pre>
 
</pre>

Revision as of 11:17, 30 July 2010

%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%

Address fields:

%customer_salutation%
%customer_name%
%customer_address%
%customer_address_no%
%customer_zip%
%customer_city%
%customer_state%
%customer_vat_no%
%customer_country%

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%