addons/account/report/account_financial_report.rml

   1 <?xml version="1.0"?>
   2 <document filename="Financial Report.pdf">
   3   <template title="Financial Report" 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="MIDDLE"/>
  28       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  29     </blockTableStyle>
  30      <blockTableStyle id="Table3">
  31       <blockAlignment value="LEFT"/>
  32       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  33     </blockTableStyle>
  34     <blockTableStyle id="Table6">
  35       <blockAlignment value="LEFT"/>
  36       <blockValign value="TOP"/>
  37     </blockTableStyle>
  38     <blockTableStyle id="Table_Net_Profit_Loss">
  39       <blockAlignment value="LEFT"/>
  40       <blockValign value="TOP"/>
  41       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
  42     </blockTableStyle>
  43     <blockTableStyle id="Table4">
  44       <blockAlignment value="LEFT"/>
  45       <blockValign value="TOP"/>
  46       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
  47     </blockTableStyle>
  48     <blockTableStyle id="Table_Final_Result">
  49       <blockAlignment value="LEFT"/>
  50       <blockValign value="TOP"/>
  51       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  52       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  53       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  54       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  55       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="1,0" stop="1,-1"/>
  56       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  57       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  58     </blockTableStyle>
  59    <blockTableStyle id="Table2_header">
  60       <blockAlignment value="LEFT"/>
  61       <blockValign value="TOP"/>
  62     <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
  63       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  64       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  65       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  66       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  67       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  68       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  69       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  70       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  71       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  72       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  73       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  74       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  75       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  76       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  77       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
  78       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
  79       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  80       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
  81       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
  82       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  83       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
  84       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
  85       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
  86       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
  87       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
  88       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
  89       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
  90     </blockTableStyle>
  91     <initialize>
  92       <paraStyle name="all" alignment="justify"/>
  93     </initialize>
  94     <paraStyle name="P1" rightIndent="2.0" leftIndent="0.0" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.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
 128     <paraStyle name="terp_level_0_name" fontName="Helvetica-Bold" fontSize="9.0" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 129     <paraStyle name="terp_level_0_balance" fontName="Helvetica-Bold" fontSize="9.0" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 130     <paraStyle name="terp_level_1_name" fontName="Helvetica-Bold" fontSize="10.0" alignment="LEFT" leading="20" spaceBefore="0.0" spaceAfter="0.0"/>
 131     <paraStyle name="terp_level_1_balance" fontName="Helvetica-Bold" fontSize="10.0" alignment="RIGHT" leading="20" spaceBefore="0.0" spaceAfter="0.0"/>
 132     <paraStyle name="terp_level_2_name" fontName="Helvetica-Bold" fontSize="9.0" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 133     <paraStyle name="terp_level_2_balance" fontName="Helvetica-Bold" fontSize="9.0" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 134     <paraStyle name="terp_level_3_name" fontName="Helvetica-Bold" fontSize="8.0" leftIndent="10.0" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 135     <paraStyle name="terp_level_3_balance" fontName="Helvetica-Bold" fontSize="8.0" leftIndent="10.0" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 136     <paraStyle name="terp_level_4_name" fontName="Helvetica" fontSize="8.0" leftIndent="20.0" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 137     <paraStyle name="terp_level_4_balance" fontName="Helvetica" fontSize="8.0" leftIndent="0.0" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 138     <paraStyle name="terp_level_5_name" fontName="Helvetica-Oblique" fontSize="7.5" leftIndent="30.0" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 139     <paraStyle name="terp_level_5_balance" fontName="Helvetica-Oblique" fontSize="7.5" leftIndent="0.0" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 140     <paraStyle name="terp_level_6_name" fontName="Helvetica" fontSize="6.5" leftIndent="40.0" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 141     <paraStyle name="terp_level_6_balance" fontName="Helvetica" fontSize="6.5" leftIndent="0.0" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 142
 143     <blockTableStyle id="Table1">
 144       <blockTopPadding start="0,0" stop="-1,0" length="10"/>
 145       <blockAlignment value="LEFT"/>
 146       <lineStyle kind="LINEBELOW" colorName="#666666" start="1,1" stop="-1,1"/>
 147     </blockTableStyle>
 148     <blockTableStyle id="Table2">
 149       <blockValign value="TOP"/>
 150     </blockTableStyle>
 151     <blockTableStyle id="Table3">
 152       <blockValign value="TOP"/>
 153     </blockTableStyle>
 154
 155 </stylesheet>
 156   <images/>
 157   <story>
 158     <blockTable colWidths="539.0" style="Table_Company_Name">
 159       <tr>
 160         <td>
 161           <para style="terp_header_Centre">[[ data['form']['account_report_id'][1] ]]</para>
 162         </td>
 163       </tr>
 164     </blockTable>
 165
 166     <para style="Standard">
 167       <font color="white"> </font>
 168     </para>
 169       <blockTable colWidths="122.0,122.0,122.0,122.0" style="Table2_header">
 170       <tr>
 171         <td><para style="terp_tblheader_General_Centre">Chart of Accounts</para></td>
 172         <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
 173         <td><para style="terp_tblheader_General_Centre">Filter By [[ get_filter(data)!='No Filters' and get_filter(data) ]]</para></td>
 174         <td><para style="terp_tblheader_General_Centre">Target Moves</para></td>
 175       </tr>
 176     <tr>
 177        <td><para style="terp_default_Centre_8">[[ get_account(data) or removeParentNode('para') ]]</para></td>
 178        <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data)  or '' ]]</para></td>
 179         <td><para style="terp_default_Centre_8">[[ get_filter(data)=='No Filters' and get_filter(data) or removeParentNode('para') ]] </para>
 180             <blockTable colWidths="60.0,60.0" style="Table3">[[ get_filter(data)=='Date' or removeParentNode('blockTable') ]]
 181                 <tr>
 182                    <td><para style="terp_tblheader_General_Centre">Start Date</para></td>
 183                     <td><para style="terp_tblheader_General_Centre">End Date</para></td>
 184                 </tr>
 185                 <tr>
 186                     <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
 187                     <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
 188                 </tr>
 189             </blockTable>
 190             <blockTable colWidths="65.0,60.0" style="Table3">[[ get_filter(data)=='Periods' or removeParentNode('blockTable') ]]
 191                 <tr>
 192                     <td><para style="terp_tblheader_General_Centre">Start Period</para></td>
 193                     <td><para style="terp_tblheader_General_Centre">End Period</para></td>
 194                 </tr>
 195                 <tr>
 196                     <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
 197                     <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
 198                 </tr>
 199              </blockTable>
 200             </td>
 201         <td>
 202           <para style="terp_default_Centre_8">[[ get_target_move(data) ]]</para>
 203         </td>
 204
 205     </tr>
 206     </blockTable>
 207     <para style="Standard">
 208       <font color="white"> </font>
 209     </para>
 210     <para style="Standard">
 211         <font color="white"> </font>
 212     </para>
 213     <!-- table with debit/credit displayed -->
 214     <blockTable colWidths="210.0,90.0,90.0,100.0" style="Table_Account_Line_Title">
 215       [[ data['form']['debit_credit'] == 1 or removeParentNode('blockTable') ]]
 216       <tr>
 217         <td>
 218           <para style="terp_default_Bold_9">Name</para>
 219         </td>
 220          <td>
 221           <para style="terp_tblheader_Details_Right">Debit</para>
 222         </td>
 223           <td>
 224           <para style="terp_tblheader_Details_Right">Credit</para>
 225         </td>
 226         <td>
 227           <para style="terp_tblheader_Details_Right">Balance</para>
 228         </td>
 229       </tr>
 230       <tr style="Table3">
 231           [[ repeatIn(get_lines(data), 'a') ]]
 232           [[ (a.get('level') &lt;&gt; 0) or removeParentNode('tr') ]]
 233           [[ setTag('tr','tr',{'style': 'Table'+str(min(3,'level' in a and a.get('level') or 1))}) ]]
 234           <td><para style="terp_level_3_name">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_name'}) ]][[ a.get('name') ]]</para></td>
 235           <td><para style="terp_level_3_balance">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('debit',0.0), currency_obj = company.currency_id) ]]</para></td>
 236           <td><para style="terp_level_3_balance">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('credit',0.0), currency_obj = company.currency_id) ]]</para></td>
 237           <td>[[ (a.get('account_type') =='view' and a.get('level') &lt;&gt; 1) or removeParentNode('td') ]]
 238               <para style="terp_level_3_balance"><u>[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance'), currency_obj = company.currency_id) ]]</u></para></td>
 239           <td>[[ (a.get('account_type') &lt;&gt;'view' or a.get('level') == 1) or removeParentNode('td') ]]
 240               <para style="terp_level_3_balance">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance'), currency_obj = company.currency_id) ]]</para></td>
 241       </tr>
 242     </blockTable>
 243
 244     <!-- table with no comparison, no debit/credit displayed -->
 245     <blockTable colWidths="390.0,100.0" style="Table_Account_Line_Title">
 246       [[ (not data['form']['enable_filter'] and not data['form']['debit_credit']) or removeParentNode('blockTable') ]]
 247       <tr>
 248         <td>
 249           <para style="terp_default_Bold_9">Name</para>
 250         </td>
 251         <td>
 252           <para style="terp_tblheader_Details_Right">Balance</para>
 253         </td>
 254       </tr>
 255       <tr style="Table3">
 256           [[ repeatIn(get_lines(data), 'a') ]]
 257           [[ (a.get('level') &lt;&gt; 0) or removeParentNode('tr') ]]
 258           [[ setTag('tr','tr',{'style': 'Table'+str(min(3,'level' in a and a.get('level') or 1))}) ]]
 259           <td><para style="terp_level_3_name">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_name'}) ]][[ a.get('name') ]]</para></td>
 260           <td>[[ (a.get('account_type') =='view' and a.get('level') &lt;&gt; 1) or removeParentNode('td') ]]
 261               <para style="terp_level_3_balance"><u>[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance'), currency_obj = company.currency_id) ]]</u></para></td>
 262           <td>[[ (a.get('account_type') &lt;&gt;'view' or a.get('level') == 1) or removeParentNode('td') ]]
 263               <para style="terp_level_3_balance">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance'), currency_obj = company.currency_id) ]]</para></td>
 264       </tr>
 265     </blockTable>
 266     <para style="Standard">
 267       <font color="white"> </font>
 268     </para>
 269
 270     <!-- table with comparison -->
 271     <blockTable colWidths="263.0,100.0,100" style="Table_Account_Line_Title">
 272       [[ (data['form']['enable_filter'] == 1 and not data['form']['debit_credit']) or removeParentNode('blockTable') ]]
 273       <tr>
 274         <td>
 275           <para style="terp_default_Bold_9">Name</para>
 276         </td>
 277         <td>
 278           <para style="terp_tblheader_Details_Right">Balance</para>
 279         </td>
 280         <td>
 281           <para style="terp_tblheader_Details_Right">[[ data['form']['label_filter'] ]]</para>
 282         </td>
 283       </tr>
 284       <tr style="Table3">
 285           [[ repeatIn(get_lines(data), 'a') ]]
 286           [[ (a.get('level') &lt;&gt; 0) or removeParentNode('tr') ]]
 287           [[ setTag('tr','tr',{'style': 'Table'+str(min(3,'level' in a and a.get('level') or 1))}) ]]
 288           <td><para style="terp_level_3_name">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_name'}) ]][[ a.get('name') ]]</para></td>
 289           <td>[[ (a.get('account_type') =='view' and a.get('level') &lt;&gt; 1) or removeParentNode('td') ]]
 290               <para style="terp_level_3_balance"><u>[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance'), currency_obj = company.currency_id) ]]</u></para></td>
 291           <td>[[ (a.get('account_type') &lt;&gt;'view' or a.get('level') == 1) or removeParentNode('td') ]]
 292               <para style="terp_level_3_balance">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance'), currency_obj = company.currency_id) ]]</para></td>
 293           <td>[[ (a.get('account_type') =='view' and a.get('level') &lt;&gt; 1) or removeParentNode('td') ]]
 294               <para style="terp_level_3_balance"><u>[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance_cmp'), currency_obj = company.currency_id) ]]</u></para></td>
 295           <td>[[ (a.get('account_type') &lt;&gt;'view' or a.get('level') == 1) or removeParentNode('td') ]]
 296               <para style="terp_level_3_balance">[[ setTag('para','para',{'style': 'terp_level_'+str(min(6,a.get('level')))+'_balance'}) ]][[ formatLang(a.get('balance_cmp'), currency_obj = company.currency_id) ]]</para></td>
 297       </tr>
 298     </blockTable>
 299     <para style="Standard">
 300       <font color="white"> </font>
 301     </para>
 302   </story>
 303 </document>