addons/account/report/account_balance_sheet.rml

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