[FIX] stock: use correct vals in grouped invoice (opw 606535)
[odoo/odoo.git] / addons / point_of_sale / report / account_statement.rml
1 <?xml version="1.0"?>
2 <document filename="test.pdf">
3   <template title="Statement" author="OpenERP S.A. (sales@openerp.com)" allowSplitting="20">
4     <pageTemplate id="first">
5       <frame id="first" x1="36.0" y1="57.0" width="520" height="728"/>
6     </pageTemplate>
7   </template>
8   <stylesheet>
9     <blockTableStyle id="Standard_Outline">
10       <blockAlignment value="LEFT"/>
11       <blockValign value="TOP"/>
12     </blockTableStyle>
13     <blockTableStyle id="Table1">
14       <blockAlignment value="LEFT"/>
15       <blockValign value="TOP"/>
16       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
17       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
18       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
19       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
20       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
21       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
22       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
23       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
24       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
25       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
26       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
27       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="3,0" stop="3,0"/>
28       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
29     </blockTableStyle>
30     <blockTableStyle id="Table2">
31       <blockAlignment value="LEFT"/>
32       <blockValign value="TOP"/>
33       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
34       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
35       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
36       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
37       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
38       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
39       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
40       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
41       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
42       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
43       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
44       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="3,0" stop="3,0"/>
45       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
46     </blockTableStyle>
47     <blockTableStyle id="Table3">
48       <blockAlignment value="LEFT"/>
49       <blockValign value="TOP"/>
50       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
51       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
52       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
53       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
54       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
55       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
56       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
57       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
58       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
59       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
60       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
61       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="3,0" stop="3,0"/>
62       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
63     </blockTableStyle>
64     <blockTableStyle id="Table4">
65       <blockAlignment value="LEFT"/>
66       <blockValign value="TOP"/>
67       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
68       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
69       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
70       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
71       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
72       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
73       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
74       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
75       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
76       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
77       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
78       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="3,0" stop="3,0"/>
79       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
80     </blockTableStyle>
81     <blockTableStyle id="Table9">
82       <blockAlignment value="LEFT"/>
83       <blockValign value="TOP"/>
84       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
85       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
86       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
87     </blockTableStyle>
88     <blockTableStyle id="Table5">
89       <blockAlignment value="LEFT"/>
90       <blockValign value="TOP"/>
91       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
92       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
93       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
94     </blockTableStyle>
95     <blockTableStyle id="Table7">
96       <blockAlignment value="LEFT"/>
97       <blockValign value="TOP"/>
98       <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
99       <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
100     </blockTableStyle>
101     <initialize>
102       <paraStyle name="all" alignment="justify"/>
103     </initialize>
104     <paraStyle name="Standard" fontName="Helvetica"/>
105     <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
106     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
107     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
108     <paraStyle name="Caption" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
109     <paraStyle name="Index" fontName="Helvetica"/>
110     <paraStyle name="Table Contents" fontName="Helvetica"/>
111     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER"/>
112     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
113     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
114     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
115     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
116     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
117     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
118     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
119     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
120     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
121     <paraStyle name="Footer" fontName="Helvetica"/>
122     <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
123     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
124     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
125     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
126     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
127     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
128     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
129     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
130     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
131     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
132     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
133     <paraStyle name="terp_default_1" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
134     <paraStyle name="terp_default_Right_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
135     <paraStyle name="terp_default_8_Italic" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
136     <images/>
137   </stylesheet>
138   <story>
139   <pto>
140   <pto_header>
141     <blockTable colWidths="131.0,292.0,97.0" style="Table9">
142       <tr>
143         <td>
144           <para style="terp_tblheader_Details">Name</para>
145         </td>
146         <td>
147           <para style="terp_tblheader_Details">Partner</para>
148         </td>
149         <td>
150           <para style="terp_tblheader_Details_Right">Amount </para>
151         </td>
152       </tr>
153     </blockTable>
154   </pto_header>
155     <para style="terp_default_8">[[ repeatIn(objects,'statement') ]]</para>
156     <para style="terp_header_Centre">Statement</para>
157     <blockTable colWidths="130.0,130.0,130.0,130.0" style="Table1">
158       <tr>
159         <td>
160           <para style="terp_tblheader_General_Centre">Statement Name</para>
161         </td>
162         <td>
163           <para style="terp_tblheader_General_Centre">Journal</para>
164         </td>
165         <td>
166           <para style="terp_tblheader_General_Centre">Company</para>
167         </td>
168         <td>
169           <para style="terp_tblheader_General_Centre">User</para>
170         </td>
171       </tr>
172     </blockTable>
173     <blockTable colWidths="130.0,130.0,130.0,130.0" style="Table2">
174       <tr>
175         <td>
176           <para style="terp_default_Centre_8">[[ statement.name ]]</para>
177         </td>
178         <td>
179           <para style="terp_default_Centre_8">[[ statement.journal_id.name ]]</para>
180         </td>
181         <td>
182           <para style="terp_default_Centre_8">[[ statement.company_id.name ]]</para>
183         </td>
184         <td>
185           <para style="terp_default_Centre_8">[[ statement.user_id.name ]]</para>
186         </td>
187       </tr>
188     </blockTable>
189     <para style="terp_default_8">
190       <font color="white"> </font>
191     </para>
192     <blockTable colWidths="130.0,130.0,130.0,130.0" style="Table3">
193       <tr>
194         <td>
195           <para style="terp_tblheader_General_Centre">Opening Date</para>
196         </td>
197         <td>
198           <para style="terp_tblheader_General_Centre">Closing Date</para>
199         </td>
200         <td>
201           <para style="terp_tblheader_General_Centre">Starting Balance</para>
202         </td>
203         <td>
204           <para style="terp_tblheader_General_Centre">Ending Balance</para>
205         </td>
206       </tr>
207     </blockTable>
208     <blockTable colWidths="130.0,130.0,130.0,130.0" style="Table4">
209       <tr>
210         <td>
211           <para style="terp_default_Centre_8">[[ formatLang(statement.date,date=True) ]]</para>
212         </td>
213         <td>
214           <para style="terp_default_Centre_8">[[ formatLang(statement.closing_date,date_time=True)]]</para>
215         </td>
216         <td>
217           <para style="terp_default_Centre_8">[[ formatLang(statement.balance_start, dp='Account', currency_obj = company.currency_id) ]]</para>
218         </td>
219         <td>
220           <para style="terp_default_Centre_8">[[ formatLang(statement.balance_end_real, dp='Account', currency_obj = company.currency_id) ]]</para>
221         </td>
222       </tr>
223     </blockTable>
224     <para style="terp_default_8">
225       <font color="white"> </font>
226     </para>
227     <blockTable colWidths="131.0,292.0,97.0" style="Table9">
228       <tr>
229         <td>
230           <para style="terp_tblheader_Details">Name</para>
231         </td>
232         <td>
233           <para style="terp_tblheader_Details">Partner</para>
234         </td>
235         <td>
236           <para style="terp_tblheader_Details_Right">Amount </para>
237         </td>
238       </tr>
239     </blockTable>
240     <section>
241       <para style="terp_default_1">[[ repeatIn(statement.line_ids,'line_ids') and ' ' or removeParentNode('blockTable') ]]</para>
242       <section>
243         <para style="terp_default_1">[[ repeatIn(get_data(statement), 'line_ids')]]</para>
244         <blockTable colWidths="131.0,292.0,97.0" style="Table5">
245           <tr>
246             <td>
247               <para style="terp_default_9">[[ line_ids.name ]]</para>
248             </td>
249             <td>
250               <para style="terp_default_9">[[ line_ids.partner_id.name ]]</para>
251             </td>
252             <td>
253               <para style="terp_default_Right_9">[[ formatLang(line_ids.amount, dp='Account', currency_obj=company.currency_id) ]]</para>
254             </td>
255           </tr>
256         </blockTable>
257       </section>
258     </section>
259     <blockTable colWidths="374.0,49.0,97.0" style="Table7">
260       <tr>
261         <td>
262           <para style="terp_default_8">
263             <font color="white"> </font>
264           </para>
265         </td>
266         <td>
267           <para style="terp_tblheader_Details">Total :</para>
268         </td>
269         <td>
270           <para style="terp_default_Right_9_Bold">[[ formatLang(get_total(statement.line_ids), dp='Account', currency_obj = company.currency_id) ]]</para>
271         </td>
272       </tr>
273     </blockTable>
274     <para style="terp_default_8">
275       <font color="white"> </font>
276     </para>
277     <para style="terp_default_8">
278       <font color="white"> </font>
279     </para>
280     <para style="terp_default_8">
281       <font color="white"> </font>
282     </para>
283   </pto>
284   </story>
285 </document>