~openerp-commiter/openobject-addons/extra-6.0

« back to all changes in this revision

Viewing changes to account_financial_report/report/invoice_list.rml

  • Committer: Borja L.S.
  • Date: 2010-04-07 17:17:06 UTC
  • mto: This revision was merged to the branch mainline in revision 4498.
  • Revision ID: borjals@pexego.es-20100407171706-bdyhd0essc5237g2
[ADD] account_financial_report: Added the module from the 5.0 extra-addons.

  This module from the 5.0 extra-addons was missing on the 
  trunk extra-addons branch.
 
  We have just tested that it works with the 5.2 version.

  The module adds some extra financial/accounting reports:
  * Account chart list
  * Invoice list
  * Account move (journal ledger)
  * Account move line
  * Account balance compared period-fiscal year
  * Cumulative general ledger

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<?xml version="1.0"?>
 
2
<document filename="invoice_list.pdf">
 
3
    <template pageSize="29.7cm, 21cm" title="Invoice List" author="Nicolas Bessi-Jordi Esteve (Zikzakmedia)" allowSplitting="20">
 
4
        <pageTemplate id="first">
 
5
            <frame id="first" x1="1cm" y1="1cm" width="27.7cm" height="19cm"/>
 
6
            <pageGraphics>
 
7
                <!--logo-->
 
8
                <!--<fill color="darkblue"/>-->
 
9
                <!--<stroke color="darkblue"/>-->
 
10
 
 
11
                <!--COL 1-->
 
12
                <setFont name="Helvetica-Bold" size="10"/>
 
13
                <drawString x="0.8cm" y="20cm">[[company.name]]</drawString>
 
14
                <setFont name="Helvetica-Bold" size="9"/>
 
15
                <!--<drawRightString x="19.8cm" y="25.50cm">[[ company.rml_header1 ]]</drawRightString>-->
 
16
                <drawString x="25.8cm" y="20cm">Invoice List</drawString>
 
17
 
 
18
                <!--COL 2-->
 
19
                <setFont name="Helvetica" size="8"/>
 
20
                <drawString x="0.8cm" y="0.9cm">[[formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), date_time=True)]]</drawString>
 
21
                <drawString x="27.5cm" y="0.9cm">Page <pageNumber/></drawString>
 
22
 
 
23
                <lineMode width="0.7"/>
 
24
                <lines>0.8cm 19.8cm 28.8cm 19.8cm</lines>
 
25
                <setFont name="Helvetica" size="8"/>
 
26
            </pageGraphics>
 
27
        </pageTemplate>
 
28
    </template>
 
29
 
 
30
    <stylesheet>
 
31
        <blockTableStyle id="Standard_Outline">
 
32
            <blockAlignment value="LEFT"/>
 
33
            <blockValign value="TOP"/>
 
34
        </blockTableStyle>
 
35
        <blockTableStyle id="Table1">
 
36
            <blockAlignment value="LEFT"/>
 
37
            <blockValign value="TOP"/>
 
38
            <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
 
39
            <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
 
40
            <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
 
41
            <blockBackground colorName="#e6e6e6" start="0,1" stop="0,1"/>
 
42
            <blockBackground colorName="#e6e6e6" start="1,1" stop="1,1"/>
 
43
            <blockBackground colorName="#e6e6e6" start="2,1" stop="2,1"/>
 
44
        </blockTableStyle>
 
45
        <blockTableStyle id="Table2">
 
46
            <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 
47
            <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,1" stop="-1,-1"/>
 
48
            <blockValign value="TOP"/>
 
49
            <blockAlignment value="RIGHT" start="2,1" stop="-1,-1"/>
 
50
        </blockTableStyle>
 
51
        <blockTableStyle id="Table3">
 
52
            <blockAlignment value="LEFT"/>
 
53
            <blockValign value="TOP"/>
 
54
            <blockBottomPadding length="1.0"/>
 
55
            <lineStyle kind="LINEABOVE" colorName="#AAAAAA"/>
 
56
            <blockBackground colorName="white" start="0,0" stop="-1,0"/>
 
57
        </blockTableStyle>
 
58
        <blockTableStyle id="Table3a">
 
59
            <blockAlignment value="LEFT"/>
 
60
            <blockValign value="MIDDLE"/>
 
61
            <lineStyle kind="LINEABOVE" colorName="#888888"/>
 
62
            <blockBottomPadding length="1.0"/>
 
63
            <blockBackground colorName="white" start="0,0" stop="-1,0"/>
 
64
        </blockTableStyle>
 
65
        <blockTableStyle id="Table3b">
 
66
            <blockAlignment value="LEFT"/>
 
