addons/account/report/account_balance_sheet.rml

   1 <?xml version="1.0"?>
   2 <document filename="test.pdf">
   3   <template pageSize="(595.0,842.0)" title="Balance sheet" author="OpenERP S.A. (sales@openerp.com)" allowSplitting="20">
   4     <pageTemplate id="first">
   5       <frame id="first" x1="28.0" y1="28.0" width="539" height="786"/>
   6     </pageTemplate>
   7   </template>
   8   <stylesheet>
   9     <blockTableStyle id="Standard_Outline">
  10       <blockAlignment value="LEFT"/>
  11       <blockValign value="TOP"/>
  12     </blockTableStyle>
  13     <blockTableStyle id="Table_Heading">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16     </blockTableStyle>
  17     <blockTableStyle id="Table_Company_Name">
  18       <blockAlignment value="LEFT"/>
  19       <blockValign value="TOP"/>
  20     </blockTableStyle>
  21     <blockTableStyle id="Table_Date_from_To">
  22       <blockAlignment value="LEFT"/>
  23       <blockValign value="TOP"/>
  24     </blockTableStyle>
  25     <blockTableStyle id="Table_Account_Line_Title">
  26       <blockAlignment value="LEFT"/>
  27       <blockValign value="TOP"/>
  28       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  29       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  30       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="0,-1"/>
  31       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  32       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  33       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,0" stop="1,-1"/>
  34       <lineStyle kind="LINEBEFORE" 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,0" 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,0" stop="3,-1"/>
  41     </blockTableStyle>
  42     <blockTableStyle id="Table5">
  43       <blockAlignment value="LEFT"/>
  44       <blockValign value="TOP"/>
  45     </blockTableStyle>
  46     <blockTableStyle id="Table_Net_Profit_Loss">
  47       <blockAlignment value="LEFT"/>
  48       <blockValign value="TOP"/>
  49       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  50       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  51       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  52       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  53       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  54       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  55       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  56       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  57       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  58       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  59       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  60       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  61       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  62     </blockTableStyle>
  63     <blockTableStyle id="Table1">
  64       <blockAlignment value="LEFT"/>
  65       <blockValign value="TOP"/>
  66       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  67       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  68       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
  69       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  70       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  71       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,0" stop="1,-1"/>
  72       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  73       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  74       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,0" stop="2,-1"/>
  75       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  76       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  77       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  78       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,0" stop="3,-1"/>
  79     </blockTableStyle>
  80    <blockTableStyle id="Table2_header">
  81       <blockAlignment value="LEFT"/>
  82       <blockValign value="TOP"/>
  83     <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
  84       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  85       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  86       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  87       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  88       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  89       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  90       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  91       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  92       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  93       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  94       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
  95       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
  96       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
  97       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  98       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
  99       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
 100       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
 101       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
 102       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
 103       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
 104       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
 105       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
 106       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
 107       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
 108       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
 109       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
 110       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
 111     </blockTableStyle>
 112
 113     <blockTableStyle id="Table2">
 114       <blockAlignment value="LEFT"/>
 115       <blockValign value="TOP"/>
 116     </blockTableStyle>
 117     <blockTableStyle id="Table3">
 118       <blockAlignment value="LEFT"/>
 119       <blockValign value="TOP"/>
 120         <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 121         <lineStyle kind="LINEAFTER" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 122         <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 123         <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
 124     </blockTableStyle>
 125     <initialize>
 126       <paraStyle name="all" alignment="justify"/>
 127     </initialize>
 128     <paraStyle name="P1" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 129     <paraStyle name="P2" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 130     <paraStyle name="Standard" fontName="Times-Roman"/>
 131     <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
 132     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 133     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 134     <paraStyle name="Caption" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" spaceBefore="6.0" spaceAfter="6.0"/>
 135     <paraStyle name="Index" fontName="Helvetica" fontSize="9.0" leading="11"/>
 136     <paraStyle name="Footer" fontName="Times-Roman"/>
 137     <paraStyle name="Table Contents" fontName="Times-Roman"/>
 138     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
 139     <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
 140     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 141     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
 142     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 143     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 144     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 145     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 146     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 147     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 148     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 149     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 150     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 151     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 152     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 153     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 154     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 155     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 156     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 157     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 158     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 159     <paraStyle name="terp_default_Right_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 160     <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 161   </stylesheet>
 162   <images/>
 163   <story>
 164     <para style="Standard">
 165       <font color="white"> </font>
 166     </para>
 167     <blockTable colWidths="539.0" style="Table_Company_Name">
 168       <tr>
 169         <td>
 170           <para style="terp_header_Centre">Balance Sheet</para>
 171         </td>
 172       </tr>
 173     </blockTable>
 174         <para style="terp_default_8">[[ get_data(data) or removeParentNode('para') ]]</para>
 175         <para style="terp_default_9">
 176       <font color="white"> </font>
 177     </para>
 178       <blockTable colWidths="120.0,100.0,140.0,90.0,90.0" style="Table2_header" >
 179       <tr>
 180         <td><para style="terp_tblheader_General_Centre">Chart of Account </para></td>
 181         <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
 182         <td><para style="terp_tblheader_General_Centre">Filter By <font>[[ get_filter(data)!='No Filter' and '' or removeParentNode('font') ]]</font></para></td>
 183                 <td><para style="terp_tblheader_General_Centre">Display Account</para></td>
 184         <td><para style="terp_tblheader_General_Centre">Printing Date</para></td>
 185       </tr>
 186         <tr>
 187            <td><para style="terp_default_Centre_8">[[ get_account(data) or removeParentNode('para') ]]</para></td>
 188        <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data)  or '' ]]</para></td>
 189         <td><para style="terp_default_Centre_8">[[ get_filter(data)=='No Filter' and get_filter(data) or removeParentNode('para') ]] </para>
 190                 <blockTable colWidths="60.0,60.0" style="Table3">[[ get_filter(data)=='Date' or removeParentNode('blockTable') ]]
 191                                 <tr>
 192                        <td><para style="terp_tblheader_Details_Centre">Start Date</para></td>
 193                                 <td><para style="terp_tblheader_Details_Centre">End Date</para></td>
 194                         </tr>
 195                         <tr>
 196                                 <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
 197                                 <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
 198                         </tr>
 199                 </blockTable>
 200                 <blockTable colWidths="65.0,60.0" style="Table3">[[ get_filter(data)=='Periods' or removeParentNode('blockTable') ]]
 201                                 <tr>
 202                                 <td><para style="terp_tblheader_Details_Centre">Start Period</para></td>
 203                                 <td><para style="terp_tblheader_Details_Centre">End Period</para></td>
 204                         </tr>
 205                         <tr>
 206                                 <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
 207                                 <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
 208                         </tr>
 209                  </blockTable>
 210                 </td>
 211                 <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>
 212                 <td><para style="terp_default_Centre_8">[[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'), date_time = True) ]] </para></td>
 213         </tr>
 214         </blockTable>
 215             <para style="Standard">
 216       <font color="white"> </font>
 217     </para>
 218         <para style="Standard">
 219       <font color="white"> </font>
 220     </para>
 221     <para style="terp_default_9">
 222       <font color="white"> </font>
 223     </para>
 224     <blockTable colWidths="100.0,326.0,113.0" style="Table_Account_Line_Title" repeatRows="1">
 225       <tr>
 226         <td>
 227           <para style="terp_default_Bold_9">Code</para>
 228         </td>
 229         <td>
 230           <para style="terp_default_Bold_9">Liabilities</para>
 231         </td>
 232         <td>
 233           <para style="terp_tblheader_Details_Right">Total Amount([[ get_currency(data) ]])</para>
 234         </td>
 235       </tr>
 236       <tr>
 237         <td>
 238           <para style="terp_default_9"><font face="Times-Roman">[[ repeatIn(get_lines_another('liability'), 'a') ]]</font>[[ a['code'] ]]<font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font') ]] </font></para>
 239         </td>
 240         <td>
 241           <para style="terp_default_9"><font color="white">[[  '. '*(a['level']-1) ]]</font><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font')  ]][[ a['name'] ]]</font></para>
 242         </td>
 243         <td>
 244           <para style="terp_default_Right_9"><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Right_9_Bold'})) or removeParentNode('font')  ]]</font><font>[[ formatLang(abs(a['balance'])) ]] [[ company.currency_id.symbol ]]</font></para>
 245         </td>
 246       </tr>
 247     </blockTable>
 248     <blockTable colWidths="426.0,113.0" style="Table_Net_Profit_Loss">
 249       <tr>
 250         <td>
 251           <para style="terp_default_Bold_9">Balance:([[ get_currency(data) ]])</para>
 252         </td>
 253         <td>
 254           <para style="terp_default_Right_9_Bold"><u>[[ formatLang(abs(sum_dr())) ]] [[ company.currency_id.symbol ]]</u></para>
 255         </td>
 256       </tr>
 257     </blockTable>
 258     <condPageBreak height="20cm"/>
 259     <para style="terp_default_9">
 260       <font color="white"> </font>
 261     </para>
 262     <blockTable colWidths="100.0,326.0,113.0" style="Table1" repeatRows="1">
 263       <tr>
 264         <td>
 265           <para style="terp_default_Bold_9">Code</para>
 266         </td>
 267         <td>
 268           <para style="terp_default_Bold_9">Assets</para>
 269         </td>
 270         <td>
 271           <para style="terp_tblheader_Details_Right">Total Amount([[ get_currency(data) ]])</para>
 272         </td>
 273       </tr>
 274       <tr>
 275         <td>
 276           <para style="terp_default_9"><font face="Times-Roman">[[ repeatIn(get_lines_another('asset'), 'a') ]]</font>[[ a['code'] ]]<font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font')  ]]</font></para>
 277         </td>
 278         <td>
 279           <para style="terp_default_9"><font color="white">[[  '. '*(a['level']-1) ]]</font><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font')  ]][[ a['name'] ]]</font></para>
 280         </td>
 281         <td>
 282           <para style="terp_default_Right_9"><font>[[ a['level']&lt;4 and ( setTag('para','para',{'style':'terp_default_Right_9_Bold'})) or removeParentNode('font')  ]]</font><font>[[ formatLang(abs(a['balance'])) ]] [[ company.currency_id.symbol ]]</font></para>
 283         </td>
 284       </tr>
 285     </blockTable>
 286     <blockTable colWidths="426.0,113.0" style="Table3">
 287       <tr>
 288         <td>
 289           <para style="terp_default_Bold_9">Balance:([[ get_currency(data) ]])</para>
 290         </td>
 291         <td>
 292           <para style="terp_default_Right_9_Bold"><u>[[ formatLang(abs(sum_cr())) ]] [[ company.currency_id.symbol ]]</u></para>
 293         </td>
 294       </tr>
 295     </blockTable>
 296     <para style="Standard">
 297       <font color="white"> </font>
 298     </para>
 299   </story>
 300 </document>