addons/account/report/account_partner_ledger.rml

   1 <?xml version="1.0"?>
   2 <document filename="test.pdf">
   3   <template pageSize="(595.0,842.0)" title="Partner Ledger" 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_header">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16     </blockTableStyle>
  17     <blockTableStyle id="Table_header_1">
  18       <blockAlignment value="LEFT"/>
  19       <blockValign value="TOP"/>
  20       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  21       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  22       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  23       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  24       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  25       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
  26       <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
  27       <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
  28     </blockTableStyle>
  29     <blockTableStyle id="Table1">
  30       <blockAlignment value="LEFT"/>
  31       <blockValign value="TOP"/>
  32       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  33       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  34       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  35       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  36     </blockTableStyle>
  37     <blockTableStyle id="Table2">
  38       <blockAlignment value="LEFT"/>
  39       <blockValign value="TOP"/>
  40       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="0,-1"/>
  41     </blockTableStyle>
  42     <blockTableStyle id="Table2_header">
  43       <blockAlignment value="LEFT"/>
  44       <blockValign value="TOP"/>
  45     <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
  46       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  47       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  48       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  49       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  50       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  51       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  52       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  53       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  54       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  55       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  56       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  57       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  58       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  59       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  60       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
  61       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
  62       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  63       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
  64       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
  65       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  66       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
  67       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
  68       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
  69       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
  70       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
  71       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
  72       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
  73       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="8,0" stop="8,-1"/>
  74       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="8,0" stop="8,-1"/>
  75       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="8,0" stop="8,0"/>
  76     </blockTableStyle>
  77     <blockTableStyle id="Table3">
  78       <blockAlignment value="LEFT"/>
  79       <blockValign value="TOP"/>
  80       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  81       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  82       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  83       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  84       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  85       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  86       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
  87       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="7,-1" stop="7,-1"/>
  88     </blockTableStyle>
  89         <blockTableStyle id="Table3_header">
  90       <blockAlignment value="LEFT"/>
  91         <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  92     </blockTableStyle>
  93      <blockTableStyle id="Table4">
  94       <blockAlignment value="LEFT"/>
  95       <blockValign value="TOP"/>
  96       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  97       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  98       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  99       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
 100       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
 101       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
 102       <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
 103       <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
 104       <lineStyle kind="LINEBELOW" colorName="#000000" start="8,-1" stop="8,-1"/>
 105     </blockTableStyle>
 106     <blockTableStyle id="Table6">
 107       <blockAlignment value="LEFT"/>
 108       <blockValign value="TOP"/>
 109
 110       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="0,-1"/>
 111     </blockTableStyle>
 112     <blockTableStyle id="Table5">
 113       <blockAlignment value="LEFT"/>
 114       <blockValign value="TOP"/>
 115       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
 116       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
 117       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
 118       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
 119       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
 120     </blockTableStyle>
 121     <blockTableStyle id="Table7">
 122       <blockAlignment value="LEFT"/>
 123       <blockValign value="TOP"/>
 124       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
 125       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
 126       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
 127       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
 128       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
 129       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
 130       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
 131       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="7,-1" stop="7,-1"/>
 132       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="8,-1" stop="8,-1"/>
 133     </blockTableStyle>
 134     <initialize>
 135       <paraStyle name="all" alignment="justify"/>
 136     </initialize>
 137     <paraStyle name="P1" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0" textColor="#000000"/>
 138     <paraStyle name="P2" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0" textColor="#000000"/>
 139     <paraStyle name="P3" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0" textColor="#000000"/>
 140     <paraStyle name="P4" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0" textColor="#000000"/>
 141     <paraStyle name="P5" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0" textColor="#000000"/>
 142     <paraStyle name="Standard" fontName="Times-Roman"/>
 143     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 144     <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 145     <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 146     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 147     <paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 148     <paraStyle name="Index" fontName="Times-Roman"/>
 149     <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
 150     <paraStyle name="Footer" fontName="Times-Roman"/>
 151     <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
 152     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 153     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
 154     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 155     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 156     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 157     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 158     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 159     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 160     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 161     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 162     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 163     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 164     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 165     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 166     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 167     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 168     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 169     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 170     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 171     <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 172     <paraStyle name="terp_default_Right_Bold_Right_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 173     <paraStyle name="terp_default_Bold_9_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 174     <paraStyle name="terp_default_Right_balance" fontName="Helvetica" fontSize="8.0" leading="0" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 175   </stylesheet>
 176   <images/>
 177   <story>
 178       <para style="terp_default_2">
 179       <font color="white"> </font>
 180     </para>
 181     <blockTable colWidths="539.0" style="Table_header">
 182       <tr>
 183         <td>
 184           <para style="terp_header_Centre">Partner Ledger</para>
 185         </td>
 186         <tr>
 187           <td>
 188             <para style="P4">
 189       <font color="white"> </font>
 190     </para>
 191         </td>
 192         </tr>
 193       </tr>
 194     </blockTable>
 195         <para style="P4">
 196       <font color="white"> </font>
 197     </para>
 198         <para style="P4">
 199       <font color="white"> </font>
 200     </para>
 201     <para style="P4">
 202       <font color="white"> </font>
 203     </para>
 204       <para style="P4">
 205       <font color="white"> </font>
 206     </para>
 207       <para style="P4">
 208       <font color="white"> </font>
 209     </para>
 210           <para style="P4">
 211       <font color="white"> </font>
 212     </para>
 213       <para style="P4">
 214       <font color="white"> </font>
 215     </para>
 216           <para style="P4">
 217       <font color="white"> </font>
 218     </para>
 219       <para style="P4">
 220       <font color="white"> </font>
 221     </para>
 222           <para style="P4">
 223       <font color="white"> </font>
 224     </para>
 225     <para style="P3">[[ repeatIn(objects, 'p') ]] [[ setLang(p.lang) ]]</para>
 226       <blockTable colWidths="80.0,80.0,80.0,130.0,70.0,80.0" style="Table2_header">
 227       <tr>
 228         <td><para style="terp_tblheader_General_Centre">Chart of Account </para></td>
 229         <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
 230                 <td><para style="terp_tblheader_General_Centre">Journal</para></td>
 231         <td><para style="terp_tblheader_General_Centre">Filter By  [[ get_filter(data)!='No Filter' and get_filter(data) ]]</para></td>
 232          <td><para style="terp_tblheader_General_Centre">Partner's</para></td>
 233         <td><para style="terp_tblheader_General_Centre">Printing Date</para></td>
 234       </tr>
 235         <tr>
 236            <td><para style="terp_default_Centre_8">[[ get_account(data) or ''  ]]</para></td>
 237        <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data) or '' ]]</para></td>
 238                 <td><para style="terp_default_Centre_8">[[', '.join([ lt or '' for lt in get_journal(data) ]) ]]</para></td>
 239         <td><para style="terp_default_Centre_8">[[ get_filter(data)=='No Filter' and get_filter(data) or removeParentNode('para') ]] </para>
 240                 <blockTable colWidths="60.0,60.0" style="Table3_header">[[ get_filter(data)=='Date' or removeParentNode('blockTable') ]]
 241                                 <tr>
 242                        <td><para style="terp_tblheader_General_Centre">Start Date</para></td>
 243                                 <td><para style="terp_tblheader_General_Centre">End Date</para></td>
 244                         </tr>
 245                         <tr>
 246                                 <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
 247                                 <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
 248                         </tr>
 249                 </blockTable>
 250                 <blockTable colWidths="65.0,65.0" style="Table3_header">[[ get_filter(data)=='Periods' or removeParentNode('blockTable') ]]
 251                                 <tr>
 252                                 <td><para style="terp_tblheader_General_Centre">Start Period</para></td>
 253                                 <td><para style="terp_tblheader_General_Centre">End Period</para></td>
 254                         </tr>
 255                         <tr>
 256                                 <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
 257                                 <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
 258                         </tr>
 259                  </blockTable>
 260                 </td>
 261         <td><para style="terp_default_Centre_8">[[ get_partners() ]]</para></td>
 262         <td><para style="terp_default_Centre_8">[[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'), date_time = True) ]] </para></td>
 263         </tr>
 264         </blockTable>
 265      <para style="P4">
 266       <font color="white"> </font>
 267     </para>
 268         <para style="P4">
 269       <font color="white"> </font>
 270     </para>
 271             <para style="P4">
 272       <font color="white"> </font>
 273     </para>
 274        <para style="P4">
 275       <font color="white"> </font>
 276     </para>
 277       <para style="P4">
 278       <font color="white"> </font>
 279     </para>
 280     <blockTable colWidths="55.0,28.0,60.0,81.0,125.0,57.0,58.0,65.0" style="Table_header_1">[[ display_currency(data) == False or removeParentNode('blockTable') ]]
 281       <tr>
 282         <td>
 283           <para style="terp_tblheader_Details">Date</para>
 284         </td>
 285         <td>
 286           <para style="terp_tblheader_Details">JNRL</para>
 287         </td>
 288         <td>
 289           <para style="terp_tblheader_Details">Ref.</para>
 290         </td>
 291         <td>
 292           <para style="terp_tblheader_Details">A/c No.- Name</para>
 293         </td>
 294         <td>
 295           <para style="terp_tblheader_Details">Entry Label</para>
 296         </td>
 297         <td>
 298           <para style="terp_tblheader_Details_Right">Debit</para>
 299         </td>
 300         <td>
 301           <para style="terp_tblheader_Details_Right">Credit</para>
 302         </td>
 303         <td>
 304           <para style="terp_tblheader_Details_Right">Balance</para>
 305         </td>
 306       </tr>
 307     </blockTable>
 308     <para style="P4">
 309       <font color="white"> </font>
 310     </para>
 311     <para style="terp_default_2">
 312       <font color="white"> </font>
 313     </para>
 314     <blockTable colWidths="349.0,57.0,58.0,65.0" style="Table2">[[ display_currency(data) == False or removeParentNode('blockTable') ]]
 315
 316       <tr>
 317         <td>
 318           <para style="P2">[[ p.ref ]] - [[ p.name ]]</para>
 319         </td>
 320         <td>
 321           <para style="P5">[[ formatLang((sum_debit_partner(p))) ]]</para>
 322         </td>
 323         <td>
 324           <para style="P5">[[ formatLang((sum_credit_partner(p))) ]] </para>
 325         </td>
 326         <td>
 327           <para style="P5">[[ formatLang((sum_debit_partner(p) - sum_credit_partner(p))) ]] [[ company.currency_id.symbol ]]</para>
 328         </td>
 329       </tr>
 330        <tr>
 331         <td>[[ data['form']['initial_balance'] or  removeParentNode('tr') ]]
 332           <para style="P2">Initial Balance</para>
 333         </td>
 334         <td>
 335           <para style="terp_default_Right_9">[[ formatLang(get_intial_balance(p)[0][0])]]</para>
 336         </td>
 337         <td>
 338           <para style="terp_default_Right_9">[[ formatLang(get_intial_balance(p)[0][1]) ]]</para>
 339         </td>
 340         <td>
 341           <para style="terp_default_Right_9">[[ formatLang(get_intial_balance(p)[0][2]) ]] [[ company.currency_id.symbol ]]</para>
 342         </td>
 343     </tr>
 344     </blockTable>
 345     <para style="terp_default_2">
 346       <font color="white"> </font>
 347     </para>
 348     <section>
 349       <para style="P1">[[ repeatIn(lines(p), 'line') ]]</para>
 350       <blockTable colWidths="55.0,28.0,60.0,81.0,125.0,57.0,58.0,65.0" style="Table3">[[ display_currency(data) == False or removeParentNode('blockTable') ]]
 351         <tr>
 352           <td>
 353             <para style="P3">[[ formatLang(line['date'],date=True) ]]</para>
 354           </td>
 355           <td>
 356             <para style="P3">[[ line['code'] ]]</para>
 357           </td>
 358           <td>
 359             <para style="P3">[[ line['move_name'] ]]</para>
 360           </td>
 361           <td>
 362             <para style="P3">[[ line['a_code'] ]] - [[ line['a_name'] ]]</para>
 363           </td>
 364           <td>
 365             <para style="P3">[[ line['ref'] ]] - [[ line['name'] ]]</para>
 366           </td>
 367           <td>
 368             <para style="terp_default_Right_9">[[ formatLang((line['debit'])) ]]</para>
 369           </td>
 370           <td>
 371             <para style="terp_default_Right_9">[[ formatLang((line['credit'])) ]]</para>
 372           </td>
 373           <td>
 374             <para style="terp_default_Right_9">[[ formatLang((line['progress'])) ]] [[ company.currency_id.symbol ]]</para>
 375           </td>
 376         </tr>
 377       </blockTable>
 378       <para style="terp_default_2">
 379         <font color="white"> </font>
 380       </para>
 381     </section>
 382      <blockTable colWidths="50.0,25.0,60.0,81.0,97.0,56.0,58.0,63.0,53.0" style="Table4">[[ display_currency(data) == True or removeParentNode('blockTable') ]]
 383       <tr>
 384         <td>
 385           <para style="terp_tblheader_Details">Date</para>
 386         </td>
 387         <td>
 388           <para style="terp_tblheader_Details">JNRL</para>
 389         </td>
 390         <td>
 391           <para style="terp_tblheader_Details">Ref.</para>
 392         </td>
 393         <td>
 394           <para style="terp_tblheader_Details">A/c No.- Name</para>
 395         </td>
 396         <td>
 397           <para style="terp_tblheader_Details">Entry Label</para>
 398         </td>
 399         <td>
 400           <para style="terp_tblheader_Details_Right">Debit</para>
 401         </td>
 402         <td>
 403           <para style="terp_tblheader_Details_Right">Credit</para>
 404         </td>
 405         <td>
 406           <para style="terp_tblheader_Details_Right">Balance</para>
 407         </td>
 408          <td>
 409           <para style="terp_tblheader_Details_Right">Currency</para>
 410         </td>
 411       </tr>
 412     </blockTable>
 413     <para style="P4">
 414       <font color="white"> </font>
 415     </para>
 416     <para style="terp_default_2">
 417       <font color="white"> </font>
 418     </para>
 419     <blockTable colWidths="308.0,56.0,58.0,63.0,53.0" style="Table6">[[ display_currency(data) == True or removeParentNode('blockTable') ]]
 420
 421       <tr>
 422         <td>
 423           <para style="P2">[[ p.ref ]] - [[ p.name ]]</para>
 424         </td>
 425         <td>
 426           <para style="P5">[[ formatLang((sum_debit_partner(p))) ]]</para>
 427         </td>
 428         <td>
 429           <para style="P5">[[ formatLang((sum_credit_partner(p))) ]]</para>
 430         </td>
 431         <td>
 432           <para style="P5">[[ formatLang((sum_debit_partner(p) - sum_credit_partner(p))) ]] [[ company.currency_id.symbol ]]</para>
 433         </td>
 434         <td>
 435           <para style="P5">
 436             <font color="white"> </font>
 437           </para>
 438         </td>
 439       </tr>
 440       <tr>
 441         <td>[[display_initial_balance(data) or  removeParentNode('tr') ]]
 442           <para style="P2">Initial Balance</para>
 443         </td>
 444          <td>
 445           <para style="terp_default_Right_9">[[ formatLang(get_intial_balance(p)[0][0]) ]]</para>
 446         </td>
 447         <td>
 448           <para style="terp_default_Right_9">[[ formatLang(get_intial_balance(p)[0][1]) ]]</para>
 449         </td>
 450         <td>
 451           <para style="terp_default_Right_9">[[ formatLang(get_intial_balance(p)[0][2]) ]] [[ company.currency_id.symbol ]]</para>
 452         </td>
 453                 <td>
 454           <para style="P5"></para>
 455         </td>
 456     </tr>
 457     </blockTable>
 458     <para style="terp_default_2">
 459       <font color="white"> </font>
 460     </para>
 461     <section>
 462       <para style="P1">[[ repeatIn(lines(p), 'line') ]]</para>
 463       <blockTable colWidths="50.0,25.0,60.0,81.0,97.0,56.0,58.0,63.0,53.0" style="Table7">[[ display_currency(data) == True or removeParentNode('blockTable') ]]
 464         <tr>
 465           <td>
 466             <para style="P3">[[ formatLang(line['date'],date=True) ]]</para>
 467           </td>
 468           <td>
 469             <para style="P3">[[ line['code'] ]]</para>
 470           </td>
 471           <td>
 472             <para style="P3">[[ line['move_name'] ]]</para>
 473           </td>
 474           <td>
 475             <para style="P3">[[ line['a_code'] ]] - [[ line['a_name'] ]]</para>
 476           </td>
 477           <td>
 478             <para style="P3">[[ (line['ref'] or '') + ' ' + line['name'] ]]</para>
 479           </td>
 480           <td>
 481             <para style="terp_default_Right_9">[[ formatLang((line['debit'])) ]]</para>
 482           </td>
 483           <td>
 484             <para style="terp_default_Right_9">[[ formatLang((line['credit'])) ]]</para>
 485           </td>
 486           <td>
 487             <para style="terp_default_Right_9">[[ formatLang((line['progress'])) ]] [[ company.currency_id.symbol ]]</para>
 488           </td>
 489           <td>
 490             <para style="terp_default_Right_9">[[ formatLang(line['amount_currency'] or '') ]] [[ line['currency_code'] or '' ]]</para>
 491           </td>
 492         </tr>
 493       </blockTable>
 494       <para style="terp_default_2">
 495         <font color="white"> </font>
 496       </para>
 497     </section>
 498
 499     <para style="terp_default_9">
 500       <font color="white"> </font>
 501     </para>
 502   </story>
 503 </document>