2 <document filename="Profit and Loss.pdf">
3 <template pageSize="(842.0,595.0)" title="Profit And Loss" 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="Table_Heading">
14 <blockAlignment value="LEFT"/>
15 <blockValign value="TOP"/>
17 <blockTableStyle id="Table_Company_Name">
18 <blockAlignment value="LEFT"/>
19 <blockValign value="TOP"/>
21 <blockTableStyle id="Table_Date_from_To">
22 <blockAlignment value="LEFT"/>
23 <blockValign value="TOP"/>
25 <blockTableStyle id="Table_debit_credit">
26 <blockAlignment value="LEFT"/>
27 <blockValign value="TOP"/>
29 <blockTableStyle id="Table_Account_Line_Title">
30 <blockAlignment value="LEFT"/>
31 <blockValign value="TOP"/>
32 <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
33 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,1" stop="-1,-1"/>
35 <blockTableStyle id="Table_Main_Content">
36 <blockAlignment value="LEFT"/>
37 <blockValign value="TOP"/>
39 <blockTableStyle id="Table_Expense_Content">
40 <blockAlignment value="LEFT"/>
41 <blockValign value="TOP"/>
43 <blockTableStyle id="Table_Income_Content">
44 <blockAlignment value="LEFT"/>
45 <blockValign value="TOP"/>
47 <blockTableStyle id="Table3">
48 <blockAlignment value="LEFT"/>
49 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
51 <blockTableStyle id="Table_Net_Profit_Loss">
52 <blockAlignment value="LEFT"/>
53 <blockValign value="TOP"/>
54 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
56 <blockTableStyle id="Table_Final_Result">
57 <blockAlignment value="LEFT"/>
58 <blockValign value="TOP"/>
59 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
60 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
61 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
62 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
63 <lineStyle kind="LINEAFTER" colorName="#cccccc" start="1,0" stop="1,-1"/>
64 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
65 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
67 <blockTableStyle id="Table2_header">
68 <blockAlignment value="LEFT"/>
69 <blockValign value="TOP"/>
70 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,0"/>
71 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
72 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
73 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
74 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
75 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
76 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
77 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
78 <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
79 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
80 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
81 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
82 <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
83 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
84 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
85 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="4,0" stop="4,-1"/>
86 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="4,0" stop="4,0"/>
87 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
88 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="5,0" stop="5,-1"/>
89 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="5,0" stop="5,0"/>
90 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
91 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="6,0" stop="6,-1"/>
92 <lineStyle kind="LINEAFTER" colorName="#cccccc" start="6,0" stop="6,-1"/>
93 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="6,0" stop="6,0"/>
94 <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
95 <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="7,0" stop="7,-1"/>
96 <lineStyle kind="LINEAFTER" colorName="#cccccc" start="7,0" stop="7,-1"/>
97 <lineStyle kind="LINEABOVE" colorName="#cccccc" start="7,0" stop="7,0"/>
101 <paraStyle name="all" alignment="justify"/>
103 <paraStyle name="P1" rightIndent="2.0" leftIndent="0.0" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
104 <paraStyle name="P2" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
105 <paraStyle name="Standard" fontName="Times-Roman"/>
106 <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
107 <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
108 <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
109 <paraStyle name="Caption" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" spaceBefore="6.0" spaceAfter="6.0"/>
110 <paraStyle name="Index" fontName="Helvetica" fontSize="9.0" leading="11"/>
111 <paraStyle name="Footer" fontName="Times-Roman"/>
112 <paraStyle name="Table Contents" fontName="Times-Roman"/>
113 <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
114 <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
115 <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
116 <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
117 <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
118 <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
119 <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
120 <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
121 <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
122 <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
123 <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
124 <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
125 <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
126 <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
127 <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
128 <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
129 <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
130 <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
131 <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
132 <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
133 <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
134 <paraStyle name="terp_default_Right_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
135 <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
139 <blockTable colWidths="539.0" style="Table_Company_Name">
142 <para style="terp_header_Centre">Profit And Loss</para>
146 <para style="Standard">
147 <font color="white"> </font>
149 <para style="P2">[[ get_data(data) or removeParentNode('para')]]</para>
150 <blockTable colWidths="250.0,100.0,150.0,120.0,150.0" style="Table2_header">
152 <td><para style="terp_tblheader_General_Centre">Chart of Accounts</para></td>
153 <td><para style="terp_tblheader_General_Centre">Fiscal Year</para></td>
154 <td><para style="terp_tblheader_General_Centre">Filter By [[ data['form']['filter']!='filter_no' and get_filter(data) ]]</para></td>
155 <td><para style="terp_tblheader_General_Centre">Display Account</para></td>
156 <td><para style="terp_tblheader_General_Centre">Target Moves</para></td>
159 <td><para style="terp_default_Centre_8">[[ get_account(data) or removeParentNode('para') ]]</para></td>
160 <td><para style="terp_default_Centre_8">[[ get_fiscalyear(data) or '' ]]</para></td>
161 <td><para style="terp_default_Centre_8">[[ data['form']['filter']=='filter_no' and get_filter(data) or removeParentNode('para') ]] </para>
162 <blockTable colWidths="70.0,70.0" style="Table3">[[ data['form']['filter']=='filter_date' or removeParentNode('blockTable') ]]
164 <td><para style="terp_tblheader_General_Centre">Start Date</para></td>
165 <td><para style="terp_tblheader_General_Centre">End Date</para></td>
168 <td><para style="terp_default_Centre_8">[[ formatLang(get_start_date(data),date=True) ]]</para></td>
169 <td><para style="terp_default_Centre_8">[[ formatLang(get_end_date(data),date=True) ]]</para></td>
172 <blockTable colWidths="70.0,70.0" style="Table3">[[ data['form']['filter']=='filter_period' or removeParentNode('blockTable') ]]
174 <td><para style="terp_tblheader_General_Centre">Start Period</para></td>
175 <td><para style="terp_tblheader_General_Centre">End Period</para></td>
178 <td><para style="terp_default_Centre_8">[[ get_start_period(data) or removeParentNode('para') ]]</para></td>
179 <td><para style="terp_default_Centre_8">[[ get_end_period(data) or removeParentNode('para') ]]</para></td>
183 <td><para style="terp_default_Centre_8">[[ (data['form']['display_account']=='all' and 'All') or (data['form']['display_account']=='movement' and 'With movements') or 'With balance is not equal to 0']]</para></td>
184 <td><para style="terp_default_Centre_8">[[ get_target_move(data) ]]</para></td>
187 <para style="Standard">
188 <font color="white"> </font>
190 <blockTable colWidths="80.0,210.16,100.32,80.0,210.16,100.32" style="Table_Account_Line_Title" repeatRows="1">
193 <para style="terp_default_Bold_9">Code</para>
196 <para style="terp_default_Bold_9">Expenses</para>
199 <para style="terp_tblheader_Details_Right">Balance</para>
202 <para style="terp_default_Bold_9">Code</para>
205 <para style="terp_default_Bold_9">Income</para>
208 <para style="P1">Balance</para>
213 <para style="terp_default_9">
215 <font>[[ repeatIn(get_lines(),'a' ) ]] </font>[[ a['code'] ]]<font>[[ a['level']<4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font') ]]</font>
219 <para style="terp_default_9">
220 <font color="white">[[ '. '*(a['level']-1) ]]</font><font>[[ a['level']<4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font') ]][[ a['name'] ]]</font>
224 <para style="terp_default_Right_9"><font>[[ a['level']<4 and ( setTag('para','para',{'style':'terp_default_Right_9_Bold'})) or removeParentNode('font') ]]</font><font>[[ formatLang(abs(a['balance']), currency_obj=company.currency_id) ]]</font></para>
227 <para style="terp_default_9">
228 [[ a['code1'] ]]<font>[[ a['level1']<4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font') ]]</font>
232 <para style="terp_default_9">
233 <font color="white">[[ '. '*(a['level1']-1) ]]</font><font>[[ a['level1']<4 and ( setTag('para','para',{'style':'terp_default_Bold_9'})) or removeParentNode('font') ]][[ a['name1'] ]]</font>
237 <para style="terp_default_Right_9"><font>[[ a['level']<4 and ( setTag('para','para',{'style':'terp_default_Right_9_Bold'})) or removeParentNode('font') ]]</font><font>[[(a['code1'] and a['name1']) and formatLang(abs(a['balance1']), currency_obj=company.currency_id) or removeParentNode('font') ]]</font></para>
241 <blockTable colWidths="80.0,210.16,100.32,80.0,210.16,100.32" style="Table_Net_Profit_Loss">
244 <para style="terp_default_Bold_9"></para>
247 <para style="terp_default_Bold_9">[[ final_result()['type'] == 'Net Profit' and final_result()['type'] or '' ]]</para>
250 <para style="terp_default_Right_9_Bold">[[ final_result()['balance'] and final_result()['type'] == 'Net Profit' and formatLang(abs(final_result()['balance']), currency_obj=company.currency_id) ]]</para>
253 <para style="terp_default_Bold_9"></para>
256 <para style="terp_default_Bold_9">[[ final_result()['type'] == 'Net Loss' and final_result()['type'] or '' ]]</para>
259 <para style="terp_default_Right_9_Bold">[[ final_result()['balance'] and final_result()['type'] == 'Net Loss' and formatLang(abs(final_result()['balance']), currency_obj=company.currency_id) ]]</para>
264 <blockTable colWidths="290.16,100.32,290.16,100.32" style="Table_Net_Profit_Loss">
267 <para style="terp_default_Bold_9">Total:</para>
270 <para style="terp_default_Right_9_Bold"><u>[[ formatLang(abs(sum_dr()), currency_obj=company.currency_id) ]]</u></para>
273 <para style="terp_default_Bold_9">Total:</para>
276 <para style="terp_default_Right_9_Bold"><u>[[ formatLang(abs(sum_cr()), currency_obj=company.currency_id) ]]</u></para>