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"/>
9 <blockTableStyle id="Standard_Outline">
10 <blockAlignment value="LEFT"/>
11 <blockValign value="TOP"/>
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"/>
23 <blockTableStyle id="Table_header_Content">
24 <blockAlignment value="LEFT"/>
25 <blockValign value="TOP"/>
27 <blockTableStyle id="Tableau1">
28 <blockAlignment value="LEFT"/>
29 <blockValign value="TOP"/>
30 <lineStyle kind="GRID" colorName="black"/>
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"/>
37 <blockValign value="TOP"/>
38 <blockAlignment value="LEFT" start="2,1" stop="-1,-1"/>
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"/>
49 <blockTableStyle id="Tableau3">
50 <blockAlignment value="LEFT"/>
51 <blockValign value="TOP"/>
52 <lineStyle kind="GRID" colorName="black"/>
55 <paraStyle name="all" alignment="justify"/>
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"/>
104 <blockTable colWidths="180.0,180.0,180.0" style="Table_header_Content">
106 <td><para style="terp_header"><font color="white"> </font></para>
108 <td><para style="terp_header_Centre">Aged Trial Balance</para></td>
109 <td><para style="terp_header"><font color="white"> </font></para></td>
112 <blockTable colWidths="110.0,110.0,110.0,110.0,128.0,93.0,110.0" style="Table8">
115 <para style="terp_tblheader_General_Centre">Chart of Accounts</para>
118 <para style="terp_tblheader_General_Centre">Fiscal Year</para>
121 <para style="terp_tblheader_General_Centre">Start Date</para>
124 <para style="terp_tblheader_General_Centre">Period Length(days)</para>
127 <para style="terp_tblheader_General_Centre">Partner's</para>
130 <para style="terp_tblheader_General_Centre">Analysis Direction</para>
133 <para style="terp_tblheader_General_Centre">Target Moves</para>
138 <para style="terp_default_Centre_8">[[ get_account(data) or '' ]]</para>
141 <para style="terp_default_Centre_8">[[ get_fiscalyear(data) or '' ]]</para>
144 <para style="terp_default_Centre_8">[[ formatLang(data['form']['date_from'],date=True) ]]</para>
147 <para style="terp_default_Centre_8">[[ data['form']['period_length'] ]]</para>
150 <para style="terp_default_Centre_8">[[ get_partners(data) ]]</para>
153 <para style="terp_default_Centre_8">[[ data['form']['direction_selection'] ]]</para>
156 <para style="terp_default_Centre_8">[[ get_target_move(data) ]]</para>
161 <font color="white"> </font>
163 <blockTable colWidths="135.0,90.0,90.0,90.0,90.0,90.0,90.0,90.0" style="Table2" repeatRows="1">
166 <para style="terp_tblheader_Details">Partners</para>
169 <para style="terp_tblheader_Details_Right">[[ data['form']['direction_selection'] == 'future' and 'Due' or 'Not due' ]]</para>
172 <para style="terp_tblheader_Details_Right">[[ data['form']['4']['name'] ]]</para>
175 <para style="terp_tblheader_Details_Right">[[ data['form']['3']['name'] ]]</para>
178 <para style="terp_tblheader_Details_Right">[[ data['form']['2']['name'] ]]</para>
181 <para style="terp_tblheader_Details_Right">[[ data['form']['1']['name'] ]]</para>
184 <para style="terp_tblheader_Details_Right">[[ data['form']['0']['name'] ]]</para>
187 <para style="terp_tblheader_Details_Right">Total</para>
194 <para style="P3"> <font color="white">[[ (get_lines(data['form']), 'partner') == False or removeParentNode('para') ]]</font></para>
195 <para style="P3"> <font color="white">[[ (get_lines_with_out_partner(data['form']), 'not_partner') == False or removeParentNode('para') ]]</font></para>
196 <para style="Total">Account Total</para>
199 <para style="Total_right">[[ formatLang(get_direction('6'), currency_obj=company.currency_id) ]]</para>
202 <para style="Total_right">[[ formatLang(get_for_period('4'), currency_obj=company.currency_id) ]]</para>
205 <para style="Total_right">[[ formatLang(get_for_period('3'), currency_obj=company.currency_id) ]]</para>
208 <para style="Total_right">[[ formatLang(get_for_period('2'), currency_obj=company.currency_id) ]]</para>
211 <para style="Total_right">[[ formatLang(get_for_period('1'), currency_obj=company.currency_id) ]]</para>
214 <para style="Total_right">[[ formatLang(get_for_period('0'), currency_obj=company.currency_id) ]]</para>
217 <para style="Total_right">[[ formatLang(get_total('5'), currency_obj=company.currency_id) ]]</para>
223 <para style="P3">[[ repeatIn(get_lines(data['form']), 'partner') ]]</para>
224 <para style="P2_content">[[ partner['name'] ]]</para>
227 <para style="content">[[ formatLang(partner['direction'], currency_obj=company.currency_id) ]]</para>
230 <para style="content">[[ formatLang(partner['4'], currency_obj=company.currency_id) ]]</para>
233 <para style="content">[[ formatLang(partner['3'], currency_obj=company.currency_id) ]]</para>
236 <para style="content">[[ formatLang(partner['2'], currency_obj=company.currency_id) ]]</para>
239 <para style="content">[[ formatLang(partner['1'], currency_obj=company.currency_id) ]]</para>
242 <para style="content">[[ formatLang(partner['0'], currency_obj=company.currency_id) ]]</para>
245 <para style="content">[[ formatLang(partner['total'], currency_obj=company.currency_id) ]]</para>
250 <para style="P3">[[ repeatIn(get_lines_with_out_partner(data['form']), 'not_partner') ]]</para>
251 <para style="P2_content">[[ not_partner['name'] ]]</para>
254 <para style="content">[[ formatLang(not_partner['direction'], currency_obj=company.currency_id) ]]</para>
257 <para style="content">[[ formatLang(not_partner['4'], currency_obj=company.currency_id) ]]</para>
260 <para style="content">[[ formatLang(not_partner['3'], currency_obj=company.currency_id) ]]</para>
263 <para style="content">[[ formatLang(not_partner['2'], currency_obj=company.currency_id) ]]</para>
266 <para style="content">[[ formatLang(not_partner['1'], currency_obj=company.currency_id) ]]</para>
269 <para style="content">[[ formatLang(not_partner['0'], currency_obj=company.currency_id) ]]</para>
272 <para style="content">[[ formatLang(not_partner['total'], currency_obj=company.currency_id) ]]</para>
278 <font color="white"> </font>