← Back to branch summary

~therp-nl/therp-addons/7.0_lp1219418

« back to all changes in this revision

Viewing changes to account_report_alt/report/account_balance_sheet.rml

  • Committer: Ronald Portier
  • Date: 2014-03-28 13:12:43 UTC
  • mfrom: (81.5.17 therp-addons-7.0)
  • Revision ID: ronald@therp.nl-20140328131243-d06yj7u2o9fhshrw
[MERGE] Merge upstream changes
    - resolve text conflict in fetchmail_invoice.

Show diffs side-by-side

added added

removed removed

Lines of Context:
account_report_alt/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(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(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(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(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>