addons/account/report/account_partner_balance.rml

   1 <?xml version="1.0"?>
   2 <document filename="Partner Balance.pdf">
   3   <template title="Partner Balance" 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     </pageTemplate>
   7   </template>
   8   <stylesheet>
   9     <blockTableStyle id="Standard_Outline">
  10       <blockAlignment value="LEFT"/>
  11       <blockValign value="TOP"/>
  12     </blockTableStyle>
  13     <blockTableStyle id="Table1">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16       <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
  17       <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
  18       <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
  19       <blockBackground colorName="#e6e6e6" start="0,1" stop="0,1"/>
  20       <blockBackground colorName="#e6e6e6" start="1,1" stop="1,1"/>
  21       <blockBackground colorName="#e6e6e6" start="2,1" stop="2,1"/>
  22     </blockTableStyle>
  23     <blockTableStyle id="Table6">
  24       <blockAlignment value="LEFT"/>
  25       <blockValign value="TOP"/>
  26       <lineStyle kind="GRID" colorName="black"/>
  27     </blockTableStyle>
  28     <blockTableStyle id="Table_Company_Name">
  29       <blockAlignment value="LEFT"/>
  30       <blockValign value="TOP"/>
  31     </blockTableStyle>
  32     <blockTableStyle id="Table2">
  33       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  34           <lineStyle kind="LINEBELOW" colorName="#000000" start="0,1" stop="-1,1"/>
  35           <lineStyle kind="LINEBELOW" colorName="#000000" start="0,2" stop="-1,2"/>
  36           <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,3" stop="-1,-1"/>
  37     <blockValign value="TOP"/>
  38     <blockAlignment value="RIGHT" start="2,1" stop="-1,-1"/>
  39     </blockTableStyle>
  40     <blockTableStyle id="Table3">
  41       <blockAlignment value="LEFT"/>
  42       <blockValign value="TOP"/>
  43            <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  44     </blockTableStyle>
  45     <blockTableStyle id="Table4">
  46       <blockAlignment value="LEFT"/>
  47       <blockValign value="TOP"/>
  48       <lineStyle kind="GRID" colorName="black"/>
  49     </blockTableStyle>
  50    <blockTableStyle id="Tableau3">
  51       <blockAlignment value="LEFT"/>
  52       <blockValign value="TOP"/>
  53       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" />
  54       <lineStyle kind="OUTLINE" colorName="#e6e6e6" />
  55       <blockBackground colorName="white" start="0,0" stop="-1,0"/>
  56     </blockTableStyle>
  57       <blockTableStyle id="Table_Sub_Header_Content">
  58       <blockAlignment value="LEFT"/>
  59       <blockValign value="TOP"/>
  60       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  61       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  62       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  63       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  64       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  65       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  66       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  67       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  68       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  69       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  70       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  71       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  72       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  73       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  74       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="4,0" stop="4,-1"/>
  75       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
  76       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  77       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="5,0" stop="5,-1"/>
  78       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
  79       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  80     </blockTableStyle>
  81     <blockTableStyle id="Table2_header">
  82       <blockAlignment value="LEFT"/>
  83       <blockValign value="TOP"/>
  84     <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
  85       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  86       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  87       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  88       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  89       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  90       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  91       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  92       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  93       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  94       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  95       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  96       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  97       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  98       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  99       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
 100       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
 101       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
 102       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
 103       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
 104       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
 105       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
 106       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
 107       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
 108       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
 109       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
 110       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
 111       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
 112     </blockTableStyle>
 113
 114     <blockTableStyle id="Table_Subheader_Content_detail">
 115       <blockAlignment value="LEFT"/>
 116       <blockValign value="TOP"/>
 117       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
 118       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
 119       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
 120       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
 121       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
 122       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
 123       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
 124       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
 125       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
 126       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
 127        <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
 128       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
 129       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
 130       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
 131       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="4,0" stop="4,-1"/>
 132       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
 133       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
 134       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="5,0" stop="5,-1"/>
 135       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
 136       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
 137     </blockTableStyle>
 138
 139     <initialize>
 140       <paraStyle name="all" alignment="justify"/>
 141     </initialize>
 142
 143     <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 144     <paraStyle name="P4" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 145     <paraStyle name="P5" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 146     <paraStyle name="P6" fontName="Helvetica" fontSize="11.0" leading="12" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 147     <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="9" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 148     <paraStyle name="P8" fontName="Helvetica-Bold" fontSize="9" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 149     <paraStyle name="P9" fontName="Helvetica" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 150     <paraStyle name="P9b" fontName="Helvetica-Bold" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 151     <paraStyle name="P10" fontName="Helvetica" alignment="CENTER"/>
 152     <paraStyle name="P11" fontName="Helvetica" fontSize="8.0" leading="10"/>
 153     <paraStyle name="P12" fontName="Helvetica-Bold" fontSize="9.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 154     <paraStyle name="P12a" fontName="Helvetica-Bold" fontSize="9.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 155     <paraStyle name="P12b" fontName="Helvetica-Bold" fontSize="9.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 156     <paraStyle name="P13" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 157     <paraStyle name="P14" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Bold" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 158     <paraStyle name="Standard" fontName="Helvetica"/>
 159     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 160     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 161     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 162     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 163     <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 164     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 165     <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="11" spaceBefore="6.0" spaceAfter="6.0"/>
 166     <paraStyle name="Index" fontName="Helvetica"/>
 167     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 168         <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 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="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 171   </stylesheet>
 172
 173   <story>
 174
 175     <blockTable colWidths="539.0" style="Table_Company_Name">
 176       <tr>
 177         <td>
 178           <para style="terp_header_Centre">Partner Balance</para>
 179         </td>
 180       </tr>
 181     </blockTable>
 182     <para style="terp_default_8">
 183       <font color="white"> </font>
 184     </para>
 185         <blockTable colWidths="90.0,80.0,80.0,130.0,80.0,80.0" style="Table2_header">
 186       <tr>
 187          <td><para style="terp_tblheader_General_Centre">Chart of Accounts</para></td>
 188         <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
 189         <td><para style="terp_tblheader_General_Centre">Journals</para></td>
 190                 <td><para style="terp_tblheader_General_Centre">Filter By [[ data['form']['filter']!='filter_no' and get_filter(data) ]]</para></td>
 191                 <td><para style="terp_tblheader_General_Centre">Partner's</para></td>
 192         <td><para style="terp_tblheader_General_Centre">Target Moves</para></td>
 193       </tr>
 194         <tr>
 195        <td><para style="terp_default_Centre_8">[[ get_account(data) or removeParentNode('para') ]]</para></td>
 196        <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data)  or '' ]]</para></td>
 197                 <td> <para style="terp_default_Centre_8">[[', '.join([ lt or '' for lt in get_journal(data) ]) ]] </para></td>
 198
 199         <td><para style="terp_default_Centre_8">[[ data['form']['filter']=='filter_no' and get_filter(data) or removeParentNode('para') ]] </para>
 200                 <blockTable colWidths="60.0,60.0" style="Table3">[[ data['form']['filter']=='filter_date' or removeParentNode('blockTable') ]]
 201                                 <tr>
 202                        <td><para style="terp_tblheader_General_Centre">Start Date</para></td>
 203                                 <td><para style="terp_tblheader_General_Centre">End Date</para></td>
 204                         </tr>
 205                         <tr>
 206                                 <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
 207                                 <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
 208                         </tr>
 209                 </blockTable>
 210                 <blockTable colWidths="60.0,60.0" style="Table3">[[ data['form']['filter']=='filter_period' or removeParentNode('blockTable') ]]
 211                                 <tr>
 212                                 <td><para style="terp_tblheader_General_Centre">Start Period</para></td>
 213                                 <td><para style="terp_tblheader_General_Centre">End Period</para></td>
 214                         </tr>
 215                         <tr>
 216                                 <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
 217                                 <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
 218                         </tr>
 219                  </blockTable>
 220                 </td>
 221         <td> <para style="terp_default_Centre_9">[[ get_partners()  ]]</para></td>
 222         <td><para style="terp_default_Centre_8">[[ get_target_move(data) ]] </para></td>
 223         </tr>
 224         </blockTable>
 225
 226     <para style="terp_default_8">
 227       <font color="white"> </font>
 228     </para>
 229     <para style="P12a"></para>
 230          <blockTable colWidths="80.0,140.0,80.0,80.0,80.0,80.0" repeatRows="1" style="Table2">
 231       <tr>
 232         <td><para style="P12a">Code</para></td>
 233         <td><para style="P12a">(Account/Partner) Name</para></td>
 234         <td><para style="P12b">Debit</para></td>
 235         <td><para style="P12b">Credit</para></td>
 236         <td><para style="P12b">Balance</para></td>
 237         <td><para style="P12b">In dispute</para></td>
 238       </tr>
 239       <tr>
 240         <td><para style="P7">Total:</para></td>
 241         <td><para style="P8"></para></td>
 242         <td><para style="P8"><u>[[ formatLang(sum_debit()) ]]</u></para></td>
 243         <td><para style="P8"><u>[[ formatLang(sum_credit()) ]]</u></para></td>
 244         <td><para style="P8"><u>[[ formatLang((sum_debit()-sum_credit()), currency_obj=company.currency_id) ]]</u></para></td>
 245         <td><para style="P8"><u>[[ formatLang(sum_litige(), currency_obj=company.currency_id) ]]</u></para></td>
 246       </tr>
 247       <tr>
 248         <td><para style="P3">[[ repeatIn(lines(), 'a') ]]<font>[[ (a['type']==3 and setTag('para','para',{'fontName':'Helvetica-Bold'})) or removeParentNode('font') ]]</font><font>[[ a['ref'] ]] [[ a['type']==3 and a['code'] ]]</font></para></td>
 249         <td><para style="P3"><font>[[ (a['type']==3 and setTag('para','para',{'fontName':'Helvetica-Bold'})) or removeParentNode('font') ]]</font>[[ a['name'] ]]</para></td>
 250         <td><para style="P4"><font>[[ (a['type']==3 and setTag('para','para',{'fontName':'Helvetica-Bold'})) or removeParentNode('font') ]]</font>[[ formatLang(a['debit']) ]]</para></td>
 251         <td><para style="P4"><font>[[ (a['type']==3 and setTag('para','para',{'fontName':'Helvetica-Bold'})) or removeParentNode('font') ]]</font>[[ formatLang(a['credit']) ]]</para></td>
 252         <td><para style="P4"><font>[[ (a['type']==3 and setTag('para','para',{'fontName':'Helvetica-Bold'})) or removeParentNode('font') ]]</font>[[ formatLang(a['balance'], currency_obj=company.currency_id) ]]</para></td>
 253         <td><para style="P4"><font>[[ (a['type']==3 and setTag('para','para',{'fontName':'Helvetica-Bold'})) or removeParentNode('font') ]]</font>[[ formatLang(a['enlitige'] or 0.0, currency_obj=company.currency_id) ]]</para></td>
 254       </tr>
 255     </blockTable>
 256   </story>
 257 </document>