67
            <blockValign value="TOP"/>
 
68
            <blockTopPadding length="0.5"/>
 
69
            <blockBottomPadding length="1.0"/>
 
70
            <blockBackground colorName="white" start="0,0" stop="-1,0"/>
 
71
        </blockTableStyle>
 
72
        <blockTableStyle id="Table5">
 
73
            <blockAlignment value="LEFT"/>
 
74
            <blockValign value="TOP"/>
 
75
        </blockTableStyle>
 
76
        <blockTableStyle id="Table4">
 
77
            <blockAlignment value="LEFT"/>
 
78
            <blockValign value="TOP"/>
 
79
            <lineStyle kind="GRID" colorName="black"/>
 
80
        </blockTableStyle>
 
81
        <blockTableStyle id="Theader">
 
82
            <blockAlignment value="LEFT"/>
 
83
            <blockValign value="TOP"/>
 
84
            <lineStyle kind="OUTLINE" colorName="#e6e6e6"/>
 
85
            <blockBackground colorName="white" start="0,0" stop="-1,0"/>
 
86
        </blockTableStyle>
 
87
 
 
88
        <initialize>
 
89
            <paraStyle name="all" alignment="justify"/>
 
90
        </initialize>
 
91
        <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER"
 
92
            spaceBefore="0.0" spaceAfter="6.0"/>
 
93
        <paraStyle name="P2" fontName="Helvetica" fontSize="7.0" leading="10" spaceBefore="0.0"
 
94
            spaceAfter="6.0"/>
 
95
        <paraStyle name="P3" fontName="Helvetica" fontSize="7.0" leading="10" alignment="LEFT"
 
96
            spaceBefore="0.0" spaceAfter="6.0"/>
 
97
        <paraStyle name="P4" fontName="Helvetica" fontSize="7.0" leading="10" alignment="RIGHT"
 
98
            spaceBefore="0.0" spaceAfter="6.0"/>
 
99
        <paraStyle name="P5" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT"
 
100
            spaceBefore="0.0" spaceAfter="6.0"/>
 
101
        <paraStyle name="P6" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0"
 
102
            spaceAfter="6.0"/>
 
103
        <paraStyle name="P7" fontName="Helvetica" fontSize="10.0" leading="14" alignment="RIGHT"
 
104
            spaceBefore="0.0" spaceAfter="6.0"/>
 
105
        <paraStyle name="P8" fontName="Helvetica" fontSize="10.0" leading="14" alignment="RIGHT"
 
106
            spaceBefore="0.0" spaceAfter="6.0"/>
 
107
        <paraStyle name="P9" fontName="Helvetica" fontSize="7.0" leading="10" alignment="RIGHT"
 
108
            spaceBefore="0.0" spaceAfter="6.0"/>
 
109
        <paraStyle name="P9b" fontName="Helvetica-Bold" fontSize="7.0" leading="10"
 
110
            alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
111
        <paraStyle name="P10" fontName="Helvetica" alignment="CENTER"/>
 
112
        <paraStyle name="P11" fontName="Helvetica" fontSize="10.0" leading="14"/>
 
113
        <paraStyle name="P12" fontName="Helvetica" fontSize="14.0" leading="17"/>
 
114
        <paraStyle name="P13" fontName="Helvetica-Bold" fontSize="10.0" leading="8"
 
115
            alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
116
        <paraStyle name="P14" fontName="Helvetica" fontSize="7.0" leading="10" spaceBefore="0.0"
 
117
            spaceAfter="6.0"/>
 
118
        <paraStyle name="P15" fontName="Helvetica-Bold" spaceBefore="0.0" spaceAfter="6.0"/>
 
119
        <paraStyle name="P16" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Roman"
 
120
            fontSize="7.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 
121
        <paraStyle name="P17" fontName="Helvetica" alignment="LEFT" fontSize="12.0" spaceAfter="0.0"/>
 
122
        <paraStyle name="Standard" fontName="Helvetica-Bold" size="9" fontSize="7.5"/>
 
123
        <paraStyle name="Header" fontName="Helvetica-Bold" size="9" fontSize="9"/>
 
124
        <paraStyle name="Account" fontName="Helvetica"/>
 
125
        <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0" fontSize="7.5"/>
 
126
        <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
127
        <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
128
        <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0"
 
129
            spaceAfter="6.0"/>
 
130
        <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13"
 
131
            spaceBefore="6.0" spaceAfter="6.0"/>
 
132
        <paraStyle name="Index" fontName="Helvetica"/>
 
133
    </stylesheet>
 
134
 
 
135
    <story>
 
136
        <para style="Standard">[[setLang(user.context_lang)]]</para>
 
