addons/account/report/account_general_ledger.rml

   1 <?xml version="1.0"?>
   2 <document filename="General Ledger.pdf">
   3   <template pageSize="(595.0,842.0)" title="General Ledger" author="OpenERP S.A.(sales@openerp.com)" allowSplitting="20">
   4     <pageTemplate id="first">
   5       <frame id="first" x1="57.0" y1="57.0" width="481" height="728"/>
   6       <pageGraphics>
   7
   8       </pageGraphics>
   9     </pageTemplate>
  10   </template>
  11    <stylesheet>
  12     <blockTableStyle id="tbl_header">
  13       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  14       <blockValign value="TOP"/>
  15     </blockTableStyle>
  16     <blockTableStyle id="Table_Company_Name">
  17       <blockAlignment value="LEFT"/>
  18       <blockValign value="TOP"/>
  19     </blockTableStyle>
  20     <blockTableStyle id="tbl_content">
  21       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,1" stop="-1,-1"/>
  22       <blockValign value="TOP"/>
  23     </blockTableStyle>
  24     <blockTableStyle id="Table_Subheader_Content_detail">
  25       <blockAlignment value="LEFT"/>
  26       <blockValign value="TOP"/>
  27       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  28       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  29       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  30       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  31       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  32       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  33       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  34       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  35       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  36       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  37       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  38       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  39       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  40       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  41       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
  42       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
  43       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  44       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
  45       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
  46       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  47       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
  48       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
  49       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
  50       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
  51       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
  52       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
  53       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
  54       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="7,-1" stop="7,-1"/>
  55       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="8,0" stop="8,-1"/>
  56       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="8,0" stop="8,-1"/>
  57       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="8,0" stop="8,0"/>
  58       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="8,-1" stop="8,-1"/>
  59     </blockTableStyle>
  60     <blockTableStyle id="Table_Sub_Header_Content">
  61       <blockAlignment value="LEFT"/>
  62       <blockValign value="TOP"/>
  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       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="7,-1" stop="7,-1"/>
  91       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="8,0" stop="8,-1"/>
  92       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="8,0" stop="8,-1"/>
  93       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="8,0" stop="8,0"/>
  94       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="8,-1" stop="8,-1"/>
  95     </blockTableStyle>
  96
  97     <blockTableStyle id="Table5">
  98       <blockAlignment value="LEFT"/>
  99       <lineStyle kind="LINEBELOW" colorName="#777777" start="0,0" stop="0,0"/>
 100       <blockValign value="TOP"/>
 101     </blockTableStyle>
 102     <blockTableStyle id="Table2">
 103       <blockAlignment value="LEFT"/>
 104       <blockValign value="TOP"/>
 105     <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
 106       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
 107       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
 108       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
 109       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
 110       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
 111       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
 112       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
 113       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
 114       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
 115       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
 116       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
 117       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
 118       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
 119       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
 120       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
 121       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
 122       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
 123       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
 124       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
 125       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
 126       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
 127       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
 128       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
 129       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
 130       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
 131       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
 132       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
 133     </blockTableStyle>
 134      <blockTableStyle id="Table3">
 135       <blockAlignment value="LEFT"/>
 136       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
 137     </blockTableStyle>
 138
 139     <initialize>
 140       <paraStyle name="all" alignment="justify"/>
 141     </initialize>
 142     <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 143     <paraStyle name="P2" fontName="Helvetica" fontSize="8.3" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 144     <paraStyle name="date" fontName="Helvetica-Bold" fontSize="8.3" leading="10" spaceBefore="0.0" spaceAfter="6.0" alignment="LEFT"/>
 145     <paraStyle name="P2_content" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 146     <paraStyle name="P3" fontName="Helvetica" fontSize="8.3" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 147     <paraStyle name="P3b" fontName="Helvetica-Bold" fontSize="8.3" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 148     <paraStyle name="P3_centre" fontName="Helvetica" fontSize="8.3" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 149     <paraStyle name="P3_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 150     <paraStyle name="P4" fontName="Helvetica" fontSize="8.3" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 151     <paraStyle name="P4_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 152     <paraStyle name="P5" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 153     <paraStyle name="P6" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 154     <paraStyle name="P7" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 155     <paraStyle name="P8" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 156     <paraStyle name="P9" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 157     <paraStyle name="P9b" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 158     <paraStyle name="P10" fontName="Helvetica" alignment="CENTER"/>
 159     <paraStyle name="P11" fontName="Helvetica" fontSize="11.0" leading="14"/>
 160     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 161     <paraStyle name="P12" fontName="Helvetica" fontSize="14.0" leading="17"/>
 162     <paraStyle name="P13" fontName="Helvetica-Bold" fontSize="10.0" leading="8" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 163     <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 164     <paraStyle name="P15" fontName="Helvetica-Bold" spaceBefore="0.0" spaceAfter="6.0"/>
 165     <paraStyle name="P16" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Roman" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 166     <paraStyle name="P17" fontName="Helvetica" alignment="LEFT" fontSize="12.0"  spaceAfter="0.0"/>
 167     <paraStyle name="Standard" fontName="Helvetica-Bold" fontSize="8.5"/>
 168     <paraStyle name="Account" fontName="Helvetica"/>
 169     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 170     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 171     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 172     <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 173     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 174     <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 175     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 176     <paraStyle name="Index" fontName="Helvetica"/>
 177   <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 178   </stylesheet>
 179   <story>
 180   <pto>
 181   <pto_header>
 182   <blockTable colWidths="66.0,44.0,80.0,60.0,92.5,66.5,64.5,71.5" style="tbl_header">[[data['form']['amount_currency'] == False or removeParentNode('blockTable')]]
 183         <tr>
 184           <td><para style="date">Date</para></td>
 185           <td><para style="P3b">Partner</para></td>
 186           <td><para style="P3b">Ref</para></td>
 187           <td><para style="P3b">Move</para></td>
 188           <td><para style="P3b">Entry Label</para></td>
 189           <td><para style="P9b">Debit</para></td>
 190           <td><para style="P9b">Credit</para></td>
 191           <td><para style="P9b">Balance</para></td>
 192         </tr>
 193      </blockTable>
 194      <blockTable colWidths="70.0,40.0,60.0,55.0,89.0,58.0,58.0,58.0,58.0" style="tbl_header">[[ data['form']['amount_currency'] == True or removeParentNode('blockTable') ]]
 195         <tr>
 196           <td><para style="date">Date</para></td>
 197           <td><para style="P3b">Partner</para></td>
 198           <td><para style="P3b">Ref</para></td>
 199           <td><para style="P3b">Move</para></td>
 200           <td><para style="P3b">Entry Label</para></td>
 201           <td><para style="P9b">Debit</para></td>
 202           <td><para style="P9b">Credit</para></td>
 203           <td><para style="P9b">Balance</para></td>
 204           <td><para style="P9b">Currency</para></td>
 205         </tr>
 206      </blockTable>
 207   </pto_header>
 208     <blockTable colWidths="539.0" style="Table_Company_Name">
 209       <tr>
 210         <td>
 211           <para style="terp_header_Centre">General Ledger</para>
 212         </td>
 213       </tr>
 214     </blockTable>
 215     <para>
 216       <font color="white"> </font>
 217     </para>
 218    <para>[[ repeatIn(objects, 'a') ]]</para>
 219     <blockTable colWidths="80.0,70.0,70.0,80.0,100.0,70.0,80.0" style="Table2">
 220       <tr>
 221         <td><para style="terp_tblheader_General_Centre">Chart of Account</para></td>
 222         <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
 223     <td><para style="terp_tblheader_General_Centre">Journals</para></td>
 224     <td><para style="terp_tblheader_General_Centre">Display Account </para></td>
 225         <td><para style="terp_tblheader_General_Centre">Filter By  [[ get_filter(data)!='No Filter' and get_filter(data) ]]</para></td>
 226          <td><para style="terp_tblheader_General_Centre">Entries Sorted By</para></td>
 227         <td><para style="terp_tblheader_General_Centre">Target Moves</para></td>
 228       </tr>
 229   <tr>
 230      <td><para style="terp_default_Centre_8">[[ get_account(data) or removeParentNode('para') ]]</para></td>
 231        <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data)  or '' ]]</para></td>
 232     <td> <para style="terp_default_Centre_8">[[', '.join([ lt or '' for lt in get_journal(data) ]) ]] </para></td>
 233     <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>
 234         <td><para style="terp_default_Centre_8">[[ get_filter(data)=='No Filter' and get_filter(data) or removeParentNode('para') ]] </para>
 235           <blockTable colWidths="50.0,50.0" style="Table3">[[ get_filter(data)=='Date' or removeParentNode('blockTable') ]]
 236         <tr>
 237                  <td><para style="terp_tblheader_Details_Centre">Start Date</para></td>
 238               <td><para style="terp_tblheader_Details_Centre">End Date</para></td>
 239             </tr>
 240             <tr>
 241              <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
 242               <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
 243             </tr>
 244           </blockTable>
 245           <blockTable colWidths="50.0,50.0" style="Table3">[[ get_filter(data)=='Periods' or removeParentNode('blockTable') ]]
 246         <tr>
 247               <td><para style="terp_tblheader_Details_Centre">Start Period</para></td>
 248               <td><para style="terp_tblheader_Details_Centre">End Period</para></td>
 249             </tr>
 250             <tr>
 251               <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
 252               <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
 253             </tr>
 254            </blockTable>
 255           </td>
 256         <td><para style="terp_default_Centre_8">[[ get_sortby(data) ]]</para></td>
 257   <td><para style="terp_default_Centre_8">[[ get_target_move(data) ]] </para></td>
 258   </tr>
 259   </blockTable>
 260
 261     <para>
 262       <font color="white"> </font>
 263     </para>
 264     <para>
 265       <font color="white"> </font>
 266     </para>
 267
 268    <blockTable colWidths="66.0,44.0,80.0,60.0,92.5,66.5,64.5,71.5" style="tbl_header" repeatRows="1">[[data['form']['amount_currency'] == False or removeParentNode('blockTable')]]
 269         <tr>
 270           <td><para style="date">Date</para></td>
 271           <td><para style="P3b">Partner</para></td>
 272           <td><para style="P3b">Ref</para></td>
 273           <td><para style="P3b">Move</para></td>
 274           <td><para style="P3b">Entry Label</para></td>
 275           <td><para style="P9b">Debit</para></td>
 276           <td><para style="P9b">Credit</para></td>
 277           <td><para style="P9b">Balance</para></td>
 278         </tr>
 279      </blockTable>
 280       <section>
 281      <para>[[ repeatIn(get_children_accounts(a), 'o') ]]</para>
 282      <blockTable colWidths="66.0,44.0,80.0,60.0,92.5,66.5,64.5,71.5" style="tbl_content">[[ data['form']['amount_currency'] == False or removeParentNode('blockTable') ]]
 283         <tr>
 284           <td>
 285           <blockTable colWidths="245.0,92.5,65.5,67.5,68.5" style="Table5">
 286       <tr>
 287         <td><para style="Standard"><font color="white">[[ '..'*(o.level-1) ]]</font>[[ o.code or '']] [[ o.name or '']]</para></td>
 288         <td><para style="Standard"></para></td>
 289         <td alignment="right"><para style="P9b"><u>[[formatLang(sum_debit_account(o)) ]]</u></para></td>
 290         <td alignment="right"><para style="P9b"><u>[[formatLang(sum_credit_account(o)) ]] </u></para></td>
 291         <td><para style="P9b"><u>[[ formatLang(sum_balance_account(o)) ]] [[ company.currency_id.symbol ]]</u></para></td>
 292       </tr>
 293       </blockTable>
 294       </td>
 295       <td><para style="Standard"></para></td>
 296         <td><para style="Standard"></para></td>
 297         <td><para style="Standard"></para></td>
 298         <td><para style="Standard"></para></td>
 299         <td><para style="Standard"></para></td>
 300         <td><para style="Standard"></para></td>
 301         <td><para style="Standard"></para></td>
 302       </tr>
 303     <tr>
 304         <td><para style="P3">[[ repeatIn(lines(o), 'line') ]] <font>[[ formatLang(line['ldate'],date=True) ]]</font></para></td>
 305         <td><para style="P3">[[ line['partner'] or '']]</para></td>
 306         <td><para style="P3">[[ line['lref'] or '']]</para></td>
 307         <td><para style="P3">[[ line['move'] or '']]</para></td>
 308         <td><para style="P3">[[ line['lname'] or '' ]]</para></td>
 309         <td><para style="P4">[[ formatLang(line['debit']) ]]</para></td>
 310         <td><para style="P4">[[ formatLang(line['credit']) ]]</para></td>
 311         <td><para style="P4">[[ formatLang(line['progress']) ]] [[ company.currency_id.symbol ]]</para></td>
 312      </tr>
 313     </blockTable>
 314      </section>
 315
 316
 317
 318      <blockTable colWidths="70.0,40.0,60.0,55.0,89.0,58.0,58.0,58.0,58.0" style="tbl_header" repeatRows="1">[[ data['form']['amount_currency'] == True or removeParentNode('blockTable') ]]
 319         <tr>
 320           <td><para style="date">Date</para></td>
 321           <td><para style="P3b">Partner</para></td>
 322           <td><para style="P3b">Ref</para></td>
 323           <td><para style="P3b">Move</para></td>
 324           <td><para style="P3b">Entry Label</para></td>
 325           <td><para style="P9b">Debit</para></td>
 326           <td><para style="P9b">Credit</para></td>
 327           <td><para style="P9b">Balance</para></td>
 328           <td><para style="P9b">Currency</para></td>
 329         </tr>
 330      </blockTable>
 331      <section>
 332      <para>[[ repeatIn(get_children_accounts(a), 'o') ]]</para>
 333      <blockTable colWidths="70.0,40.0,60.0,55.0,89.0,58.0,58.0,58.0,58.0" style="tbl_content">[[ data['form']['amount_currency'] == True or removeParentNode('blockTable') ]]
 334        <tr>
 335           <td>
 336           <blockTable colWidths="230.00,80.0,56.5,57.5,57.5,65.5" style="Table5">
 337               <tr>
 338                 <td><para style="Standard"><font color="white">[[ '..'*(o.level-1) ]]</font>[[ o.code or '' ]] [[ o.name or '' ]]</para></td>
 339                 <td><para style="Standard"></para></td>
 340                 <td alignment="right"><para style="P9b"><u>[[formatLang(sum_debit_account(o)) ]]</u></para></td>
 341                 <td alignment="right"><para style="P9b"><u>[[formatLang(sum_credit_account(o)) ]]</u></para></td>
 342                 <td><para style="P9b"><u>[[formatLang(sum_balance_account(o)) ]] [[ company.currency_id.symbol ]]</u></para></td>
 343                <td><para style="P9b"><u>[[ o.currency_id and sum_currency_amount_account(o) +o.currency_id.symbol or '' ]]</u></para></td>
 344               </tr>
 345           </blockTable>
 346       </td>
 347       <td><para style="Standard"></para></td>
 348         <td><para style="Standard"></para></td>
 349         <td><para style="Standard"></para></td>
 350         <td><para style="Standard"></para></td>
 351         <td><para style="Standard"></para></td>
 352         <td><para style="Standard"></para></td>
 353         <td><para style="Standard"></para></td>
 354         <td><para style="Standard"></para></td>
 355       </tr>
 356     <tr>
 357        <td><para style="P3">[[ repeatIn(lines(o), 'line') ]] <font>[[ formatLang(line['ldate'],date=True) ]]</font></para></td>
 358        <td><para style="P3">[[ line['partner'] or '' ]]</para></td>
 359        <td><para style="P3">[[ line['lref'] or '']]</para></td>
 360        <td><para style="P3">[[ line['move'] or '' ]]</para></td>
 361        <td><para style="P3">[[ line['lname'] or '' ]]</para></td>
 362        <td><para style="P4">[[ formatLang(line['debit']) ]]</para></td>
 363        <td><para style="P4">[[ formatLang(line['credit']) ]]</para></td>
 364        <td><para style="P4">[[ formatLang(line['progress']) ]] [[ company.currency_id.symbol ]]</para></td>
 365            <td><para style="P4"><font>[[ (line.has_key('currency_id') and line['currency_id']==None or line['amount_currency']==None) and removeParentNode('font') ]] [[  formatLang(line['amount_currency'])]] [[  line['currency_code'] or '']]</font></para></td>
 366      </tr>
 367   </blockTable>
 368   </section>
 369   </pto>
 370   </story>
 371 </document>