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
(New page: <pre> %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 %or...)
 
Line 22: Line 22:
 
%customer_vat_no%
 
%customer_vat_no%
 
%customer_country%
 
%customer_country%
 +
</pre>
 +
 +
You can generate a table of the invoice items like this:
 +
 +
<pre>
 +
%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 />
 +
                                &euro; %order_total%</td>
 +
                            </tr>
 +
                        </tbody>
 +
                    </table>
 +
                    %items_table_end%
 
</pre>
 
</pre>

Revision as of 10:16, 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%