← Back to branch summary

~vauxoo/addons-vauxoo/gbw

« back to all changes in this revision

Viewing changes to account/report/account_balance_sheet.rml

  • Committer: Isaac Lopez
  • Date: 2012-05-08 22:46:41 UTC
  • Revision ID: isaac@vauxoo.com-20120508224641-ge7uo6srn4ift4mq
[ADD][account] account with patch requiered by facturae and digits_compute added on quantity field
[ADD][l10n_mx_invoice_discount] discount module customized GBW

Show diffs side-by-side

added added

removed removed

Lines of Context:
account/report/account_balance_sheet.rml
 
1
<?xml version="1.0"?>
 
2
<document filename="Balance Sheet.pdf">
 
3
  <template pageSize="(595.0,842.0)" title="Balance Sheet" author="OpenERP S.A.(sales@openerp.com)" allowSplitting="20">
 
4
    <pageTemplate id="first">
 
5
      <frame id="first" x1="28.0" y1="28.0" width="539" height="786"/>
 
6
    </pageTemplate>
 
7
  </template>
 
8
  <stylesheet>
 
9
    <blockTableStyle id="Standard_Outline">
 
10
      <blockAlignment value="LEFT"/>
 
11
      <blockValign value="TOP"/>
 
12
    </blockTableStyle>
 
13
    <blockTableStyle id="Table_Heading">
 
14
      <blockAlignment value="LEFT"/>
 
15
      <blockValign value="TOP"/>
 
16
    </blockTableStyle>
 
17
    <blockTableStyle id="Table_Company_Name">
 
18
      <blockAlignment value="LEFT"/>
 
19
      <blockValign value="TOP"/>
 
20
    </blockTableStyle>
 
21
    <blockTableStyle id="Table_Date_from_To">
 
22
      <blockAlignment value="LEFT"/>
 
23
      <blockValign value="TOP"/>
 
24
    </blockTableStyle>
 
25
    <blockTableStyle id="Table_Account_Line_Title">
 
26
      <blockAlignment value="LEFT"/>
 
27
      <blockValign value="TOP"/>
 
28
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 
29
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,1" stop="-1,-1"/>
 
30
    </blockTableStyle>
 
31
    <blockTableStyle id="Table5">
 
32
      <blockAlignment value="LEFT"/>
 
33
      <blockValign value="TOP"/>
 
34
    </blockTableStyle>
 
35
    <blockTableStyle id="Table_Net_Profit_Loss">
 
36
      <blockAlignment value="LEFT"/>
 
37
      <blockValign value="TOP"/>
 
38
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 
39
    </blockTableStyle>
 
40
    <blockTableStyle id="Table1">
 
41
      <blockAlignment value="LEFT"/>
 
42
      <blockValign value="TOP"/>
 
43
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 
44
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,1" stop="-1,-1"/>
 
45
    </blockTableStyle>
 
46
   <blockTableStyle id="Table2_header">
 
47
      <blockAlignment value="LEFT"/>
 
48
      <blockValign value="TOP"/>
 
49
    <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
 
50
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
 
51
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
 
52
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
 
53
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
 
54
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
 
55
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
 
56
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
 
57
      <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
 
58
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
 
59
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
 
60
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
 
61
      <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
 
62
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
 
63
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
 
64
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
 
65
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
 
66
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
 
67
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
 
68
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
 
69
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
 
70
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
 
71
      <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
 
72
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
 
73
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
 
74
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
 
75
      <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
 
76
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
 
77
    </blockTableStyle>
 
78
 
 
79
    <blockTableStyle id="Table2">
 
80
      <blockAlignment value="LEFT"/>
 
81
      <blockValign value="TOP"/>
 
82
    </blockTableStyle>
 
83
    <blockTableStyle id="Table3">
 
84
      <blockAlignment value="LEFT"/>
 
85
      <blockValign value="TOP"/>
 
86
      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 
87
      <lineStyle kind="LINEAFTER" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 
88
      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 
89
      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 
90
    </blockTableStyle>
 
91
    <initialize>
 
92
      <paraStyle name="all" alignment="justify"/>
 
93
    </initialize>
 
94
    <paraStyle name="P1" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
95
    <paraStyle name="P2" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
96
    <paraStyle name="Standard" fontName="Times-Roman"/>
 
97
    <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
 
98
    <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 
99
    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
100
    <paraStyle name="Caption" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" spaceBefore="6.0" spaceAfter="6.0"/>
 
101
    <paraStyle name="Index" fontName="Helvetica" fontSize="9.0" leading="11"/>
 
