addons/account/report/account_aged_partner_balance.rml

   1 <?xml version="1.0"?>
   2 <document filename="Aged Trial Balance.pdf">
   3    <template pageSize="(842.0,595.0)" title="Aged Trial Balance" author="OpenERP S.A.(sales@openerp.com)" allowSplitting="20">
   4     <pageTemplate id="first">
   5       <frame id="first" x1="28.0" y1="57.0" width="772" height="481"/>
   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="Table_header_Content">
  24       <blockAlignment value="LEFT"/>
  25       <blockValign value="TOP"/>
  26     </blockTableStyle>
  27     <blockTableStyle id="Tableau1">
  28       <blockAlignment value="LEFT"/>
  29       <blockValign value="TOP"/>
  30       <lineStyle kind="GRID" colorName="black"/>
  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="#e6e6e6" start="0,2" stop="-1,-1"/>
  36
  37       <blockValign value="TOP"/>
  38       <blockAlignment value="LEFT" start="2,1" stop="-1,-1"/>
  39     </blockTableStyle>
  40     <blockTableStyle id="Table8">
  41       <blockAlignment value="LEFT"/>
  42       <blockValign value="TOP"/>
  43       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
  44       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
  45       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="0,0" stop="-1,-1"/>
  46       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
  47     </blockTableStyle>
  48
  49     <blockTableStyle id="Tableau3">
  50       <blockAlignment value="LEFT"/>
  51       <blockValign value="TOP"/>
  52       <lineStyle kind="GRID" colorName="black"/>
  53     </blockTableStyle>
  54     <initialize>
  55       <paraStyle name="all" alignment="justify"/>
  56     </initialize>
  57     <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  58     <paraStyle name="P2" fontName="Helvetica" fontSize="8.3" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  59     <paraStyle name="P2_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  60     <paraStyle name="Total" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  61     <paraStyle name="Total_right" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  62     <paraStyle name="P3" fontName="Helvetica" fontSize="15.0" leading="20" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  63     <paraStyle name="P4" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  64     <paraStyle name="P5" fontName="Helvetica" fontSize="8.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  65     <paraStyle name="P6" fontName="Helvetica" fontSize="8.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  66     <paraStyle name="P7" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  67     <paraStyle name="P8" fontName="Helvetica" fontSize="8.3" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  68     <paraStyle name="content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  69     <paraStyle name="P9" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  70     <paraStyle name="P10" fontName="Helvetica" fontSize="8.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  71     <paraStyle name="P11" fontName="Helvetica" fontSize="8.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  72     <paraStyle name="P12" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="0.0"/>
  73     <paraStyle name="P13" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="0.0"/>
  74     <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  75     <paraStyle name="P10" fontName="Helvetica" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  76     <paraStyle name="Standard" fontName="Helvetica"/>
  77     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
  78     <paraStyle name="Heading" fontName="Helvetica" fontSize="8.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
  79     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
  80     <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
  81     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  82     <paraStyle name="Caption" fontName="Helvetica" fontSize="8.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
  83     <paraStyle name="Index" fontName="Helvetica"/>
  84     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
  85     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
  86     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
  87     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  88     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  89     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
  90     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
  91     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  92     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  93     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  94     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  95     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  96     <paraStyle name="terp_default_9_italic" fontName="Helvetica-Oblique" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  97     <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  98     <paraStyle name="terp_default_Right_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  99         <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 100
 101   </stylesheet>
 102   <story>
 103
 104      <blockTable colWidths="180.0,180.0,180.0" style="Table_header_Content">
 105       <tr>
 106         <td><para style="terp_header"><font color="white"> </font></para>
 107         </td>
 108         <td><para style="terp_header_Centre">Aged Trial Balance</para></td>
 109         <td><para style="terp_header"><font color="white"> </font></para></td>
 110       </tr>
 111     </blockTable>
 112     <blockTable colWidths="110.0,110.0,110.0,110.0,128.0,93.0,110.0" style="Table8">
 113       <tr>
 114         <td>
 115           <para style="terp_tblheader_General_Centre">Chart of Accounts</para>
 116         </td>
 117         <td>
 118           <para style="terp_tblheader_General_Centre">Fiscal Year</para>
 119         </td>
 120         <td>
 121           <para style="terp_tblheader_General_Centre">Start Date</para>
 122         </td>
 123         <td>
 124           <para style="terp_tblheader_General_Centre">Period Length(days)</para>
 125         </td>
 126         <td>
 127           <para style="terp_tblheader_General_Centre">Partner's</para>
 128         </td>
 129         <td>
 130           <para style="terp_tblheader_General_Centre">Analysis Direction</para>
 131         </td>
 132         <td>
 133           <para style="terp_tblheader_General_Centre">Target Moves</para>
 134         </td>
 135       </tr>
 136         <tr>
 137         <td>
 138           <para style="terp_default_Centre_8">[[ get_account(data) or '' ]]</para>
 139         </td>
 140         <td>
 141           <para style="terp_default_Centre_8">[[ get_fiscalyear(data) or '' ]]</para>
 142         </td>
 143         <td>
 144           <para style="terp_default_Centre_8">[[ formatLang(data['form']['date_from'],date=True) ]]</para>
 145         </td>
 146         <td>
 147           <para style="terp_default_Centre_8">[[ data['form']['period_length'] ]]</para>
 148         </td>
 149         <td>
 150           <para style="terp_default_Centre_8">Receivable Accounts[[ data['form']['result_selection'] == 'customer' or removeParentNode('para') ]]</para>
 151           <para style="terp_default_Centre_8">Payable Accounts[[ data['form']['result_selection'] == 'supplier' or removeParentNode('para') ]]</para>
 152           <para style="terp_default_Centre_8">Receivable and Payable Accounts[[ data['form']['result_selection'] == 'customer_supplier' or removeParentNode('para') ]]</para>
 153         </td>
 154         <td>
 155           <para style="terp_default_Centre_8">[[ data['form']['direction_selection'] ]]</para>
 156         </td>
 157         <td>
 158           <para style="terp_default_Centre_8">[[ get_target_move(data) ]]</para>
 159         </td>
 160       </tr>
 161       </blockTable>
 162         <para style="P9">
 163       <font color="white"> </font>
 164     </para>
 165     <blockTable colWidths="135.0,90.0,90.0,90.0,90.0,90.0,90.0,90.0" style="Table2" repeatRows="1">
 166       <tr>
 167         <td>
 168           <para style="terp_tblheader_Details">Partners</para>
 169         </td>
 170         <td>
 171           <para style="terp_tblheader_Details_Right">Due[[ data['form']['direction_selection'] == 'future' and ' ' or removeParentNode('para') ]]</para>
 172           <para style="terp_tblheader_Details_Right">Not due[[ data['form']['direction_selection'] != 'future' and ' ' or removeParentNode('para') ]]</para>
 173         </td>
 174         <td>
 175           <para style="terp_tblheader_Details_Right">[[ data['form']['4']['name'] ]]</para>
 176         </td>
 177         <td>
 178           <para style="terp_tblheader_Details_Right">[[ data['form']['3']['name'] ]]</para>
 179         </td>
 180         <td>
 181           <para style="terp_tblheader_Details_Right">[[ data['form']['2']['name'] ]]</para>
 182         </td>
 183         <td>
 184           <para style="terp_tblheader_Details_Right">[[ data['form']['1']['name'] ]]</para>
 185         </td>
 186         <td>
 187           <para style="terp_tblheader_Details_Right">[[ data['form']['0']['name'] ]]</para>
 188         </td>
 189         <td>
 190           <para style="terp_tblheader_Details_Right">Total</para>
 191         </td>
 192       </tr>
 193
 194       <tr>
 195
 196         <td>
 197           <para style="P3"> <font color="white">[[ (get_lines(data['form']), 'partner') == False or removeParentNode('para')  ]]</font></para>
 198           <para style="P3"> <font color="white">[[ (get_lines_with_out_partner(data['form']), 'not_partner') == False or removeParentNode('para')  ]]</font></para>
 199           <para style="Total">Account Total</para>
 200         </td>
 201         <td>
 202           <para style="Total_right">[[ formatLang(get_direction('6'), currency_obj=company.currency_id) ]]</para>
 203         </td>
 204         <td>
 205           <para style="Total_right">[[ formatLang(get_for_period('4'), currency_obj=company.currency_id) ]]</para>
 206         </td>
 207         <td>
 208           <para style="Total_right">[[ formatLang(get_for_period('3'), currency_obj=company.currency_id) ]]</para>
 209         </td>
 210         <td>
 211           <para style="Total_right">[[ formatLang(get_for_period('2'), currency_obj=company.currency_id) ]]</para>
 212         </td>
 213         <td>
 214           <para style="Total_right">[[ formatLang(get_for_period('1'), currency_obj=company.currency_id) ]]</para>
 215         </td>
 216         <td>
 217           <para style="Total_right">[[ formatLang(get_for_period('0'), currency_obj=company.currency_id) ]]</para>
 218         </td>
 219         <td>
 220           <para style="Total_right">[[ formatLang(get_total('5'), currency_obj=company.currency_id) ]]</para>
 221         </td>
 222       </tr>
 223
 224       <tr>
 225         <td>
 226           <para style="P3">[[ repeatIn(get_lines(data['form']), 'partner') ]]</para>
 227           <para style="P2_content">[[ partner['name'] ]]</para>
 228         </td>
 229         <td>
 230           <para style="content">[[ formatLang(partner['direction'], currency_obj=company.currency_id) ]]</para>
 231         </td>
 232         <td>
 233           <para style="content">[[ formatLang(partner['4'], currency_obj=company.currency_id) ]]</para>
 234         </td>
 235         <td>
 236           <para style="content">[[ formatLang(partner['3'], currency_obj=company.currency_id) ]]</para>
 237         </td>
 238         <td>
 239           <para style="content">[[ formatLang(partner['2'], currency_obj=company.currency_id) ]]</para>
 240         </td>
 241         <td>
 242           <para style="content">[[ formatLang(partner['1'], currency_obj=company.currency_id) ]]</para>
 243         </td>
 244         <td>
 245           <para style="content">[[ formatLang(partner['0'], currency_obj=company.currency_id) ]]</para>
 246         </td>
 247         <td>
 248           <para style="content">[[ formatLang(partner['total'], currency_obj=company.currency_id) ]]</para>
 249         </td>
 250       </tr>
 251       <tr>
 252         <td>
 253           <para style="P3">[[ repeatIn(get_lines_with_out_partner(data['form']), 'not_partner') ]]</para>
 254           <para style="P2_content">[[ not_partner['name'] ]]</para>
 255         </td>
 256         <td>
 257           <para style="content">[[ formatLang(not_partner['direction'], currency_obj=company.currency_id) ]]</para>
 258         </td>
 259         <td>
 260           <para style="content">[[ formatLang(not_partner['4'], currency_obj=company.currency_id) ]]</para>
 261         </td>
 262         <td>
 263           <para style="content">[[ formatLang(not_partner['3'], currency_obj=company.currency_id) ]]</para>
 264         </td>
 265         <td>
 266           <para style="content">[[ formatLang(not_partner['2'], currency_obj=company.currency_id) ]]</para>
 267         </td>
 268         <td>
 269           <para style="content">[[ formatLang(not_partner['1'], currency_obj=company.currency_id) ]]</para>
 270         </td>
 271         <td>
 272           <para style="content">[[ formatLang(not_partner['0'], currency_obj=company.currency_id) ]]</para>
 273         </td>
 274         <td>
 275           <para style="content">[[ formatLang(not_partner['total'], currency_obj=company.currency_id) ]]</para>
 276         </td>
 277       </tr>
 278     </blockTable>
 279
 280     <para style="P9">
 281       <font color="white"> </font>
 282     </para>
 283   </story>
 284 </document>
 285