addons/account/report/account_general_ledger_landscape.rml

   1 <?xml version="1.0"?>
   2 <document filename="General Ledger.pdf">
   3    <template pageSize="(1120.5,767.8)" title="General Ledger" author="OpenERP S.A.(sales@openerp.com)" allowSplitting="20" >
   4     <pageTemplate id="first">
   5       <frame id="first" x1="22.0" y1="31.0" width="1080" height="680"/>
   6     </pageTemplate>
   7   </template>
   8    <stylesheet>
   9     <blockTableStyle id="tbl_header">
  10       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  11       <blockValign value="TOP"/>
  12     </blockTableStyle>
  13     <blockTableStyle id="Table_Subheader_Content_detail">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  17       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  18       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  19       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  20       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  21       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  22       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  23       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  24       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  25       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  26       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  27       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  28       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  29       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  30       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
  31       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
  32       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  33       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
  34       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
  35       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  36       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
  37       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
  38       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
  39       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
  40       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
  41       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
  42       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
  43       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="7,-1" stop="7,-1"/>
  44       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="8,0" stop="8,-1"/>
  45       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="8,0" stop="8,-1"/>
  46       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="8,0" stop="8,0"/>
  47       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="8,-1" stop="8,-1"/>
  48     </blockTableStyle>
  49     <blockTableStyle id="Table_Company_Name">
  50       <blockAlignment value="LEFT"/>
  51       <blockValign value="TOP"/>
  52     </blockTableStyle>
  53     <blockTableStyle id="Table_Sub_Header_Content">
  54       <blockAlignment value="LEFT"/>
  55       <blockValign value="TOP"/>
  56       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  57       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  58       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  59       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  60       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  61       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  62       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  63       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  64       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  65       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  66       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  67       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  68       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  69       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  70       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
  71       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
  72       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  73       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
  74       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
  75       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  76       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
  77       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
  78       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
  79       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
  80       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
  81       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
  82       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
  83       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="7,-1" stop="7,-1"/>
  84       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="8,0" stop="8,-1"/>
  85       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="8,0" stop="8,-1"/>
  86       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="8,0" stop="8,0"/>
  87       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="8,-1" stop="8,-1"/>
  88     </blockTableStyle>
  89     <blockTableStyle id="tbl_content">
  90       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,1" stop="-1,-1"/>
  91       <blockValign value="TOP"/>
  92     </blockTableStyle>
  93     <blockTableStyle id="Table5">
  94       <blockAlignment value="LEFT"/>
  95       <lineStyle kind="LINEBELOW" colorName="#777777" start="0,0" stop="0,0"/>
  96       <blockValign value="TOP"/>
  97     </blockTableStyle>
  98     <blockTableStyle id="Table2">
  99       <blockAlignment value="LEFT"/>
 100       <blockValign value="TOP"/>
 101     <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
 102       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
 103       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
 104       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
 105       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
 106       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
 107       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
 108       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
 109       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
 110       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
 111       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
 112       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
 113       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
 114       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
 115       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
 116       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
 117       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
 118       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
 119       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
 120       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
 121       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
 122       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
 123       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
 124       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
 125       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
 126       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
 127       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
 128       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
 129     </blockTableStyle>
 130      <blockTableStyle id="Table3">
 131       <blockAlignment value="LEFT"/>
 132       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
 133     </blockTableStyle>
 134      <blockTableStyle id="Table_Company_Name">
 135       <blockAlignment value="LEFT"/>
 136       <blockValign value="TOP"/>
 137     </blockTableStyle>
 138     <initialize>
 139       <paraStyle name="all" alignment="justify"/>
 140     </initialize>
 141     <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 142     <paraStyle name="P2" fontName="Helvetica-Bold" fontSize="9.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 143     <paraStyle name="date" leftIndent="6.0" fontName="Helvetica-Bold" fontSize="9.0" leading="10" spaceBefore="6.0" spaceAfter="0.0" alignment="LEFT"/>
 144     <paraStyle name="P2_content" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 145     <paraStyle name="P3" fontName="Helvetica-Bold" fontSize="9.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 146     <paraStyle name="P3_center" fontName="Helvetica-Bold" fontSize="9.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 147     <paraStyle name="P3_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 148     <paraStyle name="P3_content_center" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 149     <paraStyle name="P4" fontName="Helvetica-Bold" fontSize="9.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 150     <paraStyle name="P4_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 151     <paraStyle name="P5" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 152     <paraStyle name="P6" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 153     <paraStyle name="P7" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 154     <paraStyle name="P8" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 155     <paraStyle name="P9" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 156     <paraStyle name="P9b" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 157     <paraStyle name="P10" fontName="Helvetica" alignment="CENTER"/>
 158     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 159     <paraStyle name="terp_default_Centre_8a" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 160     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 161     <paraStyle name="P11" fontName="Helvetica" fontSize="11.0" leading="14"/>
 162     <paraStyle name="P12" fontName="Helvetica-Bold" fontSize="9.0" leading="0"/>
 163     <paraStyle name="P13" fontName="Helvetica-Bold" fontSize="10.0" leading="8" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 164     <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 165     <paraStyle name="P15" fontName="Helvetica-Bold" spaceBefore="0.0" spaceAfter="6.0"/>
 166     <paraStyle name="P16" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Roman" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 167     <paraStyle name="P17" fontName="Helvetica" alignment="LEFT" fontSize="12.0"  spaceAfter="0.0"/>
 168     <paraStyle name="Standard" fontName="Helvetica-Bold" fontSize="8.5"/>
 169     <paraStyle name="Account" fontName="Helvetica"/>
 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_default_8" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="0.0"/>
 178   <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 179   </stylesheet>
 180   <story>
 181   <pto>
 182   <pto_header>
 183   <blockTable colWidths="45.0,56.0,120.0,90.0,60.0,200.0,124.0,90.0,90.0,90.0,90.00" style="tbl_header">[[data['form']['amount_currency'] == True or removeParentNode('blockTable')]]
 184        <tr>
 185           <td><para style="date">Date</para></td>
 186           <td><para style="P2">JNRL</para></td>
 187           <td><para style="P2">Partner</para></td>
 188           <td><para style="P2">Ref</para></td>
 189           <td><para style="P2">Move</para></td>
 190           <td><para style="P3">Entry Label</para></td>
 191           <td><para style="P3_center">Counterpart</para></td>
 192           <td><para style="P4">Debit</para></td>
 193           <td><para style="P4">Credit</para></td>
 194           <td><para style="P4">Balance</para></td>
 195           <td><para style="P4">Currency</para></td>
 196        </tr>
 197     </blockTable>
 198     <blockTable colWidths="45.0,56.0,166.0,90.0,60.0,230.0,133.0,90.0,90.0,90.0" style="tbl_header">[[ data['form']['amount_currency'] == False or removeParentNode('blockTable') ]]
 199        <tr>
 200           <td><para style="date">Date</para></td>
 201           <td><para style="P2">JNRL</para></td>
 202           <td><para style="P2">Partner</para></td>
 203           <td><para style="P2">Ref</para></td>
 204           <td><para style="P2">Move</para></td>
 205           <td><para style="P3">Entry Label</para></td>
 206           <td><para style="P3_center">Counterpart</para></td>
 207           <td><para style="P4">Debit</para></td>
 208           <td><para style="P4">Credit</para></td>
 209           <td><para style="P4">Balance</para></td>
 210        </tr>
 211         </blockTable>
 212   </pto_header>
 213     <blockTable colWidths="539.0" style="Table_Company_Name">
 214       <tr>
 215         <td>
 216           <para style="terp_header_Centre">General Ledger </para>
 217         </td>
 218       </tr>
 219     </blockTable>
 220    <para>[[ repeatIn(objects, 'a') ]]</para>
 221
 222     <para style="terp_default_8">
 223       <font color="white"> </font>
 224     </para>
 225       <blockTable colWidths="200.0,130.0,200.0,150.0,150.0,100.0,110.0" style="Table2">
 226       <tr>
 227       <td><para style="terp_tblheader_General_Centre">[[ data['model']=='account.account' and 'Company' or removeParentNode('para') ]]</para>
 228         <para style="terp_tblheader_General_Centre"> [[ data['model']=='ir.ui.menu' and 'Chart of Account' or removeParentNode('para') ]]</para></td>
 229         <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
 230          <td><para style="terp_tblheader_General_Centre">Journals</para></td>
 231     <td><para style="terp_tblheader_General_Centre">Display Account</para></td>
 232         <td><para style="terp_tblheader_General_Centre">Filter By  [[ get_filter(data)!='No Filter' and get_filter(data) ]]</para></td>
 233          <td><para style="terp_tblheader_General_Centre">Entries Sorted By</para></td>
 234         <td><para style="terp_tblheader_General_Centre">Target Moves</para></td>
 235       </tr>
 236   <tr>
 237      <td><para style="terp_default_Centre_8">[[ get_account(data) or removeParentNode('para') ]]</para></td>
 238        <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data)  or '' ]]</para></td>
 239        <td> <para style="terp_default_Centre_8">[[', '.join([ lt or '' for lt in get_journal(data) ]) ]] </para></td>
 240     <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>
 241
 242         <td><para style="terp_default_Centre_8">[[ get_filter(data)=='No Filter' and get_filter(data) or removeParentNode('para') ]] </para>
 243           <blockTable colWidths="60.0,60.0" style="Table3">[[ get_filter(data)=='Date' or removeParentNode('blockTable') ]]
 244         <tr>
 245                  <td><para style="terp_tblheader_General_Centre">Start Date</para></td>
 246               <td><para style="terp_tblheader_General_Centre">End Date</para></td>
 247             </tr>
 248             <tr>
 249               <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
 250               <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
 251             </tr>
 252           </blockTable>
 253           <blockTable colWidths="60.0,60.0" style="Table3">[[ get_filter(data)=='Periods' or removeParentNode('blockTable') ]]
 254         <tr>
 255               <td><para style="terp_tblheader_General_Centre">Start Period</para></td>
 256               <td><para style="terp_tblheader_General_Centre">End Period</para></td>
 257             </tr>
 258             <tr>
 259               <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
 260               <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
 261             </tr>
 262            </blockTable>
 263           </td>
 264         <td><para style="terp_default_Centre_8">[[ get_sortby(data) ]]</para></td>
 265   <td><para style="terp_default_Centre_8">[[ get_target_move(data) ]] </para></td>
 266   </tr>
 267   </blockTable>
 268     <para style="terp_default_8">
 269       <font color="white"> </font>
 270     </para>
 271     <para style="terp_default_8">
 272       <font color="white"> </font>
 273     </para>
 274
 275         <blockTable colWidths="45.0,56.0,120.0,90.0,60.0,200.0,124.0,90.0,90.0,90.0,90.00" style="tbl_header" repeatRows="1">[[data['form']['amount_currency'] == True or removeParentNode('blockTable')]]
 276        <tr>
 277           <td><para style="date">Date</para></td>
 278           <td><para style="P2">JNRL</para></td>
 279           <td><para style="P2">Partner</para></td>
 280           <td><para style="P2">Ref</para></td>
 281           <td><para style="P2">Move</para></td>
 282           <td><para style="P3">Entry Label</para></td>
 283           <td><para style="P3_center">Counterpart</para></td>
 284           <td><para style="P4">Debit</para></td>
 285           <td><para style="P4">Credit</para></td>
 286           <td><para style="P4">Balance</para></td>
 287           <td><para style="P4">Currency</para></td>
 288        </tr>
 289     </blockTable>
 290      <section>
 291
 292       <para>[[ repeatIn(get_children_accounts(a), 'o') ]]</para>
 293
 294       <blockTable colWidths="45.0,56.0,120.0,90.0,60.0,200.0,124.0,90.0,90.0,90.0,90.00" style="tbl_content">[[data['form']['amount_currency'] == True or removeParentNode('blockTable')]]
 295         <tr>
 296                 <td>
 297                         <blockTable colWidths="405.0,283.5,90.0,90.0,90.0,90.0" style="Table5">
 298                                 <tr>
 299                                         <td><para style="Standard"><font color="white">[[ '..'*(o.level-1) ]]</font>[[ o.code ]] [[ o.name ]]</para></td>
 300                                         <td><para style="Standard"></para></td>
 301                                                 <td alignment="right"><para style="P9b"><u>[[ formatLang(sum_debit_account(o), digits=get_digits(dp='Account')) ]]</u></para></td>
 302                                                 <td alignment="right"><para style="P9b"><u>[[ formatLang(sum_credit_account(o), digits=get_digits(dp='Account')) ]]</u></para></td>
 303                                                 <td><para style="P9b"><u>[[ formatLang(sum_balance_account(o), digits=get_digits(dp='Account')) ]] [[ company.currency_id.symbol ]]</u></para></td>
 304                                                 <td><para style="P9b"><u>[[ o.currency_id and formatLang(sum_currency_amount_account(o), digits=get_digits(dp='Account')) + o.currency_id.code or '' ]]</u></para></td>
 305                                         </tr>
 306                         </blockTable>
 307                 </td>
 308                 <td><para style="Standard"></para></td>
 309                 <td><para style="Standard"></para></td>
 310                 <td><para style="Standard"></para></td>
 311                 <td><para style="Standard"></para></td>
 312                 <td><para style="Standard"></para></td>
 313                 <td><para style="Standard"></para></td>
 314                 <td><para style="Standard"></para></td>
 315                 <td><para style="Standard"></para></td>
 316                 <td><para style="Standard"></para></td>
 317                 <td><para style="Standard"></para></td>
 318                 </tr>
 319                 <tr><para style="P2_content">[[ repeatIn(lines(o), 'line') ]]</para>
 320                         <td><para style="P2_content"> [[ formatLang(line['ldate'],date=True) ]]</para></td>
 321                         <td><para style="P2_content">[[ line['lcode'] ]]</para></td>
 322                         <td><para style="P2_content">[[ line['partner_name'] ]]</para></td>
 323                         <td><para style="P2_content">[[ line['lref'] ]]</para></td>
 324                         <td><para style="P2_content">[[ line['move'] ]]</para></td>
 325                         <td><para style="P3_content">[[ line['lname'] ]]</para></td>
 326                         <td><para style="P3_content_center">[[ strip_name(line['line_corresp'].replace(', ',','),40) ]]</para></td>
 327                         <td><para style="P4_content">[[ formatLang(line['debit'], digits=get_digits(dp='Account')) ]]</para></td>
 328                         <td><para style="P4_content">[[ formatLang(line['credit'], digits=get_digits(dp='Account')) ]]</para></td>
 329                         <td><para style="P4_content">[[ formatLang(line['progress'], digits=get_digits(dp='Account')) ]] [[ company.currency_id.symbol ]]</para></td>
 330                         <td><para style="P4_content"><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>
 331                 </tr>
 332           </blockTable>
 333
 334         </section>
 335
 336     <blockTable colWidths="45.0,56.0,166.0,90.0,60.0,230.0,133.0,90.0,90.0,90.0" style="tbl_header" repeatRows="1">[[ data['form']['amount_currency'] == False or removeParentNode('blockTable') ]]
 337        <tr>
 338           <td><para style="date">Date</para></td>
 339           <td><para style="P2">JNRL</para></td>
 340           <td><para style="P2">Partner</para></td>
 341           <td><para style="P2">Ref</para></td>
 342           <td><para style="P2">Move</para></td>
 343           <td><para style="P3">Entry Label</para></td>
 344           <td><para style="P3_center">Counterpart</para></td>
 345           <td><para style="P4">Debit</para></td>
 346           <td><para style="P4">Credit</para></td>
 347           <td><para style="P4">Balance</para></td>
 348        </tr>
 349         </blockTable>
 350
 351         <section>
 352
 353                 <para>[[ repeatIn(get_children_accounts(a), 'o') ]]</para>
 354
 355                 <blockTable colWidths="45.0,56.0,166.0,90.0,60.0,230.0,133.0,90.0,90.0,90.0" style="tbl_content">[[data['form']['amount_currency'] == False or removeParentNode('blockTable')]]
 356                 <tr>
 357                         <td>
 358                                 <blockTable colWidths="405.0,369.0,90.0,90.0,90.0" style="Table5">
 359                                                 <tr>
 360                                                         <td><para style="Standard"><font color="white">[[ '..'*(o.level-1) ]]</font>[[ o.code ]] [[ o.name ]]</para></td>
 361                                                         <td><para style="Standard"></para></td>
 362                                                         <td alignment="right"><para style="P9b"><u>[[ formatLang(sum_debit_account(o), digits=get_digits(dp='Account')) ]]</u></para></td>
 363                                                         <td alignment="right"><para style="P9b"><u>[[ formatLang(sum_credit_account(o), digits=get_digits(dp='Account')) ]]</u></para></td>
 364                                                         <td><para style="P9b"><u>[[ formatLang(sum_balance_account(o), digits=get_digits(dp='Account')) ]] [[ company.currency_id.symbol ]]</u></para></td>
 365                                                 </tr>
 366                                         </blockTable>
 367                                 </td>
 368                                 <td><para style="Standard"></para></td>
 369                         <td><para style="Standard"></para></td>
 370                         <td><para style="Standard"></para></td>
 371                         <td><para style="Standard"></para></td>
 372                         <td><para style="Standard"></para></td>
 373                         <td><para style="Standard"></para></td>
 374                         <td><para style="Standard"></para></td>
 375                         <td><para style="Standard"></para></td>
 376                         <td><para style="Standard"></para></td>
 377                         </tr>
 378                         <tr>
 379                                 <td><para style="P2_content">[[ repeatIn(lines(o), 'line') ]]<font>[[ line['ldate'] and formatLang(line['ldate'],date=True) or removeParentNode('tr') ]]</font></para></td>
 380                                 <para>[[ line or removeParentNode('tr')</para>
 381                                 <td><para style="P2_content">[[ line['lcode'] ]]</para></td>
 382                                 <td><para style="P2_content">[[ line['partner'] ]]</para></td>
 383                                 <td><para style="P2_content">[[ line['lref'] ]]</para></td>
 384                                 <td><para style="P2_content">[[ line['move'] ]]</para></td>
 385                                 <td><para style="P3_content">[[ line['lname'] ]]</para></td>
 386                                 <td><para style="P3_content_center">[[ strip_name(line['line_corresp'],15) ]]</para></td>
 387                                 <td><para style="P4_content">[[ formatLang(line['debit'], digits=get_digits(dp='Account')) ]] </para></td>
 388                                 <td><para style="P4_content">[[ formatLang(line['credit'], digits=get_digits(dp='Account')) ]]</para></td>
 389                                 <td><para style="P4_content">[[ formatLang(line['progress'], digits=get_digits(dp='Account')) ]] [[ company.currency_id.symbol ]]</para></td>
 390                         </tr>
 391                 </blockTable>
 392
 393         </section>
 394         <para style="terp_default_8">
 395       <font color="white"> </font>
 396     </para>
 397     </pto>
 398  </story>
 399 </document>