102
    <paraStyle name="Footer" fontName="Times-Roman"/>
 
103
    <paraStyle name="Table Contents" fontName="Times-Roman"/>
 
104
    <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
 
105
    <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
 
106
    <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 
107
    <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
 
108
    <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 
109
    <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 
110
    <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
111
    <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
112
    <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
113
    <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 
114
    <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
115
    <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 
116
    <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
117
    <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
118
    <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 
119
    <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 
120
    <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
121
    <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
122
    <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
123
    <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
124
    <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
125
    <paraStyle name="terp_default_Right_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
126
    <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
127
  </stylesheet>
 
128
  <images/>
 
129
  <story>
 
130
    <para style="Standard">
 
131
      <font color="white"> </font>
 
132
    </para>
 
133
    <para style="terp_default_8">[[ setLang(data['lang']) ]]</para>
 
134
    <blockTable colWidths="539.0" style="Table_Company_Name">
 
135
      <tr>
 
136
        <td>
 
137
          <para style="terp_header_Centre">Balance Sheet</para>
 
138
        </td>
 
139
      </tr>
 
140
    </blockTable>
 
141
        <para style="terp_default_8">[[ get_data(data) or removeParentNode('para') ]]</para>
 
142
        <para style="terp_default_9">
 
143
      <font color="white"> </font>
 
144
    </para>
 
145
      <blockTable colWidths="120.0,100.0,140.0,90.0,90.0" style="Table2_header" >
 
146
      <tr>
 
147
        <td><para style="terp_tblheader_General_Centre">Chart of Account </para></td>
 
148
        <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
 
149
        <td><para style="terp_tblheader_General_Centre">Filter By <font>[[ get_filter(data)!='No Filter' and '' or removeParentNode('font') ]]</font></para></td>
 
150
    <td><para style="terp_tblheader_General_Centre">Display Account</para></td>
 
151
        <td><para style="terp_tblheader_General_Centre">Target Moves</para></td>
 
152
      </tr>
 
153
  <tr>
 
154
     <td><para style="terp_default_Centre_8">[[ get_account(data) or removeParentNode('para') ]]</para></td>
 
155
       <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data)  or '' ]]</para></td>
 
156
        <td><para style="terp_default_Centre_8">[[ get_filter(data)=='No Filter' and get_filter(data) or removeParentNode('para') ]] </para>
 
157
          <blockTable colWidths="60.0,60.0" style="Table3">[[ get_filter(data)=='Date' or removeParentNode('blockTable') ]]
 
158
        <tr>
 
159
                 <td><para style="terp_tblheader_Details_Centre">Start Date</para></td>
 
160
              <td><para style="terp_tblheader_Details_Centre">End Date</para></td>
 
161
            </tr>
 
162
            <tr>
 
163
              <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
 
164
              <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
 
165
            </tr>
 
166
          </blockTable>
 
167
          <blockTable colWidths="65.0,60.0" style="Table3">[[ get_filter(data)=='Periods' or removeParentNode('blockTable') ]]
 
168
        <tr>
 
169
              <td><para style="terp_tblheader_Details_Centre">Start Period</para></td>
 
170
              <td><para style="terp_tblheader_Details_Centre">End Period</para></td>
 
171
            </tr>
 
172
            <tr>
 
173
              <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
 
174
              <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
 
175
            </tr>
 
176
           </blockTable>
 
177
          </td>
 
178
    <td><para style="terp_default_Centre_8">[[ (data['form']['display_account']=='bal_all' and 'All') or  (data['form']['display_account']=='bal_movement' and 'With movements') or 'With balance is not equal to 0']]</para></td>
 
179
    <td><para style="terp_default_Centre_8">[[ get_target_move(data) ]] </para></td>
 
180
  </tr>
 
181
  </blockTable>
 
182
      <para style="Standard">
 
183
      <font color="white"> </font>
 
184
    </para>
 
185
    <para style="Standard">
 
186
      <font color="white"> </font>
 
187
    </para>
 
188
    <blockTable colWidths="539.0" style="Table_Company_Name">
 
189
      <tr>
 
190
        <td>
 
191
          <para style="terp_header_Centre">Assets</para>
 
192
        </td>
 
193
      </tr>
 
194
    </blockTable>
 
195
    <para style="terp_default_9">
 
196
      <font color="white"> </font>
 
197
    </para>
 
198
    <blockTable colWidths="100.0,326.0,113.0" style="Table1" repeatRows="1">
 
199
      <tr>
 
200
        <td>
 
201
          <para style="terp_default_Bold_9">Code</para>
 
