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
Revision as of 11:16, 30 July 2010 by Admin (Talk | contribs)

Jump to: navigation, search
%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%