137
        <para style="Standard">
 
138
            <font color="white"> </font>
 
139
        </para>
 
140
        <para style="Header">Customer Invoices [[ (out_invoices or removeParentNode('para')) and '' ]]</para>
 
141
        <section>
 
142
            <section> [[ repeatIn(out_invoices, 'obj') ]] <para style="Standard"> Currency : [[ obj[0] ]] </para>
 
143
                <!--<blockTable colWidths="1.8cm,1.4cm,1.4cm,1.8cm,1.8cm,2cm,3.5cm,2cm,4cm,1.2cm,1.8cm,1.4cm,1.8cm,1.6cm" repeatRows="1" style="Table3">-->
 
144
                <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" repeatRows="1" style="Table3a">
 
145
                    <tr>
 
146
                        <td>
 
147
                            <para style="Standard" size="5">Number</para>
 
148
                        </td>
 
149
                        <td>
 
150
                            <para style="Standard" size="5">External ref.</para>
 
151
                        </td>
 
152
                        <td>
 
153
                            <para style="Standard" size="5">Entry num.</para>
 
154
                        </td>
 
155
                        <td>
 
156
                            <para style="Standard" size="5">Invoice date</para>
 
157
                        </td>
 
158
                        <td>
 
159
                            <para style="Standard" size="5">Due date</para>
 
160
                        </td>
 
161
                        <td>
 
162
                            <para style="Standard" size="5">Partner code</para>
 
163
                        </td>
 
164
                        <td>
 
165
                            <para style="Standard" size="5">Partner</para>
 
166
                        </td>
 
167
                        <td>
 
168
                            <para style="Standard" size="5">Vat</para>
 
169
                        </td>
 
170
                        <!--<td>
 
171
                            <para style="Standard" size="5">Invoice description</para>
 
172
                        </td>-->
 
173
                        <td>
 
174
                            <para style="Standard" size="5">State</para>
 
175
                        </td>
 
176
                        <td>
 
177
                            <para alignment="RIGHT" style="Standard" size="5">Untaxed</para>
 
178
                        </td>
 
179
                        <td>
 
180
                            <para alignment="RIGHT" style="Standard" size="5">Taxes</para>
 
181
                        </td>
 
182
                        <td>
 
183
                            <para alignment="RIGHT" style="Standard" size="5">Total</para>
 
184
                        </td>
 
185
                        <td>
 
186
                            <para style="Standard" size="5">Fiscal position</para>
 
187
                        </td>
 
188
                    </tr>
 
189
                </blockTable>
 
190
                <section>[[ repeatIn(obj[1], 'inv') ]]
 
191
                    <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3">
 
192
                        <tr>
 
193
                            <td>
 
194
                                <para style="Text body">[[inv.number]]</para>
 
195
                            </td>
 
196
                            <td>
 
197
                                <para style="Text body">[[inv.reference]]</para>
 
198
                            </td>
 
199
                            <td>
 
200
                                <para style="Text body">[[inv.move_id.name]]</para>
 
201
                            </td>
 
202
                            <td>
 
203
                                <para style="Text body">[[inv.date_invoice and formatLang(inv.date_invoice, date=True)]]</para>
 
204
                            </td>
 
205
                            <td>
 
206
                                <para style="Text body">[[inv.date_due and formatLang(inv.date_due, date=True)]]</para>
 
207
                            </td>
 
208
                            <td>
 
209
                                <para style="Text body">[[inv.partner_id.ref]]</para>
 
210
                            </td>
 
211
                            <td>
 
212
                                <para style="Text body">[[inv.partner_id.name]]</para>
 
213
                            </td>
 
214
                            <td>
 
215
                                <para style="Text body">[[inv.partner_id.vat]]</para>
 
216
                            </td>
 
217
                            <!--<td>
 
218
                                <para style="Text body">[[inv.name]]</para>
 
219
                            </td>-->
 
220
                            <td>
 
221
                                <para style="Text body">Draft [[ (inv.state=='draft' or removeParentNode('para')) and '']]</para>
 
222
                                <para style="Text body">Pro-forma [[ (inv.state in ['proforma','proforma2'] or removeParentNode('para')) and '']]</para>
 
223
                                <para style="Text body">Open [[ (inv.state=='open' or removeParentNode('para')) and '']]</para>
 
224
                                <para style="Text body">Paid [[ (inv.state=='paid' or removeParentNode('para')) and '']]</para>
 
225
                                <para style="Text body">Cancelled [[ (inv.state=='cancel' or removeParentNode('para')) and '']]</para> 
 
226
                            </td>
 
227
                            <td>
 
228
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_untaxed)]]</para>
 
229
                            </td>
 