202
        </td>
 
203
        <td>
 
204
          <para style="terp_default_Bold_9">Assets</para>
 
205
        </td>
 
206
        <td>
 
207
          <para style="terp_tblheader_Details_Right">Balance</para>
 
208
        </td>
 
209
      </tr>
 
210
      <tr>
 
211
        <td>
 
212
          <para style="terp_default_9"><font face="Times-Roman">[[ repeatIn(get_lines_another('asset'), 'a') ]]</font>[[ a['code'] ]]<font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font')  ]]</font></para>
 
213
        </td>
 
214
        <td>
 
215
          <para style="terp_default_9"><font color="white">[[  '. '*(a['level']-1) ]]</font><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font')  ]][[ a['name'] ]]</font></para>
 
216
        </td>
 
217
        <td>
 
218
          <para style="terp_default_Right_9"><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Right_9_Bold'})) or removeParentNode('font')  ]]</font><font>[[ formatLang(abs(a['balance'])) ]] [[ company.currency_id.symbol ]]</font></para>
 
219
        </td>
 
220
      </tr>
 
221
    </blockTable>
 
222
    <blockTable colWidths="426.0,113.0" style="Table_Net_Profit_Loss">
 
223
      <tr>
 
224
        <td>
 
225
          <para style="terp_default_Bold_9">Balance:</para>
 
226
        </td>
 
227
        <td>
 
228
          <para style="terp_default_Right_9_Bold"><u>[[ formatLang(abs(sum_cr())) ]] [[ company.currency_id.symbol ]]</u></para>
 
229
        </td>
 
230
      </tr>
 
231
    </blockTable>
 
232
    <condPageBreak height="20cm"/>
 
233
    <para style="terp_default_9">
 
234
      <font color="white"> </font>
 
235
    </para>
 
236
    <blockTable colWidths="539.0" style="Table_Company_Name">
 
237
      <tr>
 
238
        <td>
 
239
          <para style="terp_header_Centre">Liabilities</para>
 
240
        </td>
 
241
      </tr>
 
242
    </blockTable>
 
243
    <blockTable colWidths="100.0,326.0,113.0" style="Table_Account_Line_Title" repeatRows="1">
 
244
      <tr>
 
245
        <td>
 
246
          <para style="terp_default_Bold_9">Code</para>
 
247
        </td>
 
248
        <td>
 
249
          <para style="terp_default_Bold_9">Liabilities</para>
 
250
        </td>
 
251
        <td>
 
252
          <para style="terp_tblheader_Details_Right">Balance</para>
 
253
        </td>
 
254
      </tr>
 
255
      <tr>
 
256
        <td>
 
257
          <para style="terp_default_9"><font face="Times-Roman">[[ repeatIn(get_lines_another('liability'), 'a') ]]</font>[[ a['code'] ]]<font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font') ]] </font><font>[[ a['name']=='Net Profit' and setTag('para','para',{'style':'terp_default_Bold_9'}) or removeParentNode('font') ]]</font></para>
 
258
        </td>
 
259
        <td>
 
260
          <para style="terp_default_9"><font color="white">[[  '. '*(a['level']-1) ]]</font><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font')  ]][[ a['name'] ]]</font><font>[[ a['name']=='Net Profit' and setTag('para','para',{'style':'terp_default_Bold_9'}) or removeParentNode('font') ]]</font></para>
 
261
        </td>
 
262
        <td>
 
263
          <para style="terp_default_Right_9"><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Right_9_Bold'})) or removeParentNode('font')  ]]</font><font>[[ formatLang(abs(a['balance'])) ]] [[ company.currency_id.symbol ]]</font><font>[[ a['name']=='Net Profit' and setTag('para','para',{'style':'terp_default_Right_9_Bold'}) or removeParentNode('font') ]]</font></para>
 
264
        </td>
 
265
      </tr>
 
266
    </blockTable>
 
267
    <blockTable colWidths="426.0,113.0" style="Table_Net_Profit_Loss">
 
268
      <tr>
 
269
        <td>
 
270
          <para style="terp_default_Bold_9">Balance:</para>
 
271
        </td>
 
272
        <td>
 
273
          <para style="terp_default_Right_9_Bold"><u>[[ formatLang(abs(sum_dr())) ]] [[ company.currency_id.symbol ]]</u></para>
 
274
        </td>
 
275
      </tr>
 
276
    </blockTable>
 
277
    <para style="Standard">
 
278
      <font color="white"> </font>
 
279
    </para>
 
280
  </story>
 
281
</document>