2 <document filename="Aged Trial Balance.pdf">
3 <template pageSize="(1120.0,770.0)" title="Aged Trial Balance" author="OpenERP S.A.(sales@openerp.com)" allowSplitting="20">
4 <pageTemplate id="first">
5 <frame id="first" x1="20.0" y1="35.0" width="1080" height="650"/>
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 <font color="white"> </font>
106 <blockTable colWidths="180.0,180.0,180.0" style="Table_header_Content">
108 <td><para style="terp_header"><font color="white"> </font></para>
110 <td><para style="terp_header_Centre">Aged Trial Balance</para></td>
111 <td><para style="terp_header"><font color="white"> </font></para></td>
114 <blockTable colWidths="200.0,200.0,100.0,100.0,119.0,100.0,200.0" style="Table8">
117 <para style="terp_tblheader_General_Centre">Chart of Account</para>
120 <para style="terp_tblheader_General_Centre">Fiscal Year</para>
123 <para style="terp_tblheader_General_Centre">Start Date</para>
126 <para style="terp_tblheader_General_Centre">Period Length(days)</para>
129 <para style="terp_tblheader_General_Centre">Partner's</para>
132 <para style="terp_tblheader_General_Centre">Analysis Direction</para>
135 <para style="terp_tblheader_General_Centre">Target Moves</para>
140 <para style="terp_default_Centre_8">[[ get_account(data) or '' ]]</para>
143 <para style="terp_default_Centre_8">[[ get_fiscalyear(data) or '' ]]</para>
146 <para style="terp_default_Centre_8">[[ formatLang(data['form']['date_from'],date=True) ]]</para>
149 <para style="terp_default_Centre_8">[[ data['form']['period_length'] ]]</para>
152 <para style="terp_default_Centre_8">[[ get_partners(data) ]]</para>
155 <para style="terp_default_Centre_8">[[ data['form']['direction_selection'] ]]</para>
158 <para style="terp_default_Centre_8">[[ get_target_move(data) ]]</para>
163 <font color="white"> </font>
165 <blockTable colWidths="300.0,100.0,100.0,100.0,100.0,105.0,105.0,125.0" style="Table2" repeatRows="1">
168 <para style="terp_tblheader_Details">Partners</para>
171 <para style="terp_tblheader_Details_Right">[[ data['form']['direction_selection'] == 'future' and 'Due' or 'Not due' ]]</para>
174 <para style="terp_tblheader_Details_Right">[[ data['form']['4']['name'] ]]</para>
177 <para style="terp_tblheader_Details_Right">[[ data['form']['3']['name'] ]]</para>
180 <para style="terp_tblheader_Details_Right">[[ data['form']['2']['name'] ]]</para>
183 <para style="terp_tblheader_Details_Right">[[ data['form']['1']['name'] ]]</para>
186 <para style="terp_tblheader_Details_Right">[[ data['form']['0']['name'] ]]</para>
189 <para style="terp_tblheader_Details_Right">Total</para>
196 <para style="P3"> <font color="white">[[ (get_lines(data['form']), 'partner') == False or removeParentNode('para') ]]</font></para>
197 <para style="P3"> <font color="white">[[ (get_lines_with_out_partner(data['form']), 'not_partner') == False or removeParentNode('para') ]]</font></para>
198 <para style="Total">Account Total</para>
201 <para style="Total_right">[[ formatLang(get_direction('6')) ]] [[ company.currency_id.symbol ]]</para>
204 <para style="Total_right">[[ formatLang(get_for_period('4')) ]] [[ company.currency_id.symbol ]]</para>
207 <para style="Total_right">[[ formatLang(get_for_period('3')) ]] [[ company.currency_id.symbol ]]</para>
210 <para style="Total_right">[[ formatLang(get_for_period('2')) ]] [[ company.currency_id.symbol ]]</para>
213 <para style="Total_right">[[ formatLang(get_for_period('1')) ]] [[ company.currency_id.symbol ]]</para>
216 <para style="Total_right">[[ formatLang(get_for_period('0')) ]] [[ company.currency_id.symbol ]]</para>
219 <para style="Total_right">[[ formatLang(get_total('5')) ]] [[ company.currency_id.symbol ]]</para>
225 <para style="P3">[[ repeatIn(get_lines(data['form']), 'partner') ]]</para>
226 <para style="P2_content">[[ partner['name'] ]]</para>
229 <para style="content">[[ formatLang(partner['direction']) ]] [[ company.currency_id.symbol ]]</para>
232 <para style="content">[[ formatLang(partner['4'])]] [[ company.currency_id.symbol ]]</para>
235 <para style="content">[[ formatLang(partner['3'])]] [[ company.currency_id.symbol ]]</para>
238 <para style="content">[[ formatLang(partner['2']) ]] [[ company.currency_id.symbol ]]</para>
241 <para style="content">[[ formatLang(partner['1']) ]] [[ company.currency_id.symbol ]]</para>
244 <para style="content">[[ formatLang(partner['0']) ]] [[ company.currency_id.symbol ]]</para>
247 <para style="content">[[ formatLang(partner['total']) ]] [[ company.currency_id.symbol ]]</para>
252 <para style="P3">[[ repeatIn(get_lines_with_out_partner(data['form']), 'not_partner') ]]</para>
253 <para style="P2_content">[[ not_partner['name'] ]]</para>
256 <para style="content">[[ formatLang(not_partner['direction']) ]] [[ company.currency_id.symbol ]]</para>
259 <para style="content">[[ formatLang(not_partner['4'])]] [[ company.currency_id.symbol ]]</para>
262 <para style="content">[[ formatLang(not_partner['3'])]] [[ company.currency_id.symbol ]]</para>
265 <para style="content">[[ formatLang(not_partner['2']) ]] [[ company.currency_id.symbol ]]</para>
268 <para style="content">[[ formatLang(not_partner['1']) ]] [[ company.currency_id.symbol ]]</para>
271 <para style="content">[[ formatLang(not_partner['0']) ]] [[ company.currency_id.symbol ]]</para>
274 <para style="content">[[ formatLang(not_partner['total']) ]] [[ company.currency_id.symbol ]]</para>
280 <font color="white"> </font>