2 <document filename="Overdue Payments.pdf">
3 <template title="Overdue Payments" author="OpenERP S.A. (sales@openerp.com)" 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="Helvetica"/>
61 <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
62 <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
63 <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
64 <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
65 <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
66 <paraStyle name="Index" fontName="Helvetica"/>
67 <paraStyle name="Heading" fontName="Helvetica" fontSize="15.0" leading="19" spaceBefore="12.0" spaceAfter="6.0"/>
68 <paraStyle name="Footer" fontName="Helvetica"/>
69 <paraStyle name="Horizontal Line" fontName="Helvetica" 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_10" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="2.0"/>
87 <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
88 <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
89 <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
95 <blockTable colWidths="57.0,136.0,51.0,72.0,54.0,56.0,66.0,18.0" style="Table1">
98 <para style="terp_tblheader_Details">Date</para>
101 <para style="terp_tblheader_Details">Description</para>
104 <para style="terp_tblheader_Details_Centre">Ref</para>
107 <para style="terp_tblheader_Details_Centre">Maturity date</para>
110 <para style="terp_tblheader_Details_Right">Due</para>
113 <para style="terp_tblheader_Details_Right">Paid</para>
116 <para style="terp_tblheader_Details_Right">Maturity</para>
119 <para style="terp_tblheader_Details_Centre">Li.</para>
124 <para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
125 <para style="terp_default_8">[[ setLang(o.lang) ]]</para>
126 <blockTable colWidths="286.0,224.0" style="Tableau2">
129 <para style="terp_default_9">[[ repeatIn(adr_get(o, 'invoice'),'addr') ]]</para>
132 <para style="terp_default_9">[[ o.title.name or '' ]] [[ o.name ]]</para>
133 <para style="terp_default_9">[[ addr['street'] ]]</para>
134 <para style="terp_default_9">[[ addr['street2'] or removeParentNode('para') ]]</para>
135 <para style="terp_default_9">[[ addr['zip'] ]] [[ addr['city'] ]]</para>
136 <para style="terp_default_9">[[ addr['state_id'] or removeParentNode('para')]]</para>
137 <para style="terp_default_9">[[ addr['country_id'] ]]</para>
138 <para style="terp_default_9">
139 <font color="white"> </font>
141 <para style="terp_default_9">VAT: [[ o.vat or removeParentNode('para') ]]</para>
145 <para style="terp_default_8">
146 <font color="white"> </font>
148 <para style="terp_default_8">
149 <font color="white"> </font>
151 <para style="terp_default_9">Document: Customer account statement</para>
152 <para style="terp_default_9">Date: [[ formatLang(time.strftime('%Y-%m-%d'),date=True) ]]</para>
153 <para style="terp_default_9">Customer Ref: [[ o.ref or ' ']]</para>
154 <para style="terp_default_9">
155 <font color="white"> </font>
157 <para style="terp_default_9">
158 <font color="white"> </font>
161 <para style="terp_default_8">[[ not getLines(o) and removeParentNode('section')]]</para>
163 <para>[[repeatIn(message(o, company), 'message_line') ]]</para>
164 <para style="terp_default_9">[[ message_line ]]</para>
165 <para style="terp_default_8">
166 <font color="white"> </font>
169 <blockTable colWidths="56.0,136.0,51.0,72.0,54.0,56.0,66.0,18.0" style="Table1">
172 <para style="terp_tblheader_Details">Date</para>
175 <para style="terp_tblheader_Details">Description</para>
178 <para style="terp_tblheader_Details_Centre">Ref</para>
181 <para style="terp_tblheader_Details_Centre">Maturity date</para>
184 <para style="terp_tblheader_Details_Right">Due</para>
187 <para style="terp_tblheader_Details_Right">Paid</para>
190 <para style="terp_tblheader_Details_Right">Maturity</para>
193 <para style="terp_tblheader_Details_Centre">Li.</para>
197 <section>[[repeatIn(getLines(o), 'line') ]]
198 <blockTable colWidths="56.0,136.0,52.0,71.0,55.0,56.0,66.0,17.0" style="Table3">
201 <para style="terp_default_9">[[ formatLang(line['date'],date=True) ]]</para>
204 <para style="terp_default_9">[[ line['name'] ]]</para>
207 <para style="terp_default_Centre_9">[[ line['ref'] ]]</para>
210 <para style="terp_default_Centre_9">[[ line['date_maturity'] and formatLang(line['date_maturity'],date=True) or '' ]]</para>
213 <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>
216 <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>
219 <para style="terp_default_Right_9">[[ time.strftime('%Y-%m-%d') > formatLang((line['date_maturity'])) and formatLang(line['debit'] - line['credit']) ]] [[ company.currency_id.symbol ]]</para>
222 <para style="terp_default_Centre_9">[[ line['blocked'] and 'X' or '' ]]</para>
227 <blockTable colWidths="244.0,71.0,56.0,56.0,66.0,17.0" style="Table2">
230 <para style="terp_default_8">
231 <font color="white"> </font>
235 <para style="terp_default_Bold_9">Sub-Total :</para>
238 <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>
241 <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>
244 <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + (y['debit'] - y['credit']), filter(lambda x: x['date_maturity'] < time.strftime('%Y-%m-%d'), getLines(o)), 0))) ]] [[ company.currency_id.symbol ]]</para>
247 <para style="terp_default_9">
248 <font color="white"> </font>
253 <blockTable colWidths="244.0,71.0,62.0,132.0" style="Table4">
256 <para style="terp_default_8">
257 <font color="white"> </font>
261 <para style="terp_default_Bold_9">Balance :</para>
264 <para style="terp_tblheader_Details_Right">[[ formatLang((reduce(lambda x, y: x +(y['debit'] - y['credit']), getLines(o), 0))) ]] [[ company.currency_id.symbol ]]</para>
267 <para style="terp_default_8">
268 <font color="white"> </font>
273 <para style="terp_default_9">
274 <font color="white"> </font>
276 <para style="terp_default_9">
277 <font color="white"> </font>
279 <para style="terp_default_9">Total amount due: [[ formatLang((reduce(lambda x, y: x + (y['debit'] - y['credit']), getLines(o), 0)), currency_obj=company.currency_id) ]]</para>
281 <para style="terp_default_9">
282 <font color="white"> </font>
285 <para style="terp_default_Bold_9">[[ getLines(o) and removeParentNode('section')]]There is nothing due with this customer</para>
287 <para style="terp_default_9">
288 <font color="white"> </font>
290 <para style="terp_default_8">
291 <font color="white"> </font>