230
                            <td>
 
231
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_tax)]]</para>
 
232
                            </td>
 
233
                            <td>
 
234
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_total)]]</para>
 
235
                            </td>
 
236
                            <td>
 
237
                                <para style="Text body">[[inv.fiscal_position.name]]</para>
 
238
                            </td>
 
239
                        </tr>
 
240
                    </blockTable>
 
241
                    <section>[[ repeatIn(detailed_taxes and inv.tax_line or [], 'tax_line') ]]
 
242
                        <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3b">
 
243
                            [[ (tax_line.tax_code_id and tax_line.tax_code_id.notprintable and removeParentNode('blockTable')) or '']]
 
244
                            <tr>
 
245
                                <td>
 
246
                                    <para/>
 
247
                                </td>
 
248
                                <td>
 
249
                                    <para style="Text body" alignment="RIGHT">[[tax_line.name or '']]</para>
 
250
                                </td>
 
251
                                <td>
 
252
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base)]]</para>
 
253
                                </td>
 
254
                                <td>
 
255
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.amount)]]</para>
 
256
                                </td>
 
257
                                <td>
 
258
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base+tax_line.amount)]]</para>
 
259
                                </td>
 
260
                                <td>
 
261
                                    <para/>
 
262
                                </td>
 
263
                            </tr>
 
264
                        </blockTable>
 
265
                    </section>
 
266
                </section>
 
267
                <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3">
 
268
                    <tr>
 
269
                        <td>
 
270
                            <para/>
 
271
                        </td>
 
272
                        <td>
 
273
                            <para alignment="RIGHT" style="Standard">Total</para>
 
274
                        </td>
 
275
                        <td>
 
276
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[2])]]</para>
 
277
                        </td>
 
278
                        <td>
 
279
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[3])]]</para>
 
280
                        </td>
 
281
                        <td>
 
282
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[4])]]</para>
 
283
                        </td>
 
284
                        <td>
 
285
                            <para/>
 
286
                        </td>
 
287
                    </tr>
 
288
                </blockTable>
 
289
                <para style="Standard">
 
290
                    <font color="white"> </font>
 
291
                </para>
 
292
            </section>
 
293
        </section>
 
294
 
 
295
 
 
296
 
 
297
        <para style="Header">Customer Refund Invoices [[ (out_refunds or removeParentNode('para')) and '' ]]</para>
 
298
        <section>
 
299
            <section> [[ repeatIn(out_refunds, 'obj') ]] <para style="Standard"> Currency : [[ obj[0] ]] </para>
 
300
                <!--<blockTable colWidths="1.8cm,1.4cm,1.4cm,1.8cm,1.8cm,2cm,3.5cm,2cm,4cm,1.2cm,1.8cm,1.4cm,1.8cm,1.6cm" repeatRows="1" style="Table3">-->
 
301
                <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" repeatRows="1" style="Table3a">
 
302
                    <tr>
 
303
                        <td>
 
304
                            <para style="Standard" size="5">Number</para>
 
305
                        </td>
 
306
                        <td>
 
307
                            <para style="Standard" size="5">External ref.</para>
 
308
                        </td>
 
309
                        <td>
 
310
                            <para style="Standard" size="5">Entry num.</para>
 
311
                        </td>
 
312
                        <td>
 
313
                            <para style="Standard" size="5">Invoice date</para>
 
314
                        </td>
 
315
                        <td>
 
316
                            <para style="Standard" size="5">Due date</para>
 
317
                        </td>
 
318
                        <td>
 
319
                            <para style="Standard" size="5">Partner code</para>
 
320
                        </td>
 
321
                        <td>
 
322
                            <para style="Standard" size="5">Partner</para>
 
323
                        </td>
 
324
                        <td>
 
325
                            <para style="Standard" size="5">Vat</para>
 
326
                        </td>
 
327
                        <!--<td>
 
328
                            <para style="Standard" size="5">Invoice description</para>
 
329
                        </td>-->
 
330
                        <td>
 
331
                            <para style="Standard" size="5">State</para>
 
332
                        </td>
 
333
                        <td>
 
334
                            <para alignment="RIGHT" style="Standard" size="5">Untaxed</para>
 
335
                        </td>
 
336
                        <td>
 
337
                            <para alignment="RIGHT" style="Standard" size="5">Taxes</para>
 
338
                        </td>
 
339
                        <td>
 
340
                            <para alignment="RIGHT" style="Standard" size="5">Total</para>
 
341
                        </td>
 
342
                        <td>
 
343
                            <para style="Standard" size="5">Fiscal position</para>
 
344
                        </td>
 
345
                    </tr>
 
346
                </blockTable>
 
