2
<document filename="test.pdf">
3
<template pageSize="(595.0,842.0)" title="Test" author="Martin Simon" allowSplitting="20">
4
<pageTemplate id="first">
5
<frame id="first" x1="42.0" y1="28.0" width="511" height="786"/>
9
<blockTableStyle id="Standard_Outline">
10
<blockAlignment value="LEFT"/>
11
<blockValign value="TOP"/>
13
<blockTableStyle id="Tableau2">
14
<blockAlignment value="LEFT"/>
15
<blockValign value="TOP"/>
17
<blockTableStyle id="Table1">
18
<blockAlignment value="LEFT"/>
19
<blockValign value="TOP"/>
20
<lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
21
<lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
22
<lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
23
<lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
24
<lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
25
<lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
26
<lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
27
<lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
29
<blockTableStyle id="Table3">
30
<blockAlignment value="LEFT"/>
31
<blockValign value="TOP"/>
32
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
33
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
34
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
35
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
36
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="4,-1" stop="4,-1"/>
37
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="5,-1" stop="5,-1"/>
38
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="6,-1" stop="6,-1"/>
39
<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="7,-1" stop="7,-1"/>
41
<blockTableStyle id="Table2">
42
<blockAlignment value="LEFT"/>
43
<blockValign value="TOP"/>
44
<lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
45
<lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
46
<lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
47
<lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
48
<lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
50
<blockTableStyle id="Table4">
51
<blockAlignment value="LEFT"/>
52
<blockValign value="TOP"/>
53
<lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
54
<lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
55
<lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
58
<paraStyle name="all" alignment="justify"/>
60
<paraStyle name="Standard" fontName="Times-Roman"/>
61
<paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
62
<paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
63
<paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
64
<paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
65
<paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
66
<paraStyle name="Index" fontName="Times-Roman"/>
67
<paraStyle name="Heading" fontName="Helvetica" fontSize="15.0" leading="19" spaceBefore="12.0" spaceAfter="6.0"/>
68
<paraStyle name="Footer" fontName="Times-Roman"/>
69
<paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
70
<paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
71
<paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
72
<paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
73
<paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
74
<paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
75
<paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
76
<paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
77
<paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
78
<paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
79
<paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
80
<paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
81
<paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
82
<paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
83
<paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
84
<paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
85
<paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
86
<paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
87
<paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
88
<paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
92
<para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
93
<para style="terp_default_8">[[ setLang(o.lang) ]]</para>
94
<blockTable colWidths="286.0,223.0" style="Tableau2">
97
<para style="terp_default_9">[[ repeatIn(adr_get(o, 'invoice'),'addr') ]]</para>
100
<para style="terp_default_9">[[ o.name ]]</para>
101
<para style="terp_default_9">[[ addr['street'] or removeParentNode('para') ]]</para>
102
<para style="terp_default_9">[[ addr['street2'] or removeParentNode('para') ]]</para>
103
<para style="terp_default_9">[[ (addr['city'] and (addr['city']+',')) or '']] [[ addr['state_code'] or '']] [[ addr['zip'] or '']] </para>
104
<para style="terp_default_9">[[ addr['country_id'] or removeParentNode('para')]]</para>
105
<para style="terp_default_9">
106
<font color="white"> </font>
108
<para style="terp_default_9">VAT: [[ o.vat or removeParentNode('para') ]]</para>
112
<para style="terp_default_8">
113
<font color="white"> </font>
115
<para style="terp_default_8">
116
<font color="white"> </font>
118
<para style="terp_default_9">Document: Customer account statement</para>
119
<para style="terp_default_9">Date: [[ formatLang(time.strftime('%Y-%m-%d'),date=True) ]]</para>
120
<para style="terp_default_9">Customer Ref: [[ o.ref or ' ']]</para>
121
<para style="terp_default_9">
122
<font color="white"> </font>
124
<para style="terp_default_9">Dear Sir/Madam,</para>
125
<para style="terp_default_9">
126
<font color="white"> </font>
128
<para style="terp_default_9">Exception made of a mistake of our side, it seems that the following bills stay unpaid. Please, take appropriate measures in order to carry out this payment in the next 8 days.</para>
129
<para style="terp_default_9">
130
<font color="white"> </font>
132
<para style="terp_default_9">[[ message(o, company) ]]</para>
133
<para style="terp_default_9">
134
<font color="white"> </font>
136
<para style="terp_default_9">Best regards.</para>
137
<para style="terp_default_9">
138
<font color="white"> </font>
140
<blockTable colWidths="56.0,136.0,51.0,72.0,54.0,56.0,66.0,18.0" style="Table1">
143
<para style="terp_tblheader_Details">Date</para>
146
<para style="terp_tblheader_Details">Description</para>
149
<para style="terp_tblheader_Details_Centre">Ref</para>
152
<para style="terp_tblheader_Details_Centre">Maturity date</para>
155
<para style="terp_tblheader_Details_Right">Due</para>
158
<para style="terp_tblheader_Details_Right">Paid</para>
161
<para style="terp_tblheader_Details_Right">Maturity</para>
164
<para style="terp_tblheader_Details_Centre">Li.</para>
169
<para style="terp_default_8">[[repeatIn(getLines(o), 'line') ]]</para>
170
<blockTable colWidths="56.0,136.0,52.0,71.0,55.0,56.0,66.0,17.0" style="Table3">
173
<para style="terp_default_9">[[ formatLang(line['date'],date=True) ]]</para>
176
<para style="terp_default_9">[[ line['name'] ]]</para>
179
<para style="terp_default_Centre_9">[[ line['ref'] ]]</para>
182
<para style="terp_default_Centre_9">[[ line['date_maturity'] and formatLang(line['date_maturity'],date=True) or '' ]]</para>
185
<para style="terp_default_Right_9">[[ (line['account_id']['type'] == 'receivable' and formatLang(line['debit']) or 0) or (line['account_id']['type'] == 'payable' and formatLang(line['credit'] * -1) or ' ') ]] </para>
188
<para style="terp_default_Right_9">[[ (line['account_id']['type'] == 'receivable' and formatLang(line['credit']) or 0) or (line['account_id']['type'] == 'payable' and formatLang(line['debit'] * -1) or 0) ]]</para>
191
<para style="terp_default_Right_9">[[ company.currency_id.symbol ]][[ formatLang((line['date_maturity'] < time.strftime('%Y-%m-%d'))) and formatLang(line['debit'] - line['credit']) ]] </para>
194
<para style="terp_default_Centre_9">[[ line['blocked'] and 'X' or '' ]]</para>
199
<blockTable colWidths="244.0,71.0,56.0,56.0,66.0,17.0" style="Table2">
202
<para style="terp_default_8">
203
<font color="white"> </font>
207
<para style="terp_default_Bold_9">Sub-Total : </para>
210
<para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + ((y['account_id']['type'] == 'receivable' and y['debit'] or 0) or (y['account_id']['type'] == 'payable' and y['credit'] * -1 or 0)), getLines(o), 0))) ]] </para>
213
<para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + ((y['account_id']['type'] == 'receivable' and y['credit'] or 0) or (y['account_id']['type'] == 'payable' and y['debit'] * -1 or 0)), getLines(o), 0))) ]] </para>
216
<para style="terp_default_Right_9">[[ company.currency_id.symbol ]][[ formatLang((reduce(lambda x, y: x + (y['debit'] - y['credit']), filter(lambda x: x['date_maturity'] < time.strftime('%Y-%m-%d'), getLines(o)), 0))) ]] </para>
219
<para style="terp_default_9">
220
<font color="white"> </font>
225
<blockTable colWidths="250.0,66.0,62.0,131.0" style="Table4">
228
<para style="terp_default_8">
229
<font color="white"> </font>
233
<para style="terp_default_Bold_9">Balance : </para>
236
<para style="terp_tblheader_Details_Right">[[ company.currency_id.symbol ]][[ formatLang((reduce(lambda x, y: x +(y['debit'] - y['credit']), getLines(o), 0))) ]] </para>
239
<para style="terp_default_8">
240
<font color="white"> </font>
245
<para style="terp_default_9">
246
<font color="white"> </font>
248
<para style="terp_default_9">
249
<font color="white"> </font>
251
<para style="terp_default_9">Total amount due: [[ company.currency_id.symbol ]][[ formatLang((reduce(lambda x, y: x + (y['debit'] - y['credit']), getLines(o), 0))) ]] .</para>
252
<para style="terp_default_8">
253
<font color="white"> </font>