347
                <section>[[ repeatIn(obj[1], 'inv') ]]
 
348
                <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3">
 
349
                    <tr>
 
350
                        <td>
 
351
                            <para style="Text body">[[inv.number]]</para>
 
352
                        </td>
 
353
                        <td>
 
354
                            <para style="Text body">[[inv.reference]]</para>
 
355
                        </td>
 
356
                        <td>
 
357
                            <para style="Text body">[[inv.move_id.name]]</para>
 
358
                        </td>
 
359
                        <td>
 
360
                            <para style="Text body">[[inv.date_invoice and formatLang(inv.date_invoice, date=True)]]</para>
 
361
                        </td>
 
362
                        <td>
 
363
                            <para style="Text body">[[inv.date_due and formatLang(inv.date_due, date=True)]]</para>
 
364
                        </td>
 
365
                        <td>
 
366
                            <para style="Text body">[[inv.partner_id.ref]]</para>
 
367
                        </td>
 
368
                        <td>
 
369
                            <para style="Text body">[[inv.partner_id.name]]</para>
 
370
                        </td>
 
371
                        <td>
 
372
                            <para style="Text body">[[inv.partner_id.vat]]</para>
 
373
                        </td>
 
374
                        <!--<td>
 
375
                            <para style="Text body">[[inv.name]]</para>
 
376
                        </td>-->
 
377
                        <td>
 
378
                            <para style="Text body">Draft [[ (inv.state=='draft' or removeParentNode('para')) and '']]</para>
 
379
                            <para style="Text body">Pro-forma [[ (inv.state in ['proforma','proforma2'] or removeParentNode('para')) and '']]</para>
 
380
                            <para style="Text body">Open [[ (inv.state=='open' or removeParentNode('para')) and '']]</para>
 
381
                            <para style="Text body">Paid [[ (inv.state=='paid' or removeParentNode('para')) and '']]</para>
 
382
                            <para style="Text body">Cancelled [[ (inv.state=='cancel' or removeParentNode('para')) and '']]</para> 
 
383
                        </td>
 
384
                        <td>
 
385
                            <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_untaxed)]]</para>
 
386
                        </td>
 
387
                        <td>
 
388
                            <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_tax)]]</para>
 
389
                        </td>
 
390
                        <td>
 
391
                            <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_total)]]</para>
 
392
                        </td>
 
393
                        <td>
 
394
                            <para style="Text body">[[inv.fiscal_position.name]]</para>
 
395
                        </td>
 
396
                    </tr>
 
397
                    </blockTable>
 
398
                    <section>[[ repeatIn(detailed_taxes and inv.tax_line or [], 'tax_line') ]]
 
399
                        <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3b">
 
400
                            [[ (tax_line.tax_code_id and tax_line.tax_code_id.notprintable and removeParentNode('blockTable')) or '']]
 
401
                            <tr>
 
402
                                <td>
 
403
                                    <para/>
 
404
                                </td>
 
405
                                <td>
 
406
                                    <para style="Text body" alignment="RIGHT">[[tax_line.name or '']]</para>
 
407
                                </td>
 
408
                                <td>
 
409
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base)]]</para>
 
410
                                </td>
 
411
                                <td>
 
412
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.amount)]]</para>
 
413
                                </td>
 
414
                                <td>
 
415
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base+tax_line.amount)]]</para>
 
416
                                </td>
 
417
                                <td>
 
418
                                    <para/>
 
419
                                </td>
 
420
                            </tr>
 
421
                        </blockTable>
 
422
                    </section>
 
423
                </section>
 
424
                <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3">
 
425
                    <tr>
 
426
                        <td>
 
427
                            <para/>
 
428
                        </td>
 
429
                        <td>
 
430
                            <para alignment="RIGHT" style="Standard">Total</para>
 
431
                        </td>
 
432
                        <td>
 
433
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[2])]]</para>
 
434
                        </td>
 
435
                        <td>
 
436
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[3])]]</para>
 
437
                        </td>
 
438
                        <td>
 
439
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[4])]]</para>
 
440
                        </td>
 
441
                        <td>
 
442
                            <para/>
 
443
                        </td>
 
444
                    </tr>
 
445
                </blockTable>
 
446
                <para style="Standard">
 
447
                    <font color="white"> </font>
 
448
                </para>
 
449
            </section>
 
450
        </section>
 
451
 
 
452
 
 
453
 
 
454
        <para style="Header">Supplier Invoices [[ (in_invoices or removeParentNode('para')) and '' ]]</para>
 
455
        <section>
 
456
            <section> [[ repeatIn(in_invoices, 'obj') ]] <para style="Standard"> Currency : [[ obj[0] ]] </para>
 
457
                <!--<blockTable colWidths="1.8cm,1.4cm,1.4cm,1.8cm,1.8cm,2cm,3.5cm,2cm,4cm,1.2cm,1.8cm,1.4cm,1.8cm,1.6cm" repeatRows="1" style="Table3">-->
 
458
                <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" repeatRows="1" style="Table3a">
 
459
                    <tr>
 
460
                        <td>
 
461
                            <para style="Standard" size="5">Number</para>
 
462
                        </td>
 
463
                        <td>
 
464
                            <para style="Standard" size="5">External ref.</para>
 
465
                        </td>
 
466
                        <td>
 
467
                            <para style="Standard" size="5">Entry num.</para>
 
468
                        </td>
 
469
                        <td>
 
470
                            <para style="Standard" size="5">Invoice date</para>
 
471
                        </td>
 
472
                        <td>
 
473
                            <para style="Standard" size="5">Due date</para>
 
474
                        </td>
 
475
                        <td>
 
476
                            <para style="Standard" size="5">Partner code</para>
 
477
                        </td>
 
478
                        <td>
 
479
                            <para style="Standard" size="5">Partner</para>
 
480
                        </td>
 
481
                        <td>
 
482
                            <para style="Standard" size="5">Vat</para>
 
483
                        </td>
 
484
                        <!--<td>
 
485
                            <para style="Standard" size="5">Invoice description</para>
 
486
                        </td>-->
 
487
                        <td>
 
488
                            <para style="Standard" size="5">State</para>
 
489
                        </td>
 
490
                        <td>
 
491
                            <para alignment="RIGHT" style="Standard" size="5">Untaxed</para>
 
492
                        </td>
 
493
                        <td>
 
494
                            <para alignment="RIGHT" style="Standard" size="5">Taxes</para>
 
495
                        </td>
 
496
                        <td>
 
497
                            <para alignment="RIGHT" style="Standard" size="5">Total</para>
 
498
                        </td>
 
499
                        <td>
 
500
                            <para style="Standard" size="5">Fiscal position</para>
 
501
                        </td>
 
502
                    </tr>
 
503
                </blockTable>
 
504
                <section>[[ repeatIn(obj[1], 'inv') ]]
 
505
                    <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3">
 
506
                        <tr>
 
507
                            <td>
 
508
                                <para style="Text body">[[inv.number]]</para>
 
509
                            </td>
 
510
                            <td>
 
511
                                <para style="Text body">[[inv.reference]]</para>
 
512
                            </td>
 
513
                            <td>
 
514
                                <para style="Text body">[[inv.move_id.name]]</para>
 
515
                            </td>
 
516
                            <td>
 
517
                                <para style="Text body">[[inv.date_invoice and formatLang(inv.date_invoice, date=True)]]</para>
 
518
                            </td>
 
519
                            <td>
 
520
                                <para style="Text body">[[inv.date_due and formatLang(inv.date_due, date=True)]]</para>
 
521
                            </td>
 
522
                            <td>
 
523
                                <para style="Text body">[[inv.partner_id.ref]]</para>
 
524
                            </td>
 
525
                            <td>
 
526
                                <para style="Text body">[[inv.partner_id.name]]</para>
 
527
                            </td>
 
528
                            <td>
 
529
                                <para style="Text body">[[inv.partner_id.vat]]</para>
 
530
                            </td>
 
531
                            <!--<td>
 
532
                                <para style="Text body">[[inv.name]]</para>
 
533
                            </td>-->
 
534
                            <td>
 
535
                                <para style="Text body">Draft [[ (inv.state=='draft' or removeParentNode('para')) and '']]</para>
 
536
                                <para style="Text body">Pro-forma [[ (inv.state in ['proforma','proforma2'] or removeParentNode('para')) and '']]</para>
 
537
                                <para style="Text body">Open [[ (inv.state=='open' or removeParentNode('para')) and '']]</para>
 
538
                                <para style="Text body">Paid [[ (inv.state=='paid' or removeParentNode('para')) and '']]</para>
 
539
                                <para style="Text body">Cancelled [[ (inv.state=='cancel' or removeParentNode('para')) and '']]</para>
 
540
                            </td>
 
541
                            <td>
 
542
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_untaxed)]]</para>
 
543
                            </td>
 
544
                            <td>
 
545
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_tax)]]</para>
 
546
                            </td>
 
547
                            <td>
 
548
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_total)]]</para>
 
549
                            </td>
 
550
                            <td>
 
551
                                <para style="Text body">[[inv.fiscal_position.name]]</para>
 
552
                            </td>
 
553
                        </tr>
 
554
                    </blockTable>
 
555
                    <section>[[ repeatIn(detailed_taxes and inv.tax_line or [], 'tax_line') ]]
 
556
                        <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3b">
 
557
                            [[ (tax_line.tax_code_id and tax_line.tax_code_id.notprintable and removeParentNode('blockTable')) or '']]
 
558
                            <tr>
 
559
                                <td>
 
560
                                    <para/>
 
561
                                </td>
 
562
                                <td>
 
563
                                    <para style="Text body" alignment="RIGHT">[[tax_line.name or '']]</para>
 
564
                                </td>
 
565
                                <td>
 
566
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base)]]</para>
 
567
                                </td>
 
568
                                <td>
 
569
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.amount)]]</para>
 
570
                                </td>
 
571
                                <td>
 
572
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base+tax_line.amount)]]</para>
 
573
                                </td>
 
574
                                <td>
 
575
                                    <para/>
 
576
                                </td>
 
577
                            </tr>
 
578
                        </blockTable>
 
579
                    </section>
 
580
                </section>
 
581
                <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" style="Table3">
 
582
                    <tr>
 
583
                        <td>
 
584
                            <para/>
 
585
                        </td>
 
586
                        <td>
 
587
                            <para alignment="RIGHT" style="Standard">Total</para>
 
588
                        </td>
 
589
                        <td>
 
590
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[2])]]</para>
 
591
                        </td>
 
592
                        <td>
 
593
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[3])]]</para>
 
594
                        </td>
 
595
                        <td>
 
596
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[4])]]</para>
 
597
                        </td>
 
598
                        <td>
 
599
                            <para/>
 
600
                        </td>
 
601
                    </tr>
 
602
                </blockTable>
 
603
                <para style="Standard">
 
604
                    <font color="white"> </font>
 
605
                </para>
 
606
            </section>
 
607
        </section>
 
608
 
 
609
 
 
610
 
 
611
        <para style="Header">Supplier Refund Invoices [[ (in_refunds or removeParentNode('para')) and '' ]]</para>
 
612
        <section>
 
613
            <section> [[ repeatIn(in_refunds, 'obj') ]] <para style="Standard"> Currency : [[ obj[0] ]] </para>
 
614
                <!--<blockTable colWidths="1.8cm,1.4cm,1.4cm,1.8cm,1.8cm,2cm,3.5cm,2cm,4cm,1.2cm,1.8cm,1.4cm,1.8cm,1.6cm" repeatRows="1" style="Table3">-->
 
615
                <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" repeatRows="1" style="Table3a">
 
616
                    <tr>
 
617
                        <td>
 
618
                            <para style="Standard" size="5">Number</para>
 
619
                        </td>
 
620
                        <td>
 
621
                            <para style="Standard" size="5">External ref.</para>
 
622
                        </td>
 
623
                        <td>
 
624
                            <para style="Standard" size="5">Entry num.</para>
 
625
                        </td>
 
626
                        <td>
 
627
                            <para style="Standard" size="5">Invoice date</para>
 
628
                        </td>
 
629
                        <td>
 
630
                            <para style="Standard" size="5">Due date</para>
 
631
                        </td>
 
632
                        <td>
 
633
                            <para style="Standard" size="5">Partner code</para>
 
634
                        </td>
 
635
                        <td>
 
636
                            <para style="Standard" size="5">Partner</para>
 
637
                        </td>
 
638
                        <td>
 
639
                            <para style="Standard" size="5">Vat</para>
 
640
                        </td>
 
641
                        <!--<td>
 
642
                            <para style="Standard" size="5">Invoice description</para>
 
643
                        </td>-->
 
644
                        <td>
 
645
                            <para style="Standard" size="5">State</para>
 
646
                        </td>
 
647
                        <td>
 
648
                            <para alignment="RIGHT" style="Standard" size="5">Untaxed</para>
 
649
                        </td>
 
650
                        <td>
 
651
                            <para alignment="RIGHT" style="Standard" size="5">Taxes</para>
 
652
                        </td>
 
653
                        <td>
 
654
                            <para alignment="RIGHT" style="Standard" size="5">Total</para>
 
655
                        </td>
 
656
                        <td>
 
657
                            <para style="Standard" size="5">Fiscal position</para>
 
658
                        </td>
 
659
                    </tr>
 
660
                </blockTable>
 
661
                <section>[[ repeatIn(obj[1], 'inv') ]]
 
662
                    <blockTable colWidths="2.0cm,2.3cm,1.4cm,1.8cm,1.8cm,2cm,5.2cm,2cm,1.2cm,1.8cm,1.4cm,1.6cm,2.6cm" repeatRows="1" style="Table3">
 
663
                        <tr>
 
664
                            <td>
 
665
                                <para style="Text body">[[inv.number]]</para>
 
666
                            </td>
 
667
                            <td>
 
668
                                <para style="Text body">[[inv.reference]]</para>
 
669
                            </td>
 
670
                            <td>
 
671
                                <para style="Text body">[[inv.move_id.name]]</para>
 
672
                            </td>
 
673
                            <td>
 
674
                                <para style="Text body">[[inv.date_invoice and formatLang(inv.date_invoice, date=True)]]</para>
 
675
                            </td>
 
676
                            <td>
 
677
                                <para style="Text body">[[inv.date_due and formatLang(inv.date_due, date=True)]]</para>
 
678
                            </td>
 
679
                            <td>
 
680
                                <para style="Text body">[[inv.partner_id.ref]]</para>
 
681
                            </td>
 
682
                            <td>
 
683
                                <para style="Text body">[[inv.partner_id.name]]</para>
 
684
                            </td>
 
685
                            <td>
 
686
                                <para style="Text body">[[inv.partner_id.vat]]</para>
 
687
                            </td>
 
688
                            <!--<td>
 
689
                                <para style="Text body">[[inv.name]]</para>
 
690
                            </td>-->
 
691
                            <td>
 
692
                                <para style="Text body">Draft [[ (inv.state=='draft' or removeParentNode('para')) and '']]</para>
 
693
                                <para style="Text body">Pro-forma [[ (inv.state in ['proforma','proforma2'] or removeParentNode('para')) and '']]</para>
 
694
                                <para style="Text body">Open [[ (inv.state=='open' or removeParentNode('para')) and '']]</para>
 
695
                                <para style="Text body">Paid [[ (inv.state=='paid' or removeParentNode('para')) and '']]</para>
 
696
                                <para style="Text body">Cancelled [[ (inv.state=='cancel' or removeParentNode('para')) and '']]</para>
 
697
                            </td>
 
698
                            <td>
 
699
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_untaxed)]]</para>
 
700
                            </td>
 
701
                            <td>
 
702
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_tax)]]</para>
 
703
                            </td>
 
704
                            <td>
 
705
                                <para style="Text body" alignment="RIGHT">[[formatLang(inv.amount_total)]]</para>
 
706
                            </td>
 
707
                            <td>
 
708
                                <para style="Text body">[[inv.fiscal_position.name]]</para>
 
709
                            </td>
 
710
                        </tr>
 
711
                    </blockTable>
 
712
                    <section>[[ repeatIn(detailed_taxes and inv.tax_line or [], 'tax_line') ]]
 
713
                        <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" repeatRows="1" style="Table3b">
 
714
                            [[ (tax_line.tax_code_id and tax_line.tax_code_id.notprintable and removeParentNode('blockTable')) or '']]
 
715
                            <tr>
 
716
                                <td>
 
717
                                    <para/>
 
718
                                </td>
 
719
                                <td>
 
720
                                    <para style="Text body" alignment="RIGHT">[[tax_line.name or '']]</para>
 
721
                                </td>
 
722
                                <td>
 
723
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base)]]</para>
 
724
                                </td>
 
725
                                <td>
 
726
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.amount)]]</para>
 
727
                                </td>
 
728
                                <td>
 
729
                                    <para style="Text body" alignment="RIGHT">[[formatLang(tax_line.base+tax_line.amount)]]</para>
 
730
                                </td>
 
731
                                <td>
 
732
                                    <para/>
 
733
                                </td>
 
734
                            </tr>
 
735
                        </blockTable>
 
736
                    </section>
 
737
                </section>
 
738
                <blockTable colWidths="10.0cm,9.7cm,1.8cm,1.4cm,1.6cm,2.6cm" repeatRows="1" style="Table3">
 
739
                    <tr>
 
740
                        <td>
 
741
                            <para/>
 
742
                        </td>
 
743
                        <td>
 
744
                            <para alignment="RIGHT" style="Standard">Total</para>
 
745
                        </td>
 
746
                        <td>
 
747
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[2])]]</para>
 
748
                        </td>
 
749
                        <td>
 
750
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[3])]]</para>
 
751
                        </td>
 
752
                        <td>
 
753
                            <para alignment="RIGHT" style="Standard">[[formatLang(obj[4])]]</para>
 
754
                        </td>
 
755
                        <td>
 
756
                            <para/>
 
757
                        </td>
 
758
                    </tr>
 
759
                </blockTable>
 
760
                <para style="Standard">
 
761
                    <font color="white"> </font>
 
762
                </para>
 
763
            </section>
 
764
        </section>
 
765
 
 
766
    </story>
 
767
</document>