Merge lp:~vauxoo/account-financial-report/7.0-afr-multicurrency-dev-1985-kty into lp:~vauxoo/account-financial-report/vxafr

Proposed by Katherine Zaoral (Vauxoo)
Status: Merged
Merged at revision: 93
Proposed branch: lp:~vauxoo/account-financial-report/7.0-afr-multicurrency-dev-1985-kty
Merge into: lp:~vauxoo/account-financial-report/vxafr
Diff against target: 67663 lines (+66464/-0) (has conflicts)
226 files modified
account_export_csv/__init__.py (+21/-0)
account_export_csv/__openerp__.py (+47/-0)
account_export_csv/i18n/account_export_csv.po (+111/-0)
account_export_csv/i18n/fr.po (+74/-0)
account_export_csv/i18n/nl.po (+74/-0)
account_export_csv/menu.xml (+16/-0)
account_export_csv/wizard/__init__.py (+21/-0)
account_export_csv/wizard/account_export_csv.py (+376/-0)
account_export_csv/wizard/account_export_csv_view.xml (+47/-0)
account_financial_report/__init__.py (+30/-0)
account_financial_report/__openerp__.py (+65/-0)
account_financial_report/i18n/es.po (+695/-0)
account_financial_report/i18n/es_MX.po (+687/-0)
account_financial_report/i18n/es_VE.po (+687/-0)
account_financial_report/model/__init__.py (+27/-0)
account_financial_report/model/account_financial_report.py (+186/-0)
account_financial_report/model/res_company.py (+43/-0)
account_financial_report/report/__init__.py (+28/-0)
account_financial_report/report/balance_full.rml (+131/-0)
account_financial_report/report/balance_full_13_cols.rml (+235/-0)
account_financial_report/report/balance_full_2_cols.rml (+131/-0)
account_financial_report/report/balance_full_4_cols.rml (+149/-0)
account_financial_report/report/balance_full_4_cols_analytic_ledger.rml (+294/-0)
account_financial_report/report/balance_full_4_cols_journal_ledger.rml (+397/-0)
account_financial_report/report/balance_full_4_cols_partner_balance.rml (+273/-0)
account_financial_report/report/balance_full_5_cols.rml (+158/-0)
account_financial_report/report/balance_full_qtr_cols.rml (+158/-0)
account_financial_report/report/balance_multicurrency.rml (+253/-0)
account_financial_report/report/parser.py (+1610/-0)
account_financial_report/security/ir.model.access.csv (+10/-0)
account_financial_report/security/security.xml (+20/-0)
account_financial_report/view/account_financial_report_view.xml (+116/-0)
account_financial_report/view/company_view.xml (+46/-0)
account_financial_report/view/report.xml (+114/-0)
account_financial_report/view/wizard.xml (+126/-0)
account_financial_report/wizard/__init__.py (+28/-0)
account_financial_report/wizard/wizard.py (+314/-0)
account_financial_report_horizontal/LICENSE (+662/-0)
account_financial_report_horizontal/__init__.py (+2/-0)
account_financial_report_horizontal/__openerp__.py (+47/-0)
account_financial_report_horizontal/account_report.xml (+23/-0)
account_financial_report_horizontal/i18n/account_report_alt.pot (+482/-0)
account_financial_report_horizontal/i18n/ar.po (+493/-0)
account_financial_report_horizontal/i18n/bg.po (+495/-0)
account_financial_report_horizontal/i18n/br.po (+494/-0)
account_financial_report_horizontal/i18n/bs.po (+492/-0)
account_financial_report_horizontal/i18n/ca.po (+503/-0)
account_financial_report_horizontal/i18n/cs.po (+497/-0)
account_financial_report_horizontal/i18n/da.po (+496/-0)
account_financial_report_horizontal/i18n/de.po (+502/-0)
account_financial_report_horizontal/i18n/el.po (+496/-0)
account_financial_report_horizontal/i18n/en_GB.po (+496/-0)
account_financial_report_horizontal/i18n/en_US.po (+494/-0)
account_financial_report_horizontal/i18n/es.po (+502/-0)
account_financial_report_horizontal/i18n/es_AR.po (+494/-0)
account_financial_report_horizontal/i18n/es_CL.po (+494/-0)
account_financial_report_horizontal/i18n/es_EC.po (+504/-0)
account_financial_report_horizontal/i18n/es_PY.po (+504/-0)
account_financial_report_horizontal/i18n/et.po (+492/-0)
account_financial_report_horizontal/i18n/eu.po (+494/-0)
account_financial_report_horizontal/i18n/fa.po (+493/-0)
account_financial_report_horizontal/i18n/fa_AF.po (+494/-0)
account_financial_report_horizontal/i18n/fi.po (+496/-0)
account_financial_report_horizontal/i18n/fr.po (+502/-0)
account_financial_report_horizontal/i18n/fr_BE.po (+494/-0)
account_financial_report_horizontal/i18n/gl.po (+495/-0)
account_financial_report_horizontal/i18n/gu.po (+493/-0)
account_financial_report_horizontal/i18n/he.po (+494/-0)
account_financial_report_horizontal/i18n/hi.po (+494/-0)
account_financial_report_horizontal/i18n/hr.po (+501/-0)
account_financial_report_horizontal/i18n/hu.po (+494/-0)
account_financial_report_horizontal/i18n/id.po (+496/-0)
account_financial_report_horizontal/i18n/it.po (+502/-0)
account_financial_report_horizontal/i18n/kab.po (+493/-0)
account_financial_report_horizontal/i18n/kk.po (+494/-0)
account_financial_report_horizontal/i18n/ko.po (+493/-0)
account_financial_report_horizontal/i18n/lo.po (+493/-0)
account_financial_report_horizontal/i18n/lt.po (+494/-0)
account_financial_report_horizontal/i18n/lv.po (+496/-0)
account_financial_report_horizontal/i18n/mk.po (+494/-0)
account_financial_report_horizontal/i18n/mn.po (+497/-0)
account_financial_report_horizontal/i18n/nb.po (+496/-0)
account_financial_report_horizontal/i18n/nl.po (+500/-0)
account_financial_report_horizontal/i18n/nl_BE.po (+494/-0)
account_financial_report_horizontal/i18n/oc.po (+493/-0)
account_financial_report_horizontal/i18n/pl.po (+494/-0)
account_financial_report_horizontal/i18n/pt.po (+502/-0)
account_financial_report_horizontal/i18n/pt_BR.po (+502/-0)
account_financial_report_horizontal/i18n/ro.po (+494/-0)
account_financial_report_horizontal/i18n/ru.po (+501/-0)
account_financial_report_horizontal/i18n/si.po (+493/-0)
account_financial_report_horizontal/i18n/sk.po (+493/-0)
account_financial_report_horizontal/i18n/sl.po (+493/-0)
account_financial_report_horizontal/i18n/sq.po (+494/-0)
account_financial_report_horizontal/i18n/sr.po (+494/-0)
account_financial_report_horizontal/i18n/sr@latin.po (+493/-0)
account_financial_report_horizontal/i18n/sv.po (+494/-0)
account_financial_report_horizontal/i18n/ta.po (+493/-0)
account_financial_report_horizontal/i18n/te.po (+493/-0)
account_financial_report_horizontal/i18n/th.po (+493/-0)
account_financial_report_horizontal/i18n/tlh.po (+493/-0)
account_financial_report_horizontal/i18n/tr.po (+501/-0)
account_financial_report_horizontal/i18n/ug.po (+494/-0)
account_financial_report_horizontal/i18n/uk.po (+492/-0)
account_financial_report_horizontal/i18n/ur.po (+494/-0)
account_financial_report_horizontal/i18n/vi.po (+502/-0)
account_financial_report_horizontal/i18n/zh_CN.po (+492/-0)
account_financial_report_horizontal/i18n/zh_HK.po (+493/-0)
account_financial_report_horizontal/i18n/zh_TW.po (+492/-0)
account_financial_report_horizontal/menu.xml (+9/-0)
account_financial_report_horizontal/report/__init__.py (+3/-0)
account_financial_report_horizontal/report/account_balance_sheet.py (+282/-0)
account_financial_report_horizontal/report/account_balance_sheet_horizontal.rml (+243/-0)
account_financial_report_horizontal/report/account_profit_horizontal.rml (+291/-0)
account_financial_report_horizontal/report/account_profit_loss.py (+251/-0)
account_financial_report_horizontal/report/common_report_header.py (+86/-0)
account_financial_report_horizontal/wizard/__init__.py (+4/-0)
account_financial_report_horizontal/wizard/account_report_balance_sheet.py (+60/-0)
account_financial_report_horizontal/wizard/account_report_balance_sheet_view.xml (+46/-0)
account_financial_report_horizontal/wizard/account_report_common.py (+196/-0)
account_financial_report_horizontal/wizard/account_report_common_account.py (+49/-0)
account_financial_report_horizontal/wizard/account_report_common_view.xml (+46/-0)
account_financial_report_horizontal/wizard/account_report_profit_loss.py (+60/-0)
account_financial_report_horizontal/wizard/account_report_profit_loss_view.xml (+41/-0)
account_financial_report_webkit/__init__.py (+23/-0)
account_financial_report_webkit/__openerp__.py (+206/-0)
account_financial_report_webkit/account.py (+47/-0)
account_financial_report_webkit/account_move_line.py (+85/-0)
account_financial_report_webkit/account_view.xml (+17/-0)
account_financial_report_webkit/data/financial_webkit_header.xml (+409/-0)
account_financial_report_webkit/i18n/account_financial_report_webkit.pot (+1284/-0)
account_financial_report_webkit/i18n/de.po (+1322/-0)
account_financial_report_webkit/i18n/en_US.po (+1322/-0)
account_financial_report_webkit/i18n/es.po (+1369/-0)
account_financial_report_webkit/i18n/fr.po (+1349/-0)
account_financial_report_webkit/i18n/it.po (+1368/-0)
account_financial_report_webkit/i18n/nl.po (+1322/-0)
account_financial_report_webkit/report/__init__.py (+12/-0)
account_financial_report_webkit/report/aged_partner_balance.py (+403/-0)
account_financial_report_webkit/report/common_balance_reports.py (+280/-0)
account_financial_report_webkit/report/common_partner_balance_reports.py (+276/-0)
account_financial_report_webkit/report/common_partner_reports.py (+333/-0)
account_financial_report_webkit/report/common_reports.py (+532/-0)
account_financial_report_webkit/report/general_ledger.py (+214/-0)
account_financial_report_webkit/report/open_invoices.py (+237/-0)
account_financial_report_webkit/report/partner_balance.py (+90/-0)
account_financial_report_webkit/report/partners_ledger.py (+199/-0)
account_financial_report_webkit/report/print_journal.py (+147/-0)
account_financial_report_webkit/report/report.xml (+158/-0)
account_financial_report_webkit/report/templates/account_report_general_ledger.mako (+243/-0)
account_financial_report_webkit/report/templates/account_report_open_invoices.mako (+85/-0)
account_financial_report_webkit/report/templates/account_report_partner_balance.mako (+291/-0)
account_financial_report_webkit/report/templates/account_report_partners_ledger.mako (+290/-0)
account_financial_report_webkit/report/templates/account_report_print_journal.mako (+170/-0)
account_financial_report_webkit/report/templates/account_report_profit_loss.mako (+211/-0)
account_financial_report_webkit/report/templates/account_report_trial_balance.mako (+218/-0)
account_financial_report_webkit/report/templates/aged_trial_webkit.mako (+155/-0)
account_financial_report_webkit/report/templates/grouped_by_curr_open_invoices_inclusion.mako.html (+173/-0)
account_financial_report_webkit/report/templates/open_invoices_inclusion.mako.html (+183/-0)
account_financial_report_webkit/report/trial_balance.py (+84/-0)
account_financial_report_webkit/report/webkit_parser_header_fix.py (+254/-0)
account_financial_report_webkit/report_menus.xml (+42/-0)
account_financial_report_webkit/tests/account_move_line.yml (+3/-0)
account_financial_report_webkit/tests/aged_trial_balance.yml (+60/-0)
account_financial_report_webkit/tests/general_ledger.yml (+65/-0)
account_financial_report_webkit/tests/open_invoices.yml (+60/-0)
account_financial_report_webkit/tests/partner_balance.yml (+67/-0)
account_financial_report_webkit/tests/partner_ledger.yml (+60/-0)
account_financial_report_webkit/tests/trial_balance.yml (+67/-0)
account_financial_report_webkit/wizard/__init__.py (+30/-0)
account_financial_report_webkit/wizard/aged_partner_balance_wizard.py (+39/-0)
account_financial_report_webkit/wizard/aged_partner_balance_wizard.xml (+72/-0)
account_financial_report_webkit/wizard/balance_common.py (+347/-0)
account_financial_report_webkit/wizard/balance_common_view.xml (+11/-0)
account_financial_report_webkit/wizard/general_ledger_wizard.py (+136/-0)
account_financial_report_webkit/wizard/general_ledger_wizard_view.xml (+89/-0)
account_financial_report_webkit/wizard/open_invoices_wizard.py (+121/-0)
account_financial_report_webkit/wizard/open_invoices_wizard_view.xml (+75/-0)
account_financial_report_webkit/wizard/partner_balance_wizard.py (+59/-0)
account_financial_report_webkit/wizard/partner_balance_wizard_view.xml (+85/-0)
account_financial_report_webkit/wizard/partners_ledger_wizard.py (+120/-0)
account_financial_report_webkit/wizard/partners_ledger_wizard_view.xml (+71/-0)
account_financial_report_webkit/wizard/print_journal.py (+118/-0)
account_financial_report_webkit/wizard/print_journal_view.xml (+90/-0)
account_financial_report_webkit/wizard/trial_balance_wizard.py (+41/-0)
account_financial_report_webkit/wizard/trial_balance_wizard_view.xml (+77/-0)
account_financial_report_webkit/wizard/wizard.xml (+4/-0)
account_financial_report_webkit_xls/__init__.py (+29/-0)
account_financial_report_webkit_xls/__openerp__.py (+50/-0)
account_financial_report_webkit_xls/report/__init__.py (+29/-0)
account_financial_report_webkit_xls/report/general_ledger_xls.py (+286/-0)
account_financial_report_webkit_xls/report/open_invoices_xls.py (+627/-0)
account_financial_report_webkit_xls/report/partner_ledger_xls.py (+365/-0)
account_financial_report_webkit_xls/report/partners_balance_xls.py (+328/-0)
account_financial_report_webkit_xls/report/trial_balance_xls.py (+258/-0)
account_financial_report_webkit_xls/wizard/__init__.py (+27/-0)
account_financial_report_webkit_xls/wizard/general_ledger_wizard.py (+43/-0)
account_financial_report_webkit_xls/wizard/general_ledger_wizard_view.xml (+26/-0)
account_financial_report_webkit_xls/wizard/open_invoices_wizard.py (+42/-0)
account_financial_report_webkit_xls/wizard/open_invoices_wizard_view.xml (+26/-0)
account_financial_report_webkit_xls/wizard/partners_balance_wizard.py (+43/-0)
account_financial_report_webkit_xls/wizard/partners_balance_wizard_view.xml (+26/-0)
account_financial_report_webkit_xls/wizard/partners_ledger_wizard.py (+42/-0)
account_financial_report_webkit_xls/wizard/partners_ledger_wizard_view.xml (+26/-0)
account_financial_report_webkit_xls/wizard/trial_balance_wizard.py (+43/-0)
account_financial_report_webkit_xls/wizard/trial_balance_wizard_view.xml (+26/-0)
account_journal_report_xls/__init__.py (+31/-0)
account_journal_report_xls/__openerp__.py (+56/-0)
account_journal_report_xls/account_journal.py (+89/-0)
account_journal_report_xls/i18n/fr.po (+311/-0)
account_journal_report_xls/i18n/nl.po (+311/-0)
account_journal_report_xls/report/__init__.py (+26/-0)
account_journal_report_xls/report/nov_account_journal.py (+297/-0)
account_journal_report_xls/report/nov_account_journal.rml (+286/-0)
account_journal_report_xls/report/nov_account_journal_xls.py (+337/-0)
account_journal_report_xls/wizard/__init__.py (+25/-0)
account_journal_report_xls/wizard/print_journal_wizard.py (+172/-0)
account_journal_report_xls/wizard/print_journal_wizard.xml (+80/-0)
account_move_line_report_xls/__init__.py (+29/-0)
account_move_line_report_xls/__openerp__.py (+74/-0)
account_move_line_report_xls/account_move_line.py (+57/-0)
account_move_line_report_xls/i18n/fr.po (+176/-0)
account_move_line_report_xls/i18n/nl.po (+176/-0)
account_move_line_report_xls/report/__init__.py (+23/-0)
account_move_line_report_xls/report/move_line_list_xls.py (+287/-0)
account_move_line_report_xls/report/move_line_list_xls.xml (+22/-0)
Conflict adding file account_export_csv.  Moved existing file to account_export_csv.moved.
Conflict adding file account_financial_report.  Moved existing file to account_financial_report.moved.
Conflict adding file account_financial_report_horizontal.  Moved existing file to account_financial_report_horizontal.moved.
Conflict adding file account_financial_report_webkit.  Moved existing file to account_financial_report_webkit.moved.
Conflict adding file account_financial_report_webkit_xls.  Moved existing file to account_financial_report_webkit_xls.moved.
Conflict adding file account_journal_report_xls.  Moved existing file to account_journal_report_xls.moved.
Conflict adding file account_move_line_report_xls.  Moved existing file to account_move_line_report_xls.moved.
To merge this branch: bzr merge lp:~vauxoo/account-financial-report/7.0-afr-multicurrency-dev-1985-kty
Reviewer Review Type Date Requested Status
Katherine Zaoral (Vauxoo) Approve
Review via email: mp+231019@code.launchpad.net

Description of the change

[MERGE] Add a End Balance Multicurrency Report for the Account Financial Report.

To post a comment you must log in.
Revision history for this message
Katherine Zaoral (Vauxoo) (kathy-zaoral) wrote :

LGTM

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added directory 'account_export_csv'
2=== renamed directory 'account_export_csv' => 'account_export_csv.moved'
3=== added file 'account_export_csv/__init__.py'
4--- account_export_csv/__init__.py 1970-01-01 00:00:00 +0000
5+++ account_export_csv/__init__.py 2014-08-15 20:07:23 +0000
6@@ -0,0 +1,21 @@
7+# -*- coding: utf-8 -*-
8+##############################################################################
9+#
10+# Author Joel Grand-Guillaume and Vincent Renaville Copyright 2013 Camptocamp SA
11+#
12+# This program is free software: you can redistribute it and/or modify
13+# it under the terms of the GNU Affero General Public License as
14+# published by the Free Software Foundation, either version 3 of the
15+# License, or (at your option) any later version.
16+#
17+# This program is distributed in the hope that it will be useful,
18+# but WITHOUT ANY WARRANTY; without even the implied warranty of
19+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20+# GNU Affero General Public License for more details.
21+#
22+# You should have received a copy of the GNU Affero General Public License
23+# along with this program. If not, see <http://www.gnu.org/licenses/>.
24+#
25+##############################################################################
26+
27+import wizard
28\ No newline at end of file
29
30=== added file 'account_export_csv/__openerp__.py'
31--- account_export_csv/__openerp__.py 1970-01-01 00:00:00 +0000
32+++ account_export_csv/__openerp__.py 2014-08-15 20:07:23 +0000
33@@ -0,0 +1,47 @@
34+# -*- coding: utf-8 -*-
35+##############################################################################
36+#
37+# Author Joel Grand-Guillaume and Vincent Renaville Copyright 2013 Camptocamp SA
38+#
39+# This program is free software: you can redistribute it and/or modify
40+# it under the terms of the GNU Affero General Public License as
41+# published by the Free Software Foundation, either version 3 of the
42+# License, or (at your option) any later version.
43+#
44+# This program is distributed in the hope that it will be useful,
45+# but WITHOUT ANY WARRANTY; without even the implied warranty of
46+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
47+# GNU Affero General Public License for more details.
48+#
49+# You should have received a copy of the GNU Affero General Public License
50+# along with this program. If not, see <http://www.gnu.org/licenses/>.
51+#
52+##############################################################################
53+
54+{
55+ 'name' : 'Account Export CSV',
56+ 'version' : '1.1',
57+ 'depends' : [
58+ 'account',
59+ ],
60+ 'author' : 'Camptocamp',
61+ 'description': """
62+
63+ Add a wizard that allow you to export a csv file based on accounting journal entries
64+
65+ - Trial Balance
66+ - Analytic Balance (with accounts)
67+ - Journal Entries
68+
69+ You can filter by period
70+
71+ TODO: rearange wizard view with only one button to generate file plus define a selection list to select report type
72+ """,
73+ 'website': 'http://www.camptocamp.com',
74+ 'data': [
75+ 'wizard/account_export_csv_view.xml',
76+ 'menu.xml',
77+ ],
78+ 'installable': True,
79+ 'active': False,
80+}
81
82=== added directory 'account_export_csv/i18n'
83=== added file 'account_export_csv/i18n/account_export_csv.po'
84--- account_export_csv/i18n/account_export_csv.po 1970-01-01 00:00:00 +0000
85+++ account_export_csv/i18n/account_export_csv.po 2014-08-15 20:07:23 +0000
86@@ -0,0 +1,111 @@
87+# Translation of OpenERP Server.
88+# This file contains the translation of the following modules:
89+# * account_export_csv
90+#
91+msgid ""
92+msgstr ""
93+"Project-Id-Version: OpenERP Server 7.0\n"
94+"Report-Msgid-Bugs-To: \n"
95+"POT-Creation-Date: 2013-04-10 15:11+0000\n"
96+"PO-Revision-Date: 2013-04-10 15:11+0000\n"
97+"Last-Translator: <>\n"
98+"Language-Team: \n"
99+"MIME-Version: 1.0\n"
100+"Content-Type: text/plain; charset=UTF-8\n"
101+"Content-Transfer-Encoding: \n"
102+"Plural-Forms: \n"
103+
104+#. module: account_export_csv
105+#: model:ir.model,name:account_export_csv.model_account_csv_export
106+msgid "Export Accounting"
107+msgstr ""
108+
109+#. module: account_export_csv
110+#: field:account.csv.export,export_filename:0
111+msgid "Export CSV Filename"
112+msgstr ""
113+
114+#. module: account_export_csv
115+#: view:account.csv.export:0
116+msgid "Trial Balance"
117+msgstr ""
118+
119+#. module: account_export_csv
120+#: field:account.csv.export,company_id:0
121+msgid "Company"
122+msgstr ""
123+
124+#. module: account_export_csv
125+#: view:account.csv.export:0
126+msgid "Analytic Balance (with accounts)"
127+msgstr ""
128+
129+#. module: account_export_csv
130+#: help:account.csv.export,periods:0
131+msgid "All periods in the fiscal year if empty"
132+msgstr ""
133+
134+#. module: account_export_csv
135+#: field:account.csv.export,periods:0
136+msgid "Periods"
137+msgstr ""
138+
139+#. module: account_export_csv
140+#: view:account.csv.export:0
141+msgid "Close"
142+msgstr ""
143+
144+#. module: account_export_csv
145+#: view:account.csv.export:0
146+#: model:ir.actions.act_window,name:account_export_csv.action_account_csv_export
147+#: model:ir.ui.menu,name:account_export_csv.menu_account_csv_export
148+msgid "Accounting CSV Export"
149+msgstr ""
150+
151+#. module: account_export_csv
152+#: field:account.csv.export,data:0
153+msgid "CSV"
154+msgstr ""
155+
156+#. module: account_export_csv
157+#: field:account.csv.export,fiscalyear_id:0
158+msgid "Fiscalyear"
159+msgstr ""
160+
161+#. module: account_export_csv
162+#: view:account.csv.export:0
163+msgid "Analytic Balance (with accounts)"
164+msgstr ""
165+
166+#. module: account_export_csv
167+#: field:account.csv.export,stop_period_id:0
168+msgid "End period"
169+msgstr ""
170+
171+#. module: account_export_csv
172+#: view:account.csv.export:0
173+msgid "Close"
174+msgstr ""
175+
176+#. module: account_export_csv
177+#: view:account.csv.export:0
178+#: model:ir.actions.act_window,name:account_export_csv.action_account_csv_export
179+#: model:ir.ui.menu,name:account_export_csv.menu_account_csv_export
180+msgid "Accounting CSV Export"
181+msgstr ""
182+
183+#. module: account_export_csv
184+#: field:account.csv.export,data:0
185+msgid "CSV"
186+msgstr ""
187+
188+#. module: account_export_csv
189+#: model:ir.model,name:account_export_csv.model_account_csv_export
190+msgid "Export Accounting Entries"
191+msgstr ""
192+
193+#. module: account_export_csv
194+#: field:account.csv.export,fiscalyear_id:0
195+msgid "Fiscalyear"
196+msgstr ""
197+
198
199=== added file 'account_export_csv/i18n/fr.po'
200--- account_export_csv/i18n/fr.po 1970-01-01 00:00:00 +0000
201+++ account_export_csv/i18n/fr.po 2014-08-15 20:07:23 +0000
202@@ -0,0 +1,74 @@
203+# Translation of OpenERP Server.
204+# This file contains the translation of the following modules:
205+# * account_export_csv
206+#
207+msgid ""
208+msgstr ""
209+"Project-Id-Version: OpenERP Server 7.0\n"
210+"Report-Msgid-Bugs-To: \n"
211+"POT-Creation-Date: 2013-04-10 15:11+0000\n"
212+"PO-Revision-Date: 2013-04-10 15:11+0000\n"
213+"Last-Translator: <>\n"
214+"Language-Team: \n"
215+"MIME-Version: 1.0\n"
216+"Content-Type: text/plain; charset=UTF-8\n"
217+"Content-Transfer-Encoding: \n"
218+"Plural-Forms: \n"
219+
220+#. module: account_export_csv
221+#: model:ir.model,name:account_export_csv.model_account_csv_export
222+msgid "Export Accounting"
223+msgstr "Export comptable"
224+
225+#. module: account_export_csv
226+#: field:account.csv.export,export_filename:0
227+msgid "Export CSV Filename"
228+msgstr "Nom du fichier CSV d'export"
229+
230+#. module: account_export_csv
231+#: view:account.csv.export:0
232+msgid "Trial Balance"
233+msgstr "Balance générale"
234+
235+#. module: account_export_csv
236+#: field:account.csv.export,company_id:0
237+msgid "Company"
238+msgstr "Société"
239+
240+#. module: account_export_csv
241+#: view:account.csv.export:0
242+msgid "Analytic Balance (with accounts)"
243+msgstr "Balance analytique (avec comptes)"
244+
245+#. module: account_export_csv
246+#: help:account.csv.export,periods:0
247+msgid "All periods in the fiscal year if empty"
248+msgstr "Toutes les périodes de l'année fiscale si vide"
249+
250+#. module: account_export_csv
251+#: field:account.csv.export,periods:0
252+msgid "Periods"
253+msgstr "Périodes"
254+
255+#. module: account_export_csv
256+#: view:account.csv.export:0
257+msgid "Close"
258+msgstr "Fermer"
259+
260+#. module: account_export_csv
261+#: view:account.csv.export:0
262+#: model:ir.actions.act_window,name:account_export_csv.action_account_csv_export
263+#: model:ir.ui.menu,name:account_export_csv.menu_account_csv_export
264+msgid "Accounting CSV Export"
265+msgstr "Export comptable CSV"
266+
267+#. module: account_export_csv
268+#: field:account.csv.export,data:0
269+msgid "CSV"
270+msgstr "CSV"
271+
272+#. module: account_export_csv
273+#: field:account.csv.export,fiscalyear_id:0
274+msgid "Fiscalyear"
275+msgstr "Année fiscale"
276+
277
278=== added file 'account_export_csv/i18n/nl.po'
279--- account_export_csv/i18n/nl.po 1970-01-01 00:00:00 +0000
280+++ account_export_csv/i18n/nl.po 2014-08-15 20:07:23 +0000
281@@ -0,0 +1,74 @@
282+# Translation of OpenERP Server.
283+# This file contains the translation of the following modules:
284+# * account_export_csv
285+#
286+msgid ""
287+msgstr ""
288+"Project-Id-Version: OpenERP Server 7.0\n"
289+"Report-Msgid-Bugs-To: \n"
290+"POT-Creation-Date: 2013-08-22 12:52+0000\n"
291+"PO-Revision-Date: 2013-08-22 12:52+0000\n"
292+"Last-Translator: <stefan@therp.nl>\n"
293+"Language-Team: \n"
294+"MIME-Version: 1.0\n"
295+"Content-Type: text/plain; charset=UTF-8\n"
296+"Content-Transfer-Encoding: \n"
297+"Plural-Forms: \n"
298+
299+#. module: account_export_csv
300+#: model:ir.model,name:account_export_csv.model_account_csv_export
301+msgid "Export Accounting"
302+msgstr "Export Financiën"
303+
304+#. module: account_export_csv
305+#: field:account.csv.export,export_filename:0
306+msgid "Export CSV Filename"
307+msgstr "Export CSV bestandsnaam"
308+
309+#. module: account_export_csv
310+#: view:account.csv.export:0
311+msgid "Trial Balance"
312+msgstr "Proefbalans"
313+
314+#. module: account_export_csv
315+#: field:account.csv.export,company_id:0
316+msgid "Company"
317+msgstr "Bedrijf"
318+
319+#. module: account_export_csv
320+#: view:account.csv.export:0
321+msgid "Analytic Balance (with accounts)"
322+msgstr "Kostenplaatsenbalans (met rekeningen)"
323+
324+#. module: account_export_csv
325+#: help:account.csv.export,periods:0
326+msgid "All periods in the fiscal year if empty"
327+msgstr "Alle periodes van het boekjaar indien leeg"
328+
329+#. module: account_export_csv
330+#: field:account.csv.export,periods:0
331+msgid "Periods"
332+msgstr "Periodes"
333+
334+#. module: account_export_csv
335+#: view:account.csv.export:0
336+msgid "Close"
337+msgstr "Sluiten"
338+
339+#. module: account_export_csv
340+#: view:account.csv.export:0
341+#: model:ir.actions.act_window,name:account_export_csv.action_account_csv_export
342+#: model:ir.ui.menu,name:account_export_csv.menu_account_csv_export
343+msgid "Accounting CSV Export"
344+msgstr "CSV export financiën"
345+
346+#. module: account_export_csv
347+#: field:account.csv.export,data:0
348+msgid "CSV"
349+msgstr "CSV"
350+
351+#. module: account_export_csv
352+#: field:account.csv.export,fiscalyear_id:0
353+msgid "Fiscalyear"
354+msgstr "Boekjaar"
355+
356
357=== added file 'account_export_csv/menu.xml'
358--- account_export_csv/menu.xml 1970-01-01 00:00:00 +0000
359+++ account_export_csv/menu.xml 2014-08-15 20:07:23 +0000
360@@ -0,0 +1,16 @@
361+<?xml version="1.0" encoding="utf-8"?>
362+<openerp>
363+ <data>
364+
365+ <menuitem
366+ icon="STOCK_EXECUTE"
367+ name="Accounting CSV Export"
368+ action="action_account_csv_export"
369+ id="menu_account_csv_export"
370+ parent="account.menu_finance_reports"
371+ sequence="110"
372+ />
373+
374+
375+ </data>
376+</openerp>
377
378=== added directory 'account_export_csv/wizard'
379=== added file 'account_export_csv/wizard/__init__.py'
380--- account_export_csv/wizard/__init__.py 1970-01-01 00:00:00 +0000
381+++ account_export_csv/wizard/__init__.py 2014-08-15 20:07:23 +0000
382@@ -0,0 +1,21 @@
383+# -*- coding: utf-8 -*-
384+##############################################################################
385+#
386+# Author Joel Grand-Guillaume and Vincent Renaville Copyright 2013 Camptocamp SA
387+#
388+# This program is free software: you can redistribute it and/or modify
389+# it under the terms of the GNU Affero General Public License as
390+# published by the Free Software Foundation, either version 3 of the
391+# License, or (at your option) any later version.
392+#
393+# This program is distributed in the hope that it will be useful,
394+# but WITHOUT ANY WARRANTY; without even the implied warranty of
395+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
396+# GNU Affero General Public License for more details.
397+#
398+# You should have received a copy of the GNU Affero General Public License
399+# along with this program. If not, see <http://www.gnu.org/licenses/>.
400+#
401+##############################################################################
402+
403+import account_export_csv
404\ No newline at end of file
405
406=== added file 'account_export_csv/wizard/account_export_csv.py'
407--- account_export_csv/wizard/account_export_csv.py 1970-01-01 00:00:00 +0000
408+++ account_export_csv/wizard/account_export_csv.py 2014-08-15 20:07:23 +0000
409@@ -0,0 +1,376 @@
410+# -*- coding: utf-8 -*-
411+##############################################################################
412+#
413+# Author Joel Grand-Guillaume and Vincent Renaville Copyright 2013 Camptocamp SA
414+# CSV data formating inspired from http://docs.python.org/2.7/library/csv.html?highlight=csv#examples
415+#
416+# This program is free software: you can redistribute it and/or modify
417+# it under the terms of the GNU Affero General Public License as
418+# published by the Free Software Foundation, either version 3 of the
419+# License, or (at your option) any later version.
420+#
421+# This program is distributed in the hope that it will be useful,
422+# but WITHOUT ANY WARRANTY; without even the implied warranty of
423+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
424+# GNU Affero General Public License for more details.
425+#
426+# You should have received a copy of the GNU Affero General Public License
427+# along with this program. If not, see <http://www.gnu.org/licenses/>.
428+#
429+##############################################################################
430+
431+import itertools
432+import time
433+import tempfile
434+import StringIO
435+import cStringIO
436+import base64
437+
438+import csv
439+import codecs
440+
441+from openerp.osv import orm, fields
442+from openerp.tools.translate import _
443+
444+
445+class AccountUnicodeWriter(object):
446+ """
447+ A CSV writer which will write rows to CSV file "f",
448+ which is encoded in the given encoding.
449+ """
450+
451+ def __init__(self, f, dialect=csv.excel, encoding="utf-8", **kwds):
452+ # Redirect output to a queue
453+ self.queue = cStringIO.StringIO()
454+ # created a writer with Excel formating settings
455+ self.writer = csv.writer(self.queue, dialect=dialect, **kwds)
456+ self.stream = f
457+ self.encoder = codecs.getincrementalencoder(encoding)()
458+
459+ def writerow(self, row):
460+ #we ensure that we do not try to encode none or bool
461+ row = (x or u'' for x in row)
462+
463+ encoded_row = [c.encode("utf-8") if isinstance(c, unicode) else c for c in row]
464+
465+ self.writer.writerow(encoded_row)
466+ # Fetch UTF-8 output from the queue ...
467+ data = self.queue.getvalue()
468+ data = data.decode("utf-8")
469+ # ... and reencode it into the target encoding
470+ data = self.encoder.encode(data)
471+ # write to the target stream
472+ self.stream.write(data)
473+ # empty queue
474+ self.queue.truncate(0)
475+
476+ def writerows(self, rows):
477+ for row in rows:
478+ self.writerow(row)
479+
480+class AccountCSVExport(orm.TransientModel):
481+ _name = 'account.csv.export'
482+ _description = 'Export Accounting'
483+
484+ _columns = {
485+ 'data': fields.binary('CSV',readonly=True),
486+ 'company_id': fields.many2one('res.company', 'Company', invisible=True),
487+ 'fiscalyear_id': fields.many2one('account.fiscalyear', 'Fiscalyear', required=True),
488+ 'periods': fields.many2many('account.period','rel_wizard_period','wizard_id','period_id','Periods',help='All periods in the fiscal year if empty'),
489+ 'journal_ids': fields.many2many('account.journal','rel_wizard_journal','wizard_id','journal_id','Journals', help='If empty, use all journals, only used for journal entries'),
490+ 'fiscalyear_id': fields.many2one('account.fiscalyear', 'Fiscalyear', required=True),
491+ 'export_filename': fields.char('Export CSV Filename', size=128),
492+ }
493+
494+ def _get_company_default(self, cr, uid, context=None):
495+ comp_obj = self.pool['res.company']
496+ return comp_obj._company_default_get(cr, uid, 'account.fiscalyear', context=context)
497+
498+ def _get_fiscalyear_default(self, cr, uid, context=None):
499+ fiscalyear_obj = self.pool['account.fiscalyear']
500+ context['company_id'] = self._get_company_default(cr, uid, context)
501+ return fiscalyear_obj.find(cr,uid,dt=None,exception=True, context=context)
502+
503+ _defaults = {'company_id': _get_company_default,
504+ 'fiscalyear_id' : _get_fiscalyear_default,
505+ 'export_filename' : 'account_export.csv'}
506+
507+ def action_manual_export_account(self, cr, uid, ids, context=None):
508+ this = self.browse(cr, uid, ids)[0]
509+ rows = self.get_data(cr, uid, ids, "account", context)
510+ file_data = StringIO.StringIO()
511+ try:
512+ writer = AccountUnicodeWriter(file_data)
513+ writer.writerows(rows)
514+ file_value = file_data.getvalue()
515+ self.write(cr, uid, ids,
516+ {'data': base64.encodestring(file_value)},
517+ context=context)
518+ finally:
519+ file_data.close()
520+ return {
521+ 'type': 'ir.actions.act_window',
522+ 'res_model': 'account.csv.export',
523+ 'view_mode': 'form',
524+ 'view_type': 'form',
525+ 'res_id': this.id,
526+ 'views': [(False, 'form')],
527+ 'target': 'new',
528+ }
529+
530+
531+ def _get_header_account(self, cr, uid, ids, context=None):
532+ return [_(u'CODE'),
533+ _(u'NAME'),
534+ _(u'DEBIT'),
535+ _(u'CREDIT'),
536+ _(u'BALANCE'),
537+ ]
538+
539+ def _get_rows_account(self, cr, uid, ids,
540+ fiscalyear_id,
541+ period_range_ids,
542+ journal_ids,
543+ context=None):
544+ """
545+ Return list to generate rows of the CSV file
546+ """
547+ cr.execute("""
548+ select ac.code,ac.name,
549+ sum(debit) as sum_debit,sum(credit) as sum_credit,sum(debit) - sum(credit) as balance
550+ from account_move_line as aml,account_account as ac
551+ where aml.account_id = ac.id
552+ and period_id in %(period_ids)s
553+ group by ac.id,ac.code,ac.name
554+ order by ac.code
555+ """,
556+ {'fiscalyear_id': fiscalyear_id, 'period_ids':tuple(period_range_ids)}
557+ )
558+ res = cr.fetchall()
559+
560+ rows = []
561+ for line in res:
562+ rows.append(list(line))
563+ return rows
564+
565+ def action_manual_export_analytic(self, cr, uid, ids, context=None):
566+ this = self.browse(cr, uid, ids)[0]
567+ rows = self.get_data(cr, uid, ids,"analytic", context)
568+ file_data = StringIO.StringIO()
569+ try:
570+ writer = AccountUnicodeWriter(file_data)
571+ writer.writerows(rows)
572+ file_value = file_data.getvalue()
573+ self.write(cr, uid, ids,
574+ {'data': base64.encodestring(file_value)},
575+ context=context)
576+ finally:
577+ file_data.close()
578+ return {
579+ 'type': 'ir.actions.act_window',
580+ 'res_model': 'account.csv.export',
581+ 'view_mode': 'form',
582+ 'view_type': 'form',
583+ 'res_id': this.id,
584+ 'views': [(False, 'form')],
585+ 'target': 'new',
586+ }
587+
588+ def _get_header_analytic(self, cr, uid, ids, context=None):
589+ return [_(u'ANALYTIC CODE'),
590+ _(u'ANALYTIC NAME'),
591+ _(u'CODE'),
592+ _(u'ACCOUNT NAME'),
593+ _(u'DEBIT'),
594+ _(u'CREDIT'),
595+ _(u'BALANCE'),
596+ ]
597+
598+ def _get_rows_analytic(self, cr, uid, ids,
599+ fiscalyear_id,
600+ period_range_ids,
601+ journal_ids,
602+ context=None):
603+ """
604+ Return list to generate rows of the CSV file
605+ """
606+ cr.execute(""" select aac.code as analytic_code,aac.name as analytic_name,ac.code,ac.name,
607+ sum(debit) as sum_debit,sum(credit) as sum_credit,sum(debit) - sum(credit) as balance
608+ from account_move_line
609+ left outer join account_analytic_account as aac
610+ on (account_move_line.analytic_account_id = aac.id)
611+ inner join account_account as ac
612+ on account_move_line.account_id = ac.id
613+ and account_move_line.period_id in %(period_ids)s
614+ group by aac.id,aac.code,aac.name,ac.id,ac.code,ac.name
615+ order by aac.code
616+ """,
617+ {'fiscalyear_id': fiscalyear_id, 'period_ids':tuple(period_range_ids)}
618+ )
619+ res = cr.fetchall()
620+
621+ rows = []
622+ for line in res:
623+ rows.append(list(line))
624+ return rows
625+
626+
627+ def action_manual_export_journal_entries(self, cr, uid, ids, context=None):
628+ """
629+ Here we use TemporaryFile to avoid full filling the OpenERP worker Memory
630+ We also write the data to the wizard with SQL query as write seams to use
631+ too much memory as well.
632+
633+ Those improvements permitted to improve the export from a 100k line to 200k lines
634+ with default `limit_memory_hard = 805306368` (768MB) with more lines,
635+ you might encounter a MemoryError when trying to download the file even
636+ if it has been generated.
637+
638+ To be able to export bigger volume of data, it is advised to set
639+ limit_memory_hard to 2097152000 (2 GB) to generate the file and let
640+ OpenERP load it in the wizard when trying to download it.
641+
642+ Tested with up to a generation of 700k entry lines
643+ """
644+ this = self.browse(cr, uid, ids)[0]
645+ rows = self.get_data(cr, uid, ids, "journal_entries", context)
646+ with tempfile.TemporaryFile() as file_data:
647+ writer = AccountUnicodeWriter(file_data)
648+ writer.writerows(rows)
649+ with tempfile.TemporaryFile() as base64_data:
650+ file_data.seek(0)
651+ base64.encode(file_data, base64_data)
652+ base64_data.seek(0)
653+ cr.execute("""UPDATE account_csv_export SET data = %s WHERE id = %s""", (base64_data.read(), ids[0]) )
654+ return {
655+ 'type': 'ir.actions.act_window',
656+ 'res_model': 'account.csv.export',
657+ 'view_mode': 'form',
658+ 'view_type': 'form',
659+ 'res_id': this.id,
660+ 'views': [(False, 'form')],
661+ 'target': 'new',
662+ }
663+
664+
665+ def _get_header_journal_entries(self, cr, uid, ids, context=None):
666+
667+ return [
668+ # Standard Sage export fields
669+ _(u'DATE'),
670+ _(u'JOURNAL CODE'),
671+ _(u'ACCOUNT CODE'),
672+ _(u'PARTNER NAME'),
673+ _(u'REF'),
674+ _(u'DESCRIPTION'),
675+ _(u'DEBIT'),
676+ _(u'CREDIT'),
677+ _(u'FULL RECONCILE'),
678+ _(u'PARTIAL RECONCILE'),
679+ _(u'ANALYTIC ACCOUNT CODE'),
680+
681+ # Other fields
682+ _(u'ENTRY NUMBER'),
683+ _(u'ACCOUNT NAME'),
684+ _(u'BALANCE'),
685+ _(u'AMOUNT CURRENCY'),
686+ _(u'CURRENCY'),
687+ _(u'ANALYTIC ACCOUNT NAME'),
688+ _(u'JOURNAL'),
689+ _(u'MONTH'),
690+ _(u'FISCAL YEAR'),
691+ _(u'TAX CODE CODE'),
692+ _(u'TAX CODE NAME'),
693+ _(u'TAX AMOUNT'),
694+ ]
695+
696+
697+ def _get_rows_journal_entries(self, cr, uid, ids,
698+ fiscalyear_id,
699+ period_range_ids,
700+ journal_ids,
701+ context=None):
702+ """
703+ Create a generator of rows of the CSV file
704+ """
705+ cr.execute("""
706+ SELECT
707+ account_move_line.date AS date,
708+ account_journal.name as journal,
709+ account_account.code AS account_code,
710+ res_partner.name AS partner_name,
711+ account_move_line.ref AS ref,
712+ account_move_line.name AS description,
713+ account_move_line.debit AS debit,
714+ account_move_line.credit AS credit,
715+ account_move_reconcile.name as full_reconcile,
716+ account_move_line.reconcile_partial_id AS partial_reconcile_id,
717+ account_analytic_account.code AS analytic_account_code,
718+
719+ account_move.name AS entry_number,
720+ account_account.name AS account_name,
721+ account_move_line.debit - account_move_line.credit AS balance,
722+ account_move_line.amount_currency AS amount_currency,
723+ res_currency.name AS currency,
724+ account_analytic_account.name AS analytic_account_name,
725+ account_journal.name as journal,
726+ account_period.code AS month,
727+ account_fiscalyear.name as fiscal_year,
728+ account_tax_code.code AS aml_tax_code_code,
729+ account_tax_code.name AS aml_tax_code_name,
730+ account_move_line.tax_amount AS aml_tax_amount
731+ FROM
732+ public.account_move_line
733+ JOIN account_account on (account_account.id=account_move_line.account_id)
734+ JOIN account_period on (account_period.id=account_move_line.period_id)
735+ JOIN account_fiscalyear on (account_fiscalyear.id=account_period.fiscalyear_id)
736+ JOIN account_journal on (account_journal.id = account_move_line.journal_id)
737+ LEFT JOIN res_currency on (res_currency.id=account_move_line.currency_id)
738+ LEFT JOIN account_move_reconcile on (account_move_reconcile.id = account_move_line.reconcile_id)
739+ LEFT JOIN res_partner on (res_partner.id=account_move_line.partner_id)
740+ LEFT JOIN account_move on (account_move.id=account_move_line.move_id)
741+ LEFT JOIN account_tax on (account_tax.id=account_move_line.account_tax_id)
742+ LEFT JOIN account_tax_code on (account_tax_code.id=account_move_line.tax_code_id)
743+ LEFT JOIN account_analytic_account on (account_analytic_account.id=account_move_line.analytic_account_id)
744+ WHERE account_period.id IN %(period_ids)s
745+ AND account_journal.id IN %(journal_ids)s
746+ ORDER BY account_move_line.date
747+ """,
748+ {'period_ids': tuple(period_range_ids), 'journal_ids': tuple(journal_ids)}
749+ )
750+ while 1:
751+ # http://initd.org/psycopg/docs/cursor.html#cursor.fetchmany
752+ # Set cursor.arraysize to minimize network round trips
753+ cr.arraysize=100
754+ rows = cr.fetchmany()
755+ if not rows:
756+ break
757+ for row in rows:
758+ yield row
759+
760+ def get_data(self, cr, uid, ids,result_type,context=None):
761+ get_header_func = getattr(self,("_get_header_%s"%(result_type)), None)
762+ get_rows_func = getattr(self,("_get_rows_%s"%(result_type)), None)
763+ form = self.browse(cr, uid, ids[0], context=context)
764+ fiscalyear_id = form.fiscalyear_id.id
765+ user_obj = self.pool.get('res.users')
766+ if form.periods:
767+ period_range_ids = [x.id for x in form.periods]
768+ else:
769+ # If not period selected , we take all periods
770+ p_obj = self.pool.get("account.period")
771+ period_range_ids = p_obj.search(cr, uid, [('fiscalyear_id','=',fiscalyear_id)], context=context)
772+ journal_ids = None
773+ if form.journal_ids:
774+ journal_ids = [x.id for x in form.journal_ids]
775+ else:
776+ j_obj = self.pool.get("account.journal")
777+ journal_ids = j_obj.search(cr, uid, [], context=context)
778+ rows = itertools.chain((get_header_func(cr, uid, ids, context=context),),
779+ get_rows_func(cr, uid, ids,
780+ fiscalyear_id,
781+ period_range_ids,
782+ journal_ids,
783+ context=context)
784+ )
785+ return rows
786
787=== added file 'account_export_csv/wizard/account_export_csv_view.xml'
788--- account_export_csv/wizard/account_export_csv_view.xml 1970-01-01 00:00:00 +0000
789+++ account_export_csv/wizard/account_export_csv_view.xml 2014-08-15 20:07:23 +0000
790@@ -0,0 +1,47 @@
791+<?xml version="1.0" encoding="utf-8"?>
792+<openerp>
793+ <data>
794+
795+ <record id="account_csv_export_view" model="ir.ui.view">
796+ <field name="name">Accounting Entries CSV Export</field>
797+ <field name="model">account.csv.export</field>
798+ <field name="type">form</field>
799+ <field name="arch" type="xml">
800+ <form string="Accounting CSV Export" version="7.0">
801+ <group colspan="4">
802+ <field name="company_id" />
803+ <field name="fiscalyear_id" domain="[('company_id', '=', company_id)]"/>
804+ </group>
805+ <group colspan="4" col="2">
806+ <field name="periods" domain="[('fiscalyear_id','=',fiscalyear_id)]"/>
807+ <field name="journal_ids"/>
808+ </group>
809+ <separator string ="Report" colspan="4"/>
810+ <group colspan="4">
811+ <field name="data" filename="export_filename"/>
812+ </group>
813+ <footer>
814+ <button name="action_manual_export_account" string="Trial Balance" type="object" icon="gtk-execute" class="oe_highlight"/>
815+ <button name="action_manual_export_analytic" string="Analytic Balance (with accounts)" type="object" icon="gtk-execute" class="oe_highlight"/>
816+ <button name="action_manual_export_journal_entries" string="Journal Entries" type="object" icon="gtk-execute" class="oe_highlight"/>
817+ or
818+ <button string="Close" class="oe_link" special="cancel" />
819+ </footer>
820+
821+ </form>
822+ </field>
823+ </record>
824+
825+ <record id="action_account_csv_export" model="ir.actions.act_window">
826+ <field name="name">Accounting CSV Export</field>
827+ <field name="res_model">account.csv.export</field>
828+ <field name="type">ir.actions.act_window</field>
829+ <field name="view_type">form</field>
830+ <field name="view_mode">tree,form</field>
831+ <field name="view_id" ref="account_csv_export_view"/>
832+ <field name="context">{}</field>
833+ <field name="target">new</field>
834+ </record>
835+
836+ </data>
837+</openerp>
838
839=== added directory 'account_financial_report'
840=== renamed directory 'account_financial_report' => 'account_financial_report.moved'
841=== added file 'account_financial_report/__init__.py'
842--- account_financial_report/__init__.py 1970-01-01 00:00:00 +0000
843+++ account_financial_report/__init__.py 2014-08-15 20:07:23 +0000
844@@ -0,0 +1,30 @@
845+# -*- encoding: utf-8 -*-
846+###########################################################################
847+# Module Writen to OpenERP, Open Source Management Solution
848+# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
849+# All Rights Reserved
850+###############Credits######################################################
851+# Coded by: Humberto Arocha humberto@openerp.com.ve
852+# Angelica Barrios angelicaisabelb@gmail.com
853+# Jordi Esteve <jesteve@zikzakmedia.com>
854+# Planified by: Humberto Arocha
855+# Finance by: LUBCAN COL S.A.S http://www.lubcancol.com
856+# Audited by: Humberto Arocha humberto@openerp.com.ve
857+#############################################################################
858+# This program is free software: you can redistribute it and/or modify
859+# it under the terms of the GNU General Public License as published by
860+# the Free Software Foundation, either version 3 of the License, or
861+# (at your option) any later version.
862+#
863+# This program is distributed in the hope that it will be useful,
864+# but WITHOUT ANY WARRANTY; without even the implied warranty of
865+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
866+# GNU General Public License for more details.
867+#
868+# You should have received a copy of the GNU General Public License
869+# along with this program. If not, see <http://www.gnu.org/licenses/>.
870+##############################################################################
871+
872+import model
873+import report
874+import wizard
875
876=== added file 'account_financial_report/__openerp__.py'
877--- account_financial_report/__openerp__.py 1970-01-01 00:00:00 +0000
878+++ account_financial_report/__openerp__.py 2014-08-15 20:07:23 +0000
879@@ -0,0 +1,65 @@
880+# -*- encoding: utf-8 -*-
881+###########################################################################
882+# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
883+# All Rights Reserved
884+# Credits######################################################
885+# Coded by: Humberto Arocha humberto@openerp.com.ve
886+# Angelica Barrios angelicaisabelb@gmail.com
887+# Jordi Esteve <jesteve@zikzakmedia.com>
888+# Planified by: Humberto Arocha
889+# Finance by: LUBCAN COL S.A.S http://www.lubcancol.com
890+# Audited by: Humberto Arocha humberto@openerp.com.ve
891+#############################################################################
892+# This program is free software: you can redistribute it and/or modify
893+# it under the terms of the GNU General Public License as published by
894+# the Free Software Foundation, either version 3 of the License, or
895+# (at your option) any later version.
896+#
897+# This program is distributed in the hope that it will be useful,
898+# but WITHOUT ANY WARRANTY; without even the implied warranty of
899+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
900+# GNU General Public License for more details.
901+#
902+# You should have received a copy of the GNU General Public License
903+# along with this program. If not, see <http://www.gnu.org/licenses/>.
904+##############################################################################
905+{
906+ "name": "Common financial reports",
907+ "version": "2.0",
908+ "author": "Vauxoo",
909+ "website": "http://www.vauxoo.com",
910+ "depends": ["base",
911+ "account"
912+ ],
913+ "category": "Accounting",
914+ "description": """
915+Multiporpuse Accounting report generator.
916+=========================================
917+
918+From the wizard you will be asked to provide information needed to create your
919+report.
920+
921+Not only you can set the option within the wizard you can create your own
922+Customized Account Financial Reports, in here, you will be able to create
923+Templates for generating Two types of Reports: Balance Sheets and Income
924+Statements, incluiding Analytic Ledgers. Besides, you can select within a set
925+of choices to get better detailed report, be it that you ask it by one or
926+several periods, by months (12 Months + YTD), or by quarters (4QRT's + YTD).
927+Even you can get your reports in currencies other than the one set on your
928+company.
929+
930+In the [ Account's Sign on Reports ] Section in the Company will be able to
931+set the sign conventions for the Accounts, so that you will be able to see in
932+positives Values in your reports for those accounts with Accreditable nature
933+where appropriate""",
934+ "data": [
935+ "security/security.xml",
936+ "security/ir.model.access.csv",
937+ "view/report.xml",
938+ "view/wizard.xml",
939+ "view/company_view.xml",
940+ "view/account_financial_report_view.xml",
941+ ],
942+ "active": False,
943+ "installable": True
944+}
945
946=== added directory 'account_financial_report/i18n'
947=== added file 'account_financial_report/i18n/es.mo'
948Binary files account_financial_report/i18n/es.mo 1970-01-01 00:00:00 +0000 and account_financial_report/i18n/es.mo 2014-08-15 20:07:23 +0000 differ
949=== added file 'account_financial_report/i18n/es.po'
950--- account_financial_report/i18n/es.po 1970-01-01 00:00:00 +0000
951+++ account_financial_report/i18n/es.po 2014-08-15 20:07:23 +0000
952@@ -0,0 +1,695 @@
953+# Translation of OpenERP Server.
954+# This file contains the translation of the following modules:
955+# * account_financial_report
956+#
957+msgid ""
958+msgstr ""
959+"Project-Id-Version: OpenERP Server 7.0\n"
960+"Report-Msgid-Bugs-To: \n"
961+"POT-Creation-Date: 2013-06-17 21:47+0000\n"
962+"PO-Revision-Date: 2013-06-17 21:47+0000\n"
963+"Last-Translator: <>\n"
964+"Language-Team: \n"
965+"MIME-Version: 1.0\n"
966+"Content-Type: text/plain; charset=UTF-8\n"
967+"Content-Transfer-Encoding: \n"
968+"Plural-Forms: \n"
969+
970+#. module: account_financial_report
971+#: view:res.company:0
972+msgid "Reverse sign on Reports for these accounts and children accounts that are within Debitable Accounts"
973+msgstr "Invierte el signo en los reportes para estas cuentas y las cuentas hijas que están dentro de las Cuentas Debitables"
974+
975+#. module: account_financial_report
976+#: selection:afr,filter:0
977+#: selection:wizard.report,filter:0
978+msgid "No Filter"
979+msgstr "Sin Filtro"
980+
981+#. module: account_financial_report
982+#: selection:afr,display_account:0
983+#: selection:wizard.report,display_account:0
984+msgid "With Balance / Movements"
985+msgstr "Con Saldo / Movimientos"
986+
987+#. module: account_financial_report
988+#: model:ir.actions.report.xml,name:account_financial_report.4_col_report
989+msgid "Balance 4 Columnas"
990+msgstr "Balance 4 Columnas"
991+
992+#. module: account_financial_report
993+#: view:res.company:0
994+msgid "An accreditable account is one which grows in the credit and diminishes in the debit"
995+msgstr "Una cuenta acreditable es una que crece por el crédito y disminuye por el débito."
996+
997+#. module: account_financial_report
998+#: report:afr.1cols:0
999+#: report:afr.4cols:0
1000+#: report:afr.analytic.ledger:0
1001+msgid "BALANCE"
1002+msgstr "BALANCE"
1003+
1004+#. module: account_financial_report
1005+#: code:addons/account_financial_report/report/parser.py:85
1006+#: selection:afr,inf_type:0
1007+#: selection:wizard.report,inf_type:0
1008+#, python-format
1009+msgid "Balance Sheet"
1010+msgstr "Balance General"
1011+
1012+#. module: account_financial_report
1013+#: field:afr,company_id:0
1014+#: field:wizard.report,company_id:0
1015+msgid "Company"
1016+msgstr "Compañía"
1017+
1018+#. module: account_financial_report
1019+#: code:addons/account_financial_report/wizard/wizard.py:150
1020+#, python-format
1021+msgid "Write a Description for your Summary Total"
1022+msgstr "Escriba una Descripción para el total del Sumario"
1023+
1024+#. module: account_financial_report
1025+#: model:ir.actions.report.xml,name:account_financial_report.5_col_report
1026+msgid "Balance 5 Columnas"
1027+msgstr "Balance 5 Columnas"
1028+
1029+#. module: account_financial_report
1030+#: model:ir.actions.report.xml,name:account_financial_report.qtr_col_report
1031+msgid "Balance QTRs Columnas"
1032+msgstr "Balance QTRs Columnas"
1033+
1034+#. module: account_financial_report
1035+#: report:afr.5cols:0
1036+msgid "INIT. BAL."
1037+msgstr "BAL. INIC."
1038+
1039+#. module: account_financial_report
1040+#: selection:afr,filter:0
1041+#: selection:wizard.report,filter:0
1042+msgid "By Date and Period"
1043+msgstr "Por fecha y período"
1044+
1045+#. module: account_financial_report
1046+#: code:addons/account_financial_report/model/account_financial_report.py:77
1047+#, python-format
1048+msgid "Copy of %s"
1049+msgstr "Copia de %s"
1050+
1051+#. module: account_financial_report
1052+#: field:afr,account_ids:0
1053+#: field:wizard.report,account_list:0
1054+msgid "Root accounts"
1055+msgstr "Cuentas raíces"
1056+
1057+#. module: account_financial_report
1058+#: report:afr.5cols:0
1059+#: report:afr.analytic.ledger:0
1060+msgid "PERIOD"
1061+msgstr "PERIODO"
1062+
1063+#. module: account_financial_report
1064+#: selection:afr,display_account:0
1065+#: selection:wizard.report,display_account:0
1066+msgid "With Balance"
1067+msgstr "Con Balance"
1068+
1069+#. module: account_financial_report
1070+#: report:afr.13cols:0
1071+msgid "12"
1072+msgstr "12"
1073+
1074+#. module: account_financial_report
1075+#: selection:afr,filter:0
1076+#: selection:wizard.report,filter:0
1077+msgid "By Date"
1078+msgstr "Por Fecha"
1079+
1080+#. module: account_financial_report
1081+#: code:addons/account_financial_report/wizard/wizard.py:242
1082+#, python-format
1083+msgid "La interseccion entre el periodo y fecha es vacio"
1084+msgstr "La interseccion entre el periodo y fecha es vacio"
1085+
1086+#. module: account_financial_report
1087+#: view:afr:0
1088+#: view:wizard.report:0
1089+msgid "Company Info"
1090+msgstr "Información de la Compañía"
1091+
1092+#. module: account_financial_report
1093+#: code:addons/account_financial_report/report/parser.py:344
1094+#: code:addons/account_financial_report/wizard/wizard.py:189
1095+#: code:addons/account_financial_report/wizard/wizard.py:193
1096+#, python-format
1097+msgid "UserError"
1098+msgstr "UserError"
1099+
1100+#. module: account_financial_report
1101+#: report:afr.analytic.ledger:0
1102+msgid "JOURNAL ENTRY"
1103+msgstr "ASIENTO DIARIO"
1104+
1105+#. module: account_financial_report
1106+#: report:afr.2cols:0
1107+#: report:afr.4cols:0
1108+#: report:afr.5cols:0
1109+#: report:afr.analytic.ledger:0
1110+msgid "CREDIT"
1111+msgstr "CREDITO"
1112+
1113+#. module: account_financial_report
1114+#: view:wizard.report:0
1115+msgid "_Cancel"
1116+msgstr "_Cancelar"
1117+
1118+#. module: account_financial_report
1119+#: view:res.company:0
1120+msgid "Account's Sign on Reports"
1121+msgstr "Signo de las Cuentas en Reportes"
1122+
1123+#. module: account_financial_report
1124+#: model:ir.actions.report.xml,name:account_financial_report.2_col_report
1125+msgid "Balance 2 Columnas"
1126+msgstr "Balance 2 Columnas"
1127+
1128+#. module: account_financial_report
1129+#: selection:afr,columns:0
1130+#: selection:wizard.report,columns:0
1131+msgid "Debit | Credit"
1132+msgstr "Débito | Crédito"
1133+
1134+#. module: account_financial_report
1135+#: view:afr:0
1136+#: view:wizard.report:0
1137+msgid "Please check the [ Account's Sign on Reports ] Section in the Company"
1138+msgstr "Por Favor, Verifique la Sección [ Signo de las Cuentas en Reportes ] en la Compañía"
1139+
1140+#. module: account_financial_report
1141+#: report:afr.13cols:0
1142+#: report:afr.1cols:0
1143+#: report:afr.2cols:0
1144+#: report:afr.4cols:0
1145+#: report:afr.analytic.ledger:0
1146+#: report:afr.qtrcols:0
1147+msgid "CODE"
1148+msgstr "CÓDIGO"
1149+
1150+#. module: account_financial_report
1151+#: view:res.company:0
1152+msgid "A debitable account is one which grows in the debit and diminishes in the credit"
1153+msgstr "Una cuenta debitable es una que crece por el débito y disminuye por el crédito."
1154+
1155+#. module: account_financial_report
1156+#: report:afr.5cols:0
1157+msgid "(Expressed in"
1158+msgstr "(Expresado en"
1159+
1160+#. module: account_financial_report
1161+#: report:afr.4cols:0
1162+#: report:afr.analytic.ledger:0
1163+msgid "INITIAL"
1164+msgstr "INICIAL"
1165+
1166+#. module: account_financial_report
1167+#: field:wizard.report,afr_id:0
1168+msgid "Custom Report"
1169+msgstr "Reporte Personalizado"
1170+
1171+#. module: account_financial_report
1172+#: field:afr,date_from:0
1173+#: field:wizard.report,date_from:0
1174+msgid "Start date"
1175+msgstr "Fecha Inicial"
1176+
1177+#. module: account_financial_report
1178+#: view:afr:0
1179+#: view:wizard.report:0
1180+msgid "Accounts to Include"
1181+msgstr "Cuentas a incluir"
1182+
1183+#. module: account_financial_report
1184+#: code:addons/account_financial_report/report/parser.py:100
1185+#: code:addons/account_financial_report/report/parser.py:109
1186+#, python-format
1187+msgid " to "
1188+msgstr " hasta "
1189+
1190+#. module: account_financial_report
1191+#: report:afr.13cols:0
1192+msgid "02"
1193+msgstr "02"
1194+
1195+#. module: account_financial_report
1196+#: report:afr.13cols:0
1197+msgid "03"
1198+msgstr "03"
1199+
1200+#. module: account_financial_report
1201+#: report:afr.13cols:0
1202+msgid "01"
1203+msgstr "01"
1204+
1205+#. module: account_financial_report
1206+#: report:afr.13cols:0
1207+msgid "06"
1208+msgstr "06"
1209+
1210+#. module: account_financial_report
1211+#: report:afr.13cols:0
1212+msgid "07"
1213+msgstr "07"
1214+
1215+#. module: account_financial_report
1216+#: report:afr.13cols:0
1217+msgid "04"
1218+msgstr "04"
1219+
1220+#. module: account_financial_report
1221+#: report:afr.13cols:0
1222+msgid "05"
1223+msgstr "05"
1224+
1225+#. module: account_financial_report
1226+#: report:afr.13cols:0
1227+msgid "08"
1228+msgstr "08"
1229+
1230+#. module: account_financial_report
1231+#: report:afr.13cols:0
1232+msgid "09"
1233+msgstr "09"
1234+
1235+#. module: account_financial_report
1236+#: view:afr:0
1237+#: model:ir.ui.menu,name:account_financial_report.account_financial_report_menu
1238+msgid "Account Financial Report (Templates)"
1239+msgstr "Reportes Financieros (Plantillas)"
1240+
1241+#. module: account_financial_report
1242+#: field:afr,fiscalyear_id:0
1243+#: field:wizard.report,fiscalyear:0
1244+msgid "Fiscal year"
1245+msgstr "Ejercicio Fiscal"
1246+
1247+#. module: account_financial_report
1248+#: model:ir.actions.act_window,help:account_financial_report.account_financial_report_action
1249+msgid "Create your own Customized Account Financial Reports, in here, you will be able to create Templates for generating Two types of Reports: Balance Sheets and Income Statements, incluiding Analytic Ledgers. Besides, you can select within a set of choices to get better detailed report, be it that you ask it by one or several periods, by months (12 Months + YTD), or by quarters (4QRT's + YTD). Even you can get your reports in currencies other than the one set on your company."
1250+msgstr "Cree sus propios Reportes Financieros Personalizados, aquí, Vd. podrá se capaz de Diseñar las Plantillas para la generación de Dos Tipos de Reportes: Balances Generales y Estados de Resultados, incluyendo Mayores Analíticos. Además, podrá seleccionar entre un conjunto de opciones para obtener un mejor reporte detallado, sea que lo pida para un período determinado, por meses (12 MESES + YTD) o por trimestres (4to's + YTD). Incluso puede obtener reportes en otras monedas distintas a la establecida en su compañia."
1251+
1252+#. module: account_financial_report
1253+#: field:res.company,credit_account_ids:0
1254+msgid "Creditable Accounts"
1255+msgstr "Cuentas Acreditables"
1256+
1257+#. module: account_financial_report
1258+#: code:addons/account_financial_report/report/parser.py:344
1259+#, python-format
1260+msgid "The Selected Fiscal Year Does not have Regular Periods"
1261+msgstr "El Ejercicio Fiscal Seleccionado no tiene Períodos Regulares"
1262+
1263+#. module: account_financial_report
1264+#: report:afr.13cols:0
1265+#: report:afr.5cols:0
1266+#: report:afr.qtrcols:0
1267+msgid "YTD"
1268+msgstr "YTD"
1269+
1270+#. module: account_financial_report
1271+#: view:afr:0
1272+#: view:wizard.report:0
1273+msgid "Periods to Include"
1274+msgstr "Períodos a incluir"
1275+
1276+#. module: account_financial_report
1277+#: selection:afr,display_account:0
1278+#: selection:wizard.report,display_account:0
1279+msgid "With movements"
1280+msgstr "Con Movimientos"
1281+
1282+#. module: account_financial_report
1283+#: field:afr,currency_id:0
1284+#: field:wizard.report,currency_id:0
1285+msgid "Currency"
1286+msgstr "Moneda"
1287+
1288+#. module: account_financial_report
1289+#: field:afr,display_account:0
1290+#: field:wizard.report,display_account:0
1291+msgid "Display accounts"
1292+msgstr "Mostrar cuentas"
1293+
1294+#. module: account_financial_report
1295+#: field:afr,display_account_level:0
1296+#: field:wizard.report,display_account_level:0
1297+msgid "Up to level"
1298+msgstr "Hasta nivel"
1299+
1300+#. module: account_financial_report
1301+#: report:afr.analytic.ledger:0
1302+msgid "PARTNER"
1303+msgstr "PARTNER"
1304+
1305+#. module: account_financial_report
1306+#: help:afr,currency_id:0
1307+#: help:wizard.report,currency_id:0
1308+msgid "Currency at which this report will be expressed. If not selected will be used the one set in the company"
1309+msgstr "Moneda con la cual este reporte será expresado. Si no se selecciona se usará la que está establecida en la compañía"
1310+
1311+#. module: account_financial_report
1312+#: report:afr.13cols:0
1313+#: report:afr.1cols:0
1314+#: report:afr.2cols:0
1315+#: report:afr.4cols:0
1316+#: report:afr.5cols:0
1317+#: report:afr.analytic.ledger:0
1318+#: report:afr.qtrcols:0
1319+msgid "ACCOUNT"
1320+msgstr "CUENTA"
1321+
1322+#. module: account_financial_report
1323+#: report:afr.analytic.ledger:0
1324+msgid "Pag.:"
1325+msgstr "Pág.:"
1326+
1327+#. module: account_financial_report
1328+#: report:afr.2cols:0
1329+#: report:afr.4cols:0
1330+#: report:afr.5cols:0
1331+#: report:afr.analytic.ledger:0
1332+msgid "DEBIT"
1333+msgstr "DÉBITO"
1334+
1335+#. module: account_financial_report
1336+#: field:afr,columns:0
1337+#: field:wizard.report,columns:0
1338+msgid "Columns"
1339+msgstr "Columnas"
1340+
1341+#. module: account_financial_report
1342+#: report:afr.analytic.ledger:0
1343+msgid "REFERENCE"
1344+msgstr "REFERENCIA"
1345+
1346+#. module: account_financial_report
1347+#: selection:afr,filter:0
1348+#: selection:wizard.report,filter:0
1349+msgid "By Period"
1350+msgstr "Por Período"
1351+
1352+#. module: account_financial_report
1353+#: selection:afr,columns:0
1354+#: selection:wizard.report,columns:0
1355+msgid "4 QTR's | YTD"
1356+msgstr "4 TRM's | YTD"
1357+
1358+#. module: account_financial_report
1359+#: model:ir.actions.act_window,name:account_financial_report.action_wizard_report
1360+#: model:ir.ui.menu,name:account_financial_report.menu_wizard_report
1361+msgid "Account Financial Report (Multireports)"
1362+msgstr "Reportes Financieros (Multireportes)"
1363+
1364+#. module: account_financial_report
1365+#: view:afr:0
1366+#: view:wizard.report:0
1367+msgid "Accounts Info"
1368+msgstr "Información de Cuentas"
1369+
1370+#. module: account_financial_report
1371+#: help:afr,display_account_level:0
1372+#: help:wizard.report,display_account_level:0
1373+msgid "Display accounts up to this level (0 to show all)"
1374+msgstr "Se mostrarán las cuentas hasta este nivel (Seleccionar 0 las mostrará todas)"
1375+
1376+#. module: account_financial_report
1377+#: model:ir.model,name:account_financial_report.model_res_company
1378+msgid "Companies"
1379+msgstr "Compañías"
1380+
1381+#. module: account_financial_report
1382+#: help:afr,fiscalyear_id:0
1383+#: help:wizard.report,fiscalyear:0
1384+msgid "Fiscal Year for this report"
1385+msgstr "Ejercicio Fiscal para este reporte"
1386+
1387+#. module: account_financial_report
1388+#: code:addons/account_financial_report/report/parser.py:87
1389+#: selection:afr,inf_type:0
1390+#: selection:wizard.report,inf_type:0
1391+#, python-format
1392+msgid "Income Statement"
1393+msgstr "Estado de Resultados"
1394+
1395+#. module: account_financial_report
1396+#: report:afr.13cols:0
1397+#: report:afr.1cols:0
1398+#: report:afr.2cols:0
1399+#: report:afr.4cols:0
1400+#: report:afr.5cols:0
1401+#: report:afr.qtrcols:0
1402+msgid "/ Pág.:"
1403+msgstr "/ Pág.:"
1404+
1405+#. module: account_financial_report
1406+#: model:ir.actions.act_window,name:account_financial_report.account_financial_report_action
1407+#: model:res.groups,name:account_financial_report.group_afreport
1408+#: view:wizard.report:0
1409+msgid "Account Financial Report"
1410+msgstr "Reportes Financieros"
1411+
1412+#. module: account_financial_report
1413+#: report:afr.13cols:0
1414+msgid "11"
1415+msgstr "11"
1416+
1417+#. module: account_financial_report
1418+#: report:afr.13cols:0
1419+msgid "10"
1420+msgstr "10"
1421+
1422+#. module: account_financial_report
1423+#: report:afr.5cols:0
1424+msgid "Code"
1425+msgstr "Código"
1426+
1427+#. module: account_financial_report
1428+#: model:ir.actions.report.xml,name:account_financial_report.1_col_report
1429+msgid "Balance 1 Columna"
1430+msgstr "Balance 1 Columna"
1431+
1432+#. module: account_financial_report
1433+#: view:wizard.report:0
1434+msgid "Print"
1435+msgstr "Imprimir"
1436+
1437+#. module: account_financial_report
1438+#: field:afr,filter:0
1439+#: field:wizard.report,filter:0
1440+msgid "Date/Period Filter"
1441+msgstr "Filtro Fecha/Período"
1442+
1443+#. module: account_financial_report
1444+#: view:afr:0
1445+#: view:wizard.report:0
1446+msgid "FiscalYear Info"
1447+msgstr "Información del Ejercicio Fiscal"
1448+
1449+#. module: account_financial_report
1450+#: selection:afr,columns:0
1451+#: selection:wizard.report,columns:0
1452+msgid "Initial | Debit | Credit | YTD"
1453+msgstr "Inicial | Débito | Crédito | YTD"
1454+
1455+#. module: account_financial_report
1456+#: field:afr,period_ids:0
1457+#: field:wizard.report,periods:0
1458+msgid "Periods"
1459+msgstr "Períodos"
1460+
1461+#. module: account_financial_report
1462+#: report:afr.qtrcols:0
1463+msgid "Q1"
1464+msgstr "Q1"
1465+
1466+#. module: account_financial_report
1467+#: report:afr.qtrcols:0
1468+msgid "Q3"
1469+msgstr "Q3"
1470+
1471+#. module: account_financial_report
1472+#: report:afr.qtrcols:0
1473+msgid "Q2"
1474+msgstr "Q2"
1475+
1476+#. module: account_financial_report
1477+#: report:afr.qtrcols:0
1478+msgid "Q4"
1479+msgstr "Q4"
1480+
1481+#. module: account_financial_report
1482+#: help:afr,analytic_ledger:0
1483+#: help:wizard.report,analytic_ledger:0
1484+msgid "Allows to Generate an Analytic Ledger for accounts with moves. Available when Balance Sheet and 'Initial | Debit | Credit | YTD' are selected"
1485+msgstr "Permite generar un Mayor Analítico para las cuentas con movimientos. Disponible cuando se selecciona 'Balance General' e 'Inicial | Débito | Crédito | YTD'"
1486+
1487+#. module: account_financial_report
1488+#: help:wizard.report,afr_id:0
1489+msgid "If you have already set a Custom Report, Select it Here."
1490+msgstr "Si ya ha configurado un Reporte Personalizado, Selecciónelo Aquí."
1491+
1492+#. module: account_financial_report
1493+#: selection:afr,columns:0
1494+#: selection:wizard.report,columns:0
1495+msgid "Initial | Debit | Credit | Period | YTD"
1496+msgstr "Inicial | Débito | Crédito | Período | YTD"
1497+
1498+#. module: account_financial_report
1499+#: selection:afr,columns:0
1500+#: selection:wizard.report,columns:0
1501+msgid "End. Balance"
1502+msgstr "Bal. Final"
1503+
1504+#. module: account_financial_report
1505+#: report:afr.analytic.ledger:0
1506+msgid "DATE"
1507+msgstr "FECHA"
1508+
1509+#. module: account_financial_report
1510+#: view:res.company:0
1511+msgid "Keep sign on Reports for these accounts and children accounts that are within Accreditable Accounts"
1512+msgstr "Mantiene el signo en los reportes para estas cuentas y las cuentas hijas que están dentro de las Cuentas Acreditables"
1513+
1514+#. module: account_financial_report
1515+#: code:addons/account_financial_report/report/parser.py:100
1516+#: code:addons/account_financial_report/report/parser.py:109
1517+#, python-format
1518+msgid "From "
1519+msgstr "Desde "
1520+
1521+#. module: account_financial_report
1522+#: field:afr,inf_type:0
1523+#: field:wizard.report,inf_type:0
1524+msgid "Type"
1525+msgstr "Tipo"
1526+
1527+#. module: account_financial_report
1528+#: field:afr,date_to:0
1529+#: field:wizard.report,date_to:0
1530+msgid "End date"
1531+msgstr "Fecha final"
1532+
1533+#. module: account_financial_report
1534+#: view:afr:0
1535+#: view:wizard.report:0
1536+msgid "Account's Sign Conventions"
1537+msgstr "Convención de Signos de las Cuentas"
1538+
1539+#. module: account_financial_report
1540+#: model:ir.actions.report.xml,name:account_financial_report.13_col_report
1541+msgid "Balance 13 Columnas"
1542+msgstr "Balance 13 Columnas"
1543+
1544+#. module: account_financial_report
1545+#: view:res.company:0
1546+msgid "Accreditable Accounts"
1547+msgstr "Cuentas Acreditables"
1548+
1549+#. module: account_financial_report
1550+#: model:ir.model,name:account_financial_report.model_afr
1551+msgid "afr"
1552+msgstr "afr"
1553+
1554+#. module: account_financial_report
1555+#: field:afr,name:0
1556+msgid "Name"
1557+msgstr "Nombre"
1558+
1559+#. module: account_financial_report
1560+#: code:addons/account_financial_report/report/parser.py:83
1561+#: field:afr,analytic_ledger:0
1562+#: model:ir.actions.report.xml,name:account_financial_report.analytic_ledger_report
1563+#: field:wizard.report,analytic_ledger:0
1564+#, python-format
1565+msgid "Analytic Ledger"
1566+msgstr "Mayor Analítico"
1567+
1568+#. module: account_financial_report
1569+#: view:res.company:0
1570+#: field:res.company,debit_account_ids:0
1571+msgid "Debitable Accounts"
1572+msgstr "Cuentas Debitables"
1573+
1574+#. module: account_financial_report
1575+#: help:afr,period_ids:0
1576+#: help:wizard.report,periods:0
1577+msgid "All periods in the fiscal year if empty"
1578+msgstr "Todos los períodos en el ejercicio fiscal si se deja vacío"
1579+
1580+#. module: account_financial_report
1581+#: code:addons/account_financial_report/wizard/wizard.py:179
1582+#: code:addons/account_financial_report/wizard/wizard.py:242
1583+#, python-format
1584+msgid "Error !"
1585+msgstr "Error !"
1586+
1587+#. module: account_financial_report
1588+#: model:ir.model,name:account_financial_report.model_wizard_report
1589+msgid "wizard.report"
1590+msgstr "wizard.report"
1591+
1592+#. module: account_financial_report
1593+#: field:afr,lab_str:0
1594+#: field:wizard.report,lab_str:0
1595+msgid "Description"
1596+msgstr "Descripción"
1597+
1598+#. module: account_financial_report
1599+#: view:afr:0
1600+#: view:wizard.report:0
1601+msgid "Report Info"
1602+msgstr "Información del Reporte"
1603+
1604+#. module: account_financial_report
1605+#: selection:afr,display_account:0
1606+#: selection:wizard.report,display_account:0
1607+msgid "All Accounts"
1608+msgstr "Todas las Cuentas"
1609+
1610+#. module: account_financial_report
1611+#: field:afr,tot_check:0
1612+#: field:wizard.report,tot_check:0
1613+msgid "Summarize?"
1614+msgstr "Totalizar?"
1615+
1616+#. module: account_financial_report
1617+#: help:afr,tot_check:0
1618+#: help:wizard.report,tot_check:0
1619+msgid "Checking will add a new line at the end of the Report which will Summarize Columns in Report"
1620+msgstr "Seleccionarlo agregará una nueva línea al final del Reporte el cual Totalizará las Columnas en el Reporte"
1621+
1622+#. module: account_financial_report
1623+#: help:afr,lab_str:0
1624+#: help:wizard.report,lab_str:0
1625+msgid "Description for the Summary"
1626+msgstr "Descripción para el Total"
1627+
1628+#. module: account_financial_report
1629+#: selection:afr,columns:0
1630+#: selection:wizard.report,columns:0
1631+msgid "12 Months | YTD"
1632+msgstr "12 Meses | YTD"
1633+
1634+#. module: account_financial_report
1635+#: view:afr:0
1636+#: view:wizard.report:0
1637+msgid "Total"
1638+msgstr "Total"
1639+
1640+#. module: account_financial_report
1641+#: code:addons/account_financial_report/report/parser.py:82
1642+#, python-format
1643+msgid "\n"
1644+"VAT OF COMPANY NOT AVAILABLE"
1645+msgstr "\n"
1646+"VAT DE LA COMPAÑIA NO DISPONIBLE"
1647+
1648
1649=== added file 'account_financial_report/i18n/es_MX.po'
1650--- account_financial_report/i18n/es_MX.po 1970-01-01 00:00:00 +0000
1651+++ account_financial_report/i18n/es_MX.po 2014-08-15 20:07:23 +0000
1652@@ -0,0 +1,687 @@
1653+# Translation of OpenERP Server.
1654+# This file contains the translation of the following modules:
1655+# * account_financial_report
1656+#
1657+msgid ""
1658+msgstr ""
1659+"Project-Id-Version: OpenERP Server 7.0\n"
1660+"Report-Msgid-Bugs-To: \n"
1661+"POT-Creation-Date: 2013-06-17 21:47+0000\n"
1662+"PO-Revision-Date: 2013-06-17 21:47+0000\n"
1663+"Last-Translator: <>\n"
1664+"Language-Team: \n"
1665+"MIME-Version: 1.0\n"
1666+"Content-Type: text/plain; charset=UTF-8\n"
1667+"Content-Transfer-Encoding: \n"
1668+"Plural-Forms: \n"
1669+
1670+#. module: account_financial_report
1671+#: view:res.company:0
1672+msgid "Reverse sign on Reports for these accounts and children accounts that are within Debitable Accounts"
1673+msgstr "Invierte el signo en los reportes para estas cuentas y las cuentas hijas que están dentro de las Cuentas Debitables"
1674+
1675+#. module: account_financial_report
1676+#: selection:afr,filter:0
1677+#: selection:wizard.report,filter:0
1678+msgid "No Filter"
1679+msgstr "Sin Filtro"
1680+
1681+#. module: account_financial_report
1682+#: selection:afr,display_account:0
1683+#: selection:wizard.report,display_account:0
1684+msgid "With Balance / Movements"
1685+msgstr "Con Saldo / Movimientos"
1686+
1687+#. module: account_financial_report
1688+#: model:ir.actions.report.xml,name:account_financial_report.4_col_report
1689+msgid "Balance 4 Columnas"
1690+msgstr "Balance 4 Columnas"
1691+
1692+#. module: account_financial_report
1693+#: view:res.company:0
1694+msgid "An accreditable account is one which grows in the credit and diminishes in the debit"
1695+msgstr "Una cuenta acreditable es una que crece por el crédito y disminuye por el débito."
1696+
1697+#. module: account_financial_report
1698+#: report:afr.1cols:0
1699+#: report:afr.4cols:0
1700+#: report:afr.analytic.ledger:0
1701+msgid "BALANCE"
1702+msgstr "BALANCE"
1703+
1704+#. module: account_financial_report
1705+#: code:addons/account_financial_report/report/parser.py:85
1706+#: selection:afr,inf_type:0
1707+#: selection:wizard.report,inf_type:0
1708+#, python-format
1709+msgid "Balance Sheet"
1710+msgstr "Balance General"
1711+
1712+#. module: account_financial_report
1713+#: field:afr,company_id:0
1714+#: field:wizard.report,company_id:0
1715+msgid "Company"
1716+msgstr "Compañía"
1717+
1718+#. module: account_financial_report
1719+#: code:addons/account_financial_report/wizard/wizard.py:150
1720+#, python-format
1721+msgid "Write a Description for your Summary Total"
1722+msgstr "Escriba una Descripción para el total del Sumario"
1723+
1724+#. module: account_financial_report
1725+#: model:ir.actions.report.xml,name:account_financial_report.5_col_report
1726+msgid "Balance 5 Columnas"
1727+msgstr "Balance 5 Columnas"
1728+
1729+#. module: account_financial_report
1730+#: model:ir.actions.report.xml,name:account_financial_report.qtr_col_report
1731+msgid "Balance QTRs Columnas"
1732+msgstr "Balance QTRs Columnas"
1733+
1734+#. module: account_financial_report
1735+#: report:afr.5cols:0
1736+msgid "INIT. BAL."
1737+msgstr "BAL. INIC."
1738+
1739+#. module: account_financial_report
1740+#: selection:afr,filter:0
1741+#: selection:wizard.report,filter:0
1742+msgid "By Date and Period"
1743+msgstr "Por fecha y período"
1744+
1745+#. module: account_financial_report
1746+#: code:addons/account_financial_report/model/account_financial_report.py:77
1747+#, python-format
1748+msgid "Copy of %s"
1749+msgstr "Copia de %s"
1750+
1751+#. module: account_financial_report
1752+#: field:afr,account_ids:0
1753+#: field:wizard.report,account_list:0
1754+msgid "Root accounts"
1755+msgstr "Cuentas raíces"
1756+
1757+#. module: account_financial_report
1758+#: report:afr.5cols:0
1759+#: report:afr.analytic.ledger:0
1760+msgid "PERIOD"
1761+msgstr "PERIODO"
1762+
1763+#. module: account_financial_report
1764+#: selection:afr,display_account:0
1765+#: selection:wizard.report,display_account:0
1766+msgid "With Balance"
1767+msgstr "Con Balance"
1768+
1769+#. module: account_financial_report
1770+#: report:afr.13cols:0
1771+msgid "12"
1772+msgstr "12"
1773+
1774+#. module: account_financial_report
1775+#: selection:afr,filter:0
1776+#: selection:wizard.report,filter:0
1777+msgid "By Date"
1778+msgstr "Por Fecha"
1779+
1780+#. module: account_financial_report
1781+#: code:addons/account_financial_report/wizard/wizard.py:242
1782+#, python-format
1783+msgid "La interseccion entre el periodo y fecha es vacio"
1784+msgstr "La interseccion entre el periodo y fecha es vacio"
1785+
1786+#. module: account_financial_report
1787+#: view:afr:0
1788+#: view:wizard.report:0
1789+msgid "Company Info"
1790+msgstr "Información de la Compañía"
1791+
1792+#. module: account_financial_report
1793+#: code:addons/account_financial_report/report/parser.py:344
1794+#: code:addons/account_financial_report/wizard/wizard.py:189
1795+#: code:addons/account_financial_report/wizard/wizard.py:193
1796+#, python-format
1797+msgid "UserError"
1798+msgstr "UserError"
1799+
1800+#. module: account_financial_report
1801+#: report:afr.analytic.ledger:0
1802+msgid "JOURNAL ENTRY"
1803+msgstr "ASIENTO DIARIO"
1804+
1805+#. module: account_financial_report
1806+#: report:afr.2cols:0
1807+#: report:afr.4cols:0
1808+#: report:afr.5cols:0
1809+#: report:afr.analytic.ledger:0
1810+msgid "CREDIT"
1811+msgstr "CREDITO"
1812+
1813+#. module: account_financial_report
1814+#: view:wizard.report:0
1815+msgid "_Cancel"
1816+msgstr "_Cancelar"
1817+
1818+#. module: account_financial_report
1819+#: view:res.company:0
1820+msgid "Account's Sign on Reports"
1821+msgstr "Signo de las Cuentas en Reportes"
1822+
1823+#. module: account_financial_report
1824+#: model:ir.actions.report.xml,name:account_financial_report.2_col_report
1825+msgid "Balance 2 Columnas"
1826+msgstr "Balance 2 Columnas"
1827+
1828+#. module: account_financial_report
1829+#: selection:afr,columns:0
1830+#: selection:wizard.report,columns:0
1831+msgid "Debit | Credit"
1832+msgstr "Débito | Crédito"
1833+
1834+#. module: account_financial_report
1835+#: view:afr:0
1836+#: view:wizard.report:0
1837+msgid "Please check the [ Account's Sign on Reports ] Section in the Company"
1838+msgstr "Por Favor, Verifique la Sección [ Signo de las Cuentas en Reportes ] en la Compañía"
1839+
1840+#. module: account_financial_report
1841+#: report:afr.13cols:0
1842+#: report:afr.1cols:0
1843+#: report:afr.2cols:0
1844+#: report:afr.4cols:0
1845+#: report:afr.analytic.ledger:0
1846+#: report:afr.qtrcols:0
1847+msgid "CODE"
1848+msgstr "CÓDIGO"
1849+
1850+#. module: account_financial_report
1851+#: view:res.company:0
1852+msgid "A debitable account is one which grows in the debit and diminishes in the credit"
1853+msgstr "Una cuenta debitable es una que crece por el débito y disminuye por el crédito."
1854+
1855+#. module: account_financial_report
1856+#: report:afr.5cols:0
1857+msgid "(Expressed in"
1858+msgstr "(Expresado en"
1859+
1860+#. module: account_financial_report
1861+#: report:afr.4cols:0
1862+#: report:afr.analytic.ledger:0
1863+msgid "INITIAL"
1864+msgstr "INICIAL"
1865+
1866+#. module: account_financial_report
1867+#: field:wizard.report,afr_id:0
1868+msgid "Custom Report"
1869+msgstr "Reporte Personalizado"
1870+
1871+#. module: account_financial_report
1872+#: field:afr,date_from:0
1873+#: field:wizard.report,date_from:0
1874+msgid "Start date"
1875+msgstr "Fecha Inicial"
1876+
1877+#. module: account_financial_report
1878+#: view:afr:0
1879+#: view:wizard.report:0
1880+msgid "Accounts to Include"
1881+msgstr "Cuentas a incluir"
1882+
1883+#. module: account_financial_report
1884+#: code:addons/account_financial_report/report/parser.py:100
1885+#: code:addons/account_financial_report/report/parser.py:109
1886+#, python-format
1887+msgid " to "
1888+msgstr " hasta "
1889+
1890+#. module: account_financial_report
1891+#: report:afr.13cols:0
1892+msgid "02"
1893+msgstr "02"
1894+
1895+#. module: account_financial_report
1896+#: report:afr.13cols:0
1897+msgid "03"
1898+msgstr "03"
1899+
1900+#. module: account_financial_report
1901+#: report:afr.13cols:0
1902+msgid "01"
1903+msgstr "01"
1904+
1905+#. module: account_financial_report
1906+#: report:afr.13cols:0
1907+msgid "06"
1908+msgstr "06"
1909+
1910+#. module: account_financial_report
1911+#: report:afr.13cols:0
1912+msgid "07"
1913+msgstr "07"
1914+
1915+#. module: account_financial_report
1916+#: report:afr.13cols:0
1917+msgid "04"
1918+msgstr "04"
1919+
1920+#. module: account_financial_report
1921+#: report:afr.13cols:0
1922+msgid "05"
1923+msgstr "05"
1924+
1925+#. module: account_financial_report
1926+#: report:afr.13cols:0
1927+msgid "08"
1928+msgstr "08"
1929+
1930+#. module: account_financial_report
1931+#: report:afr.13cols:0
1932+msgid "09"
1933+msgstr "09"
1934+
1935+#. module: account_financial_report
1936+#: view:afr:0
1937+#: model:ir.ui.menu,name:account_financial_report.account_financial_report_menu
1938+msgid "Account Financial Report (Templates)"
1939+msgstr "Reportes Financieros (Plantillas)"
1940+
1941+#. module: account_financial_report
1942+#: field:afr,fiscalyear_id:0
1943+#: field:wizard.report,fiscalyear:0
1944+msgid "Fiscal year"
1945+msgstr "Ejercicio Fiscal"
1946+
1947+#. module: account_financial_report
1948+#: model:ir.actions.act_window,help:account_financial_report.account_financial_report_action
1949+msgid "Create your own Customized Account Financial Reports, in here, you will be able to create Templates for generating Two types of Reports: Balance Sheets and Income Statements, incluiding Analytic Ledgers. Besides, you can select within a set of choices to get better detailed report, be it that you ask it by one or several periods, by months (12 Months + YTD), or by quarters (4QRT's + YTD). Even you can get your reports in currencies other than the one set on your company."
1950+msgstr "Cree sus propios Reportes Financieros Personalizados, aquí, Vd. podrá se capaz de Diseñar las Plantillas para la generación de Dos Tipos de Reportes: Balances Generales y Estados de Resultados, incluyendo Mayores Analíticos. Además, podrá seleccionar entre un conjunto de opciones para obtener un mejor reporte detallado, sea que lo pida para un período determinado, por meses (12 MESES + YTD) o por trimestres (4to's + YTD). Incluso puede obtener reportes en otras monedas distintas a la establecida en su compañia."
1951+
1952+#. module: account_financial_report
1953+#: field:res.company,credit_account_ids:0
1954+msgid "Creditable Accounts"
1955+msgstr "Cuentas Acreditables"
1956+
1957+#. module: account_financial_report
1958+#: code:addons/account_financial_report/report/parser.py:344
1959+#, python-format
1960+msgid "The Selected Fiscal Year Does not have Regular Periods"
1961+msgstr "El Ejercicio Fiscal Seleccionado no tiene Períodos Regulares"
1962+
1963+#. module: account_financial_report
1964+#: report:afr.13cols:0
1965+#: report:afr.5cols:0
1966+#: report:afr.qtrcols:0
1967+msgid "YTD"
1968+msgstr "YTD"
1969+
1970+#. module: account_financial_report
1971+#: view:afr:0
1972+#: view:wizard.report:0
1973+msgid "Periods to Include"
1974+msgstr "Períodos a incluir"
1975+
1976+#. module: account_financial_report
1977+#: selection:afr,display_account:0
1978+#: selection:wizard.report,display_account:0
1979+msgid "With movements"
1980+msgstr "Con Movimientos"
1981+
1982+#. module: account_financial_report
1983+#: field:afr,currency_id:0
1984+#: field:wizard.report,currency_id:0
1985+msgid "Currency"
1986+msgstr "Moneda"
1987+
1988+#. module: account_financial_report
1989+#: field:afr,display_account:0
1990+#: field:wizard.report,display_account:0
1991+msgid "Display accounts"
1992+msgstr "Mostrar cuentas"
1993+
1994+#. module: account_financial_report
1995+#: field:afr,display_account_level:0
1996+#: field:wizard.report,display_account_level:0
1997+msgid "Up to level"
1998+msgstr "Hasta nivel"
1999+
2000+#. module: account_financial_report
2001+#: report:afr.analytic.ledger:0
2002+msgid "PARTNER"
2003+msgstr "PARTNER"
2004+
2005+#. module: account_financial_report
2006+#: help:afr,currency_id:0
2007+#: help:wizard.report,currency_id:0
2008+msgid "Currency at which this report will be expressed. If not selected will be used the one set in the company"
2009+msgstr "Moneda con la cual este reporte será expresado. Si no se selecciona se usará la que está establecida en la compañía"
2010+
2011+#. module: account_financial_report
2012+#: report:afr.13cols:0
2013+#: report:afr.1cols:0
2014+#: report:afr.2cols:0
2015+#: report:afr.4cols:0
2016+#: report:afr.5cols:0
2017+#: report:afr.analytic.ledger:0
2018+#: report:afr.qtrcols:0
2019+msgid "ACCOUNT"
2020+msgstr "CUENTA"
2021+
2022+#. module: account_financial_report
2023+#: report:afr.analytic.ledger:0
2024+msgid "Pag.:"
2025+msgstr "Pág.:"
2026+
2027+#. module: account_financial_report
2028+#: report:afr.2cols:0
2029+#: report:afr.4cols:0
2030+#: report:afr.5cols:0
2031+#: report:afr.analytic.ledger:0
2032+msgid "DEBIT"
2033+msgstr "DÉBITO"
2034+
2035+#. module: account_financial_report
2036+#: field:afr,columns:0
2037+#: field:wizard.report,columns:0
2038+msgid "Columns"
2039+msgstr "Columnas"
2040+
2041+#. module: account_financial_report
2042+#: report:afr.analytic.ledger:0
2043+msgid "REFERENCE"
2044+msgstr "REFERENCIA"
2045+
2046+#. module: account_financial_report
2047+#: selection:afr,filter:0
2048+#: selection:wizard.report,filter:0
2049+msgid "By Period"
2050+msgstr "Por Período"
2051+
2052+#. module: account_financial_report
2053+#: selection:afr,columns:0
2054+#: selection:wizard.report,columns:0
2055+msgid "4 QTR's | YTD"
2056+msgstr "4 TRM's | YTD"
2057+
2058+#. module: account_financial_report
2059+#: model:ir.actions.act_window,name:account_financial_report.action_wizard_report
2060+#: model:ir.ui.menu,name:account_financial_report.menu_wizard_report
2061+msgid "Account Financial Report (Multireports)"
2062+msgstr "Reportes Financieros (Multireportes)"
2063+
2064+#. module: account_financial_report
2065+#: view:afr:0
2066+#: view:wizard.report:0
2067+msgid "Accounts Info"
2068+msgstr "Información de Cuentas"
2069+
2070+#. module: account_financial_report
2071+#: help:afr,display_account_level:0
2072+#: help:wizard.report,display_account_level:0
2073+msgid "Display accounts up to this level (0 to show all)"
2074+msgstr "Se mostrarán las cuentas hasta este nivel (Seleccionar 0 las mostrará todas)"
2075+
2076+#. module: account_financial_report
2077+#: model:ir.model,name:account_financial_report.model_res_company
2078+msgid "Companies"
2079+msgstr "Compañías"
2080+
2081+#. module: account_financial_report
2082+#: help:afr,fiscalyear_id:0
2083+#: help:wizard.report,fiscalyear:0
2084+msgid "Fiscal Year for this report"
2085+msgstr "Ejercicio Fiscal para este reporte"
2086+
2087+#. module: account_financial_report
2088+#: code:addons/account_financial_report/report/parser.py:87
2089+#: selection:afr,inf_type:0
2090+#: selection:wizard.report,inf_type:0
2091+#, python-format
2092+msgid "Income Statement"
2093+msgstr "Estado de Resultados"
2094+
2095+#. module: account_financial_report
2096+#: report:afr.13cols:0
2097+#: report:afr.1cols:0
2098+#: report:afr.2cols:0
2099+#: report:afr.4cols:0
2100+#: report:afr.5cols:0
2101+#: report:afr.qtrcols:0
2102+msgid "/ Pág.:"
2103+msgstr "/ Pág.:"
2104+
2105+#. module: account_financial_report
2106+#: model:ir.actions.act_window,name:account_financial_report.account_financial_report_action
2107+#: model:res.groups,name:account_financial_report.group_afreport
2108+#: view:wizard.report:0
2109+msgid "Account Financial Report"
2110+msgstr "Reportes Financieros"
2111+
2112+#. module: account_financial_report
2113+#: report:afr.13cols:0
2114+msgid "11"
2115+msgstr "11"
2116+
2117+#. module: account_financial_report
2118+#: report:afr.13cols:0
2119+msgid "10"
2120+msgstr "10"
2121+
2122+#. module: account_financial_report
2123+#: report:afr.5cols:0
2124+msgid "Code"
2125+msgstr "Código"
2126+
2127+#. module: account_financial_report
2128+#: model:ir.actions.report.xml,name:account_financial_report.1_col_report
2129+msgid "Balance 1 Columna"
2130+msgstr "Balance 1 Columna"
2131+
2132+#. module: account_financial_report
2133+#: view:wizard.report:0
2134+msgid "Print"
2135+msgstr "Imprimir"
2136+
2137+#. module: account_financial_report
2138+#: field:afr,filter:0
2139+#: field:wizard.report,filter:0
2140+msgid "Date/Period Filter"
2141+msgstr "Filtro Fecha/Período"
2142+
2143+#. module: account_financial_report
2144+#: view:afr:0
2145+#: view:wizard.report:0
2146+msgid "FiscalYear Info"
2147+msgstr "Información del Ejercicio Fiscal"
2148+
2149+#. module: account_financial_report
2150+#: selection:afr,columns:0
2151+#: selection:wizard.report,columns:0
2152+msgid "Initial | Debit | Credit | YTD"
2153+msgstr "Inicial | Débito | Crédito | YTD"
2154+
2155+#. module: account_financial_report
2156+#: field:afr,period_ids:0
2157+#: field:wizard.report,periods:0
2158+msgid "Periods"
2159+msgstr "Períodos"
2160+
2161+#. module: account_financial_report
2162+#: report:afr.qtrcols:0
2163+msgid "Q1"
2164+msgstr "Q1"
2165+
2166+#. module: account_financial_report
2167+#: report:afr.qtrcols:0
2168+msgid "Q3"
2169+msgstr "Q3"
2170+
2171+#. module: account_financial_report
2172+#: report:afr.qtrcols:0
2173+msgid "Q2"
2174+msgstr "Q2"
2175+
2176+#. module: account_financial_report
2177+#: report:afr.qtrcols:0
2178+msgid "Q4"
2179+msgstr "Q4"
2180+
2181+#. module: account_financial_report
2182+#: help:afr,analytic_ledger:0
2183+#: help:wizard.report,analytic_ledger:0
2184+msgid "Allows to Generate an Analytic Ledger for accounts with moves. Available when Balance Sheet and 'Initial | Debit | Credit | YTD' are selected"
2185+msgstr "Permite generar un Mayor Analítico para las cuentas con movimientos. Disponible cuando se selecciona 'Balance General' e 'Inicial | Débito | Crédito | YTD'"
2186+
2187+#. module: account_financial_report
2188+#: help:wizard.report,afr_id:0
2189+msgid "If you have already set a Custom Report, Select it Here."
2190+msgstr "Si ya ha configurado un Reporte Personalizado, Selecciónelo Aquí."
2191+
2192+#. module: account_financial_report
2193+#: selection:afr,columns:0
2194+#: selection:wizard.report,columns:0
2195+msgid "Initial | Debit | Credit | Period | YTD"
2196+msgstr "Inicial | Débito | Crédito | Período | YTD"
2197+
2198+#. module: account_financial_report
2199+#: selection:afr,columns:0
2200+#: selection:wizard.report,columns:0
2201+msgid "End. Balance"
2202+msgstr "Bal. Final"
2203+
2204+#. module: account_financial_report
2205+#: report:afr.analytic.ledger:0
2206+msgid "DATE"
2207+msgstr "FECHA"
2208+
2209+#. module: account_financial_report
2210+#: view:res.company:0
2211+msgid "Keep sign on Reports for these accounts and children accounts that are within Accreditable Accounts"
2212+msgstr "Mantiene el signo en los reportes para estas cuentas y las cuentas hijas que están dentro de las Cuentas Acreditables"
2213+
2214+#. module: account_financial_report
2215+#: code:addons/account_financial_report/report/parser.py:100
2216+#: code:addons/account_financial_report/report/parser.py:109
2217+#, python-format
2218+msgid "From "
2219+msgstr "Desde "
2220+
2221+#. module: account_financial_report
2222+#: field:afr,inf_type:0
2223+#: field:wizard.report,inf_type:0
2224+msgid "Type"
2225+msgstr "Tipo"
2226+
2227+#. module: account_financial_report
2228+#: field:afr,date_to:0
2229+#: field:wizard.report,date_to:0
2230+msgid "End date"
2231+msgstr "Fecha final"
2232+
2233+#. module: account_financial_report
2234+#: view:afr:0
2235+#: view:wizard.report:0
2236+msgid "Account's Sign Conventions"
2237+msgstr "Convención de Signos de las Cuentas"
2238+
2239+#. module: account_financial_report
2240+#: model:ir.actions.report.xml,name:account_financial_report.13_col_report
2241+msgid "Balance 13 Columnas"
2242+msgstr "Balance 13 Columnas"
2243+
2244+#. module: account_financial_report
2245+#: view:res.company:0
2246+msgid "Accreditable Accounts"
2247+msgstr "Cuentas Acreditables"
2248+
2249+#. module: account_financial_report
2250+#: model:ir.model,name:account_financial_report.model_afr
2251+msgid "afr"
2252+msgstr "afr"
2253+
2254+#. module: account_financial_report
2255+#: field:afr,name:0
2256+msgid "Name"
2257+msgstr "Nombre"
2258+
2259+#. module: account_financial_report
2260+#: code:addons/account_financial_report/report/parser.py:83
2261+#: field:afr,analytic_ledger:0
2262+#: model:ir.actions.report.xml,name:account_financial_report.analytic_ledger_report
2263+#: field:wizard.report,analytic_ledger:0
2264+#, python-format
2265+msgid "Analytic Ledger"
2266+msgstr "Mayor Analítico"
2267+
2268+#. module: account_financial_report
2269+#: view:res.company:0
2270+#: field:res.company,debit_account_ids:0
2271+msgid "Debitable Accounts"
2272+msgstr "Cuentas Debitables"
2273+
2274+#. module: account_financial_report
2275+#: help:afr,period_ids:0
2276+#: help:wizard.report,periods:0
2277+msgid "All periods in the fiscal year if empty"
2278+msgstr "Todos los períodos en el ejercicio fiscal si se deja vacío"
2279+
2280+#. module: account_financial_report
2281+#: code:addons/account_financial_report/wizard/wizard.py:179
2282+#: code:addons/account_financial_report/wizard/wizard.py:242
2283+#, python-format
2284+msgid "Error !"
2285+msgstr "Error !"
2286+
2287+#. module: account_financial_report
2288+#: model:ir.model,name:account_financial_report.model_wizard_report
2289+msgid "wizard.report"
2290+msgstr "wizard.report"
2291+
2292+#. module: account_financial_report
2293+#: field:afr,lab_str:0
2294+#: field:wizard.report,lab_str:0
2295+msgid "Description"
2296+msgstr "Descripción"
2297+
2298+#. module: account_financial_report
2299+#: view:afr:0
2300+#: view:wizard.report:0
2301+msgid "Report Info"
2302+msgstr "Información del Reporte"
2303+
2304+#. module: account_financial_report
2305+#: selection:afr,display_account:0
2306+#: selection:wizard.report,display_account:0
2307+msgid "All Accounts"
2308+msgstr "Todas las Cuentas"
2309+
2310+#. module: account_financial_report
2311+#: field:afr,tot_check:0
2312+#: field:wizard.report,tot_check:0
2313+msgid "Summarize?"
2314+msgstr "Totalizar?"
2315+
2316+#. module: account_financial_report
2317+#: help:afr,tot_check:0
2318+#: help:wizard.report,tot_check:0
2319+msgid "Checking will add a new line at the end of the Report which will Summarize Columns in Report"
2320+msgstr "Seleccionarlo agregará una nueva línea al final del Reporte el cual Totalizará las Columnas en el Reporte"
2321+
2322+#. module: account_financial_report
2323+#: help:afr,lab_str:0
2324+#: help:wizard.report,lab_str:0
2325+msgid "Description for the Summary"
2326+msgstr "Descripción para el Total"
2327+
2328+#. module: account_financial_report
2329+#: selection:afr,columns:0
2330+#: selection:wizard.report,columns:0
2331+msgid "12 Months | YTD"
2332+msgstr "12 Meses | YTD"
2333+
2334+#. module: account_financial_report
2335+#: view:afr:0
2336+#: view:wizard.report:0
2337+msgid "Total"
2338+msgstr "Total"
2339+
2340
2341=== added file 'account_financial_report/i18n/es_VE.po'
2342--- account_financial_report/i18n/es_VE.po 1970-01-01 00:00:00 +0000
2343+++ account_financial_report/i18n/es_VE.po 2014-08-15 20:07:23 +0000
2344@@ -0,0 +1,687 @@
2345+# Translation of OpenERP Server.
2346+# This file contains the translation of the following modules:
2347+# * account_financial_report
2348+#
2349+msgid ""
2350+msgstr ""
2351+"Project-Id-Version: OpenERP Server 7.0\n"
2352+"Report-Msgid-Bugs-To: \n"
2353+"POT-Creation-Date: 2013-06-17 21:47+0000\n"
2354+"PO-Revision-Date: 2013-06-17 21:47+0000\n"
2355+"Last-Translator: <>\n"
2356+"Language-Team: \n"
2357+"MIME-Version: 1.0\n"
2358+"Content-Type: text/plain; charset=UTF-8\n"
2359+"Content-Transfer-Encoding: \n"
2360+"Plural-Forms: \n"
2361+
2362+#. module: account_financial_report
2363+#: view:res.company:0
2364+msgid "Reverse sign on Reports for these accounts and children accounts that are within Debitable Accounts"
2365+msgstr "Invierte el signo en los reportes para estas cuentas y las cuentas hijas que están dentro de las Cuentas Debitables"
2366+
2367+#. module: account_financial_report
2368+#: selection:afr,filter:0
2369+#: selection:wizard.report,filter:0
2370+msgid "No Filter"
2371+msgstr "Sin Filtro"
2372+
2373+#. module: account_financial_report
2374+#: selection:afr,display_account:0
2375+#: selection:wizard.report,display_account:0
2376+msgid "With Balance / Movements"
2377+msgstr "Con Saldo / Movimientos"
2378+
2379+#. module: account_financial_report
2380+#: model:ir.actions.report.xml,name:account_financial_report.4_col_report
2381+msgid "Balance 4 Columnas"
2382+msgstr "Balance 4 Columnas"
2383+
2384+#. module: account_financial_report
2385+#: view:res.company:0
2386+msgid "An accreditable account is one which grows in the credit and diminishes in the debit"
2387+msgstr "Una cuenta acreditable es una que crece por el crédito y disminuye por el débito."
2388+
2389+#. module: account_financial_report
2390+#: report:afr.1cols:0
2391+#: report:afr.4cols:0
2392+#: report:afr.analytic.ledger:0
2393+msgid "BALANCE"
2394+msgstr "BALANCE"
2395+
2396+#. module: account_financial_report
2397+#: code:addons/account_financial_report/report/parser.py:85
2398+#: selection:afr,inf_type:0
2399+#: selection:wizard.report,inf_type:0
2400+#, python-format
2401+msgid "Balance Sheet"
2402+msgstr "Balance General"
2403+
2404+#. module: account_financial_report
2405+#: field:afr,company_id:0
2406+#: field:wizard.report,company_id:0
2407+msgid "Company"
2408+msgstr "Compañía"
2409+
2410+#. module: account_financial_report
2411+#: code:addons/account_financial_report/wizard/wizard.py:150
2412+#, python-format
2413+msgid "Write a Description for your Summary Total"
2414+msgstr "Escriba una Descripción para el total del Sumario"
2415+
2416+#. module: account_financial_report
2417+#: model:ir.actions.report.xml,name:account_financial_report.5_col_report
2418+msgid "Balance 5 Columnas"
2419+msgstr "Balance 5 Columnas"
2420+
2421+#. module: account_financial_report
2422+#: model:ir.actions.report.xml,name:account_financial_report.qtr_col_report
2423+msgid "Balance QTRs Columnas"
2424+msgstr "Balance QTRs Columnas"
2425+
2426+#. module: account_financial_report
2427+#: report:afr.5cols:0
2428+msgid "INIT. BAL."
2429+msgstr "BAL. INIC."
2430+
2431+#. module: account_financial_report
2432+#: selection:afr,filter:0
2433+#: selection:wizard.report,filter:0
2434+msgid "By Date and Period"
2435+msgstr "Por fecha y período"
2436+
2437+#. module: account_financial_report
2438+#: code:addons/account_financial_report/model/account_financial_report.py:77
2439+#, python-format
2440+msgid "Copy of %s"
2441+msgstr "Copia de %s"
2442+
2443+#. module: account_financial_report
2444+#: field:afr,account_ids:0
2445+#: field:wizard.report,account_list:0
2446+msgid "Root accounts"
2447+msgstr "Cuentas raíces"
2448+
2449+#. module: account_financial_report
2450+#: report:afr.5cols:0
2451+#: report:afr.analytic.ledger:0
2452+msgid "PERIOD"
2453+msgstr "PERIODO"
2454+
2455+#. module: account_financial_report
2456+#: selection:afr,display_account:0
2457+#: selection:wizard.report,display_account:0
2458+msgid "With Balance"
2459+msgstr "Con Balance"
2460+
2461+#. module: account_financial_report
2462+#: report:afr.13cols:0
2463+msgid "12"
2464+msgstr "12"
2465+
2466+#. module: account_financial_report
2467+#: selection:afr,filter:0
2468+#: selection:wizard.report,filter:0
2469+msgid "By Date"
2470+msgstr "Por Fecha"
2471+
2472+#. module: account_financial_report
2473+#: code:addons/account_financial_report/wizard/wizard.py:242
2474+#, python-format
2475+msgid "La interseccion entre el periodo y fecha es vacio"
2476+msgstr "La interseccion entre el periodo y fecha es vacio"
2477+
2478+#. module: account_financial_report
2479+#: view:afr:0
2480+#: view:wizard.report:0
2481+msgid "Company Info"
2482+msgstr "Información de la Compañía"
2483+
2484+#. module: account_financial_report
2485+#: code:addons/account_financial_report/report/parser.py:344
2486+#: code:addons/account_financial_report/wizard/wizard.py:189
2487+#: code:addons/account_financial_report/wizard/wizard.py:193
2488+#, python-format
2489+msgid "UserError"
2490+msgstr "UserError"
2491+
2492+#. module: account_financial_report
2493+#: report:afr.analytic.ledger:0
2494+msgid "JOURNAL ENTRY"
2495+msgstr "ASIENTO DIARIO"
2496+
2497+#. module: account_financial_report
2498+#: report:afr.2cols:0
2499+#: report:afr.4cols:0
2500+#: report:afr.5cols:0
2501+#: report:afr.analytic.ledger:0
2502+msgid "CREDIT"
2503+msgstr "CREDITO"
2504+
2505+#. module: account_financial_report
2506+#: view:wizard.report:0
2507+msgid "_Cancel"
2508+msgstr "_Cancelar"
2509+
2510+#. module: account_financial_report
2511+#: view:res.company:0
2512+msgid "Account's Sign on Reports"
2513+msgstr "Signo de las Cuentas en Reportes"
2514+
2515+#. module: account_financial_report
2516+#: model:ir.actions.report.xml,name:account_financial_report.2_col_report
2517+msgid "Balance 2 Columnas"
2518+msgstr "Balance 2 Columnas"
2519+
2520+#. module: account_financial_report
2521+#: selection:afr,columns:0
2522+#: selection:wizard.report,columns:0
2523+msgid "Debit | Credit"
2524+msgstr "Débito | Crédito"
2525+
2526+#. module: account_financial_report
2527+#: view:afr:0
2528+#: view:wizard.report:0
2529+msgid "Please check the [ Account's Sign on Reports ] Section in the Company"
2530+msgstr "Por Favor, Verifique la Sección [ Signo de las Cuentas en Reportes ] en la Compañía"
2531+
2532+#. module: account_financial_report
2533+#: report:afr.13cols:0
2534+#: report:afr.1cols:0
2535+#: report:afr.2cols:0
2536+#: report:afr.4cols:0
2537+#: report:afr.analytic.ledger:0
2538+#: report:afr.qtrcols:0
2539+msgid "CODE"
2540+msgstr "CÓDIGO"
2541+
2542+#. module: account_financial_report
2543+#: view:res.company:0
2544+msgid "A debitable account is one which grows in the debit and diminishes in the credit"
2545+msgstr "Una cuenta debitable es una que crece por el débito y disminuye por el crédito."
2546+
2547+#. module: account_financial_report
2548+#: report:afr.5cols:0
2549+msgid "(Expressed in"
2550+msgstr "(Expresado en"
2551+
2552+#. module: account_financial_report
2553+#: report:afr.4cols:0
2554+#: report:afr.analytic.ledger:0
2555+msgid "INITIAL"
2556+msgstr "INICIAL"
2557+
2558+#. module: account_financial_report
2559+#: field:wizard.report,afr_id:0
2560+msgid "Custom Report"
2561+msgstr "Reporte Personalizado"
2562+
2563+#. module: account_financial_report
2564+#: field:afr,date_from:0
2565+#: field:wizard.report,date_from:0
2566+msgid "Start date"
2567+msgstr "Fecha Inicial"
2568+
2569+#. module: account_financial_report
2570+#: view:afr:0
2571+#: view:wizard.report:0
2572+msgid "Accounts to Include"
2573+msgstr "Cuentas a incluir"
2574+
2575+#. module: account_financial_report
2576+#: code:addons/account_financial_report/report/parser.py:100
2577+#: code:addons/account_financial_report/report/parser.py:109
2578+#, python-format
2579+msgid " to "
2580+msgstr " hasta "
2581+
2582+#. module: account_financial_report
2583+#: report:afr.13cols:0
2584+msgid "02"
2585+msgstr "02"
2586+
2587+#. module: account_financial_report
2588+#: report:afr.13cols:0
2589+msgid "03"
2590+msgstr "03"
2591+
2592+#. module: account_financial_report
2593+#: report:afr.13cols:0
2594+msgid "01"
2595+msgstr "01"
2596+
2597+#. module: account_financial_report
2598+#: report:afr.13cols:0
2599+msgid "06"
2600+msgstr "06"
2601+
2602+#. module: account_financial_report
2603+#: report:afr.13cols:0
2604+msgid "07"
2605+msgstr "07"
2606+
2607+#. module: account_financial_report
2608+#: report:afr.13cols:0
2609+msgid "04"
2610+msgstr "04"
2611+
2612+#. module: account_financial_report
2613+#: report:afr.13cols:0
2614+msgid "05"
2615+msgstr "05"
2616+
2617+#. module: account_financial_report
2618+#: report:afr.13cols:0
2619+msgid "08"
2620+msgstr "08"
2621+
2622+#. module: account_financial_report
2623+#: report:afr.13cols:0
2624+msgid "09"
2625+msgstr "09"
2626+
2627+#. module: account_financial_report
2628+#: view:afr:0
2629+#: model:ir.ui.menu,name:account_financial_report.account_financial_report_menu
2630+msgid "Account Financial Report (Templates)"
2631+msgstr "Reportes Financieros (Plantillas)"
2632+
2633+#. module: account_financial_report
2634+#: field:afr,fiscalyear_id:0
2635+#: field:wizard.report,fiscalyear:0
2636+msgid "Fiscal year"
2637+msgstr "Ejercicio Fiscal"
2638+
2639+#. module: account_financial_report
2640+#: model:ir.actions.act_window,help:account_financial_report.account_financial_report_action
2641+msgid "Create your own Customized Account Financial Reports, in here, you will be able to create Templates for generating Two types of Reports: Balance Sheets and Income Statements, incluiding Analytic Ledgers. Besides, you can select within a set of choices to get better detailed report, be it that you ask it by one or several periods, by months (12 Months + YTD), or by quarters (4QRT's + YTD). Even you can get your reports in currencies other than the one set on your company."
2642+msgstr "Cree sus propios Reportes Financieros Personalizados, aquí, Vd. podrá se capaz de Diseñar las Plantillas para la generación de Dos Tipos de Reportes: Balances Generales y Estados de Resultados, incluyendo Mayores Analíticos. Además, podrá seleccionar entre un conjunto de opciones para obtener un mejor reporte detallado, sea que lo pida para un período determinado, por meses (12 MESES + YTD) o por trimestres (4to's + YTD). Incluso puede obtener reportes en otras monedas distintas a la establecida en su compañia."
2643+
2644+#. module: account_financial_report
2645+#: field:res.company,credit_account_ids:0
2646+msgid "Creditable Accounts"
2647+msgstr "Cuentas Acreditables"
2648+
2649+#. module: account_financial_report
2650+#: code:addons/account_financial_report/report/parser.py:344
2651+#, python-format
2652+msgid "The Selected Fiscal Year Does not have Regular Periods"
2653+msgstr "El Ejercicio Fiscal Seleccionado no tiene Períodos Regulares"
2654+
2655+#. module: account_financial_report
2656+#: report:afr.13cols:0
2657+#: report:afr.5cols:0
2658+#: report:afr.qtrcols:0
2659+msgid "YTD"
2660+msgstr "YTD"
2661+
2662+#. module: account_financial_report
2663+#: view:afr:0
2664+#: view:wizard.report:0
2665+msgid "Periods to Include"
2666+msgstr "Períodos a incluir"
2667+
2668+#. module: account_financial_report
2669+#: selection:afr,display_account:0
2670+#: selection:wizard.report,display_account:0
2671+msgid "With movements"
2672+msgstr "Con Movimientos"
2673+
2674+#. module: account_financial_report
2675+#: field:afr,currency_id:0
2676+#: field:wizard.report,currency_id:0
2677+msgid "Currency"
2678+msgstr "Moneda"
2679+
2680+#. module: account_financial_report
2681+#: field:afr,display_account:0
2682+#: field:wizard.report,display_account:0
2683+msgid "Display accounts"
2684+msgstr "Mostrar cuentas"
2685+
2686+#. module: account_financial_report
2687+#: field:afr,display_account_level:0
2688+#: field:wizard.report,display_account_level:0
2689+msgid "Up to level"
2690+msgstr "Hasta nivel"
2691+
2692+#. module: account_financial_report
2693+#: report:afr.analytic.ledger:0
2694+msgid "PARTNER"
2695+msgstr "PARTNER"
2696+
2697+#. module: account_financial_report
2698+#: help:afr,currency_id:0
2699+#: help:wizard.report,currency_id:0
2700+msgid "Currency at which this report will be expressed. If not selected will be used the one set in the company"
2701+msgstr "Moneda con la cual este reporte será expresado. Si no se selecciona se usará la que está establecida en la compañía"
2702+
2703+#. module: account_financial_report
2704+#: report:afr.13cols:0
2705+#: report:afr.1cols:0
2706+#: report:afr.2cols:0
2707+#: report:afr.4cols:0
2708+#: report:afr.5cols:0
2709+#: report:afr.analytic.ledger:0
2710+#: report:afr.qtrcols:0
2711+msgid "ACCOUNT"
2712+msgstr "CUENTA"
2713+
2714+#. module: account_financial_report
2715+#: report:afr.analytic.ledger:0
2716+msgid "Pag.:"
2717+msgstr "Pág.:"
2718+
2719+#. module: account_financial_report
2720+#: report:afr.2cols:0
2721+#: report:afr.4cols:0
2722+#: report:afr.5cols:0
2723+#: report:afr.analytic.ledger:0
2724+msgid "DEBIT"
2725+msgstr "DÉBITO"
2726+
2727+#. module: account_financial_report
2728+#: field:afr,columns:0
2729+#: field:wizard.report,columns:0
2730+msgid "Columns"
2731+msgstr "Columnas"
2732+
2733+#. module: account_financial_report
2734+#: report:afr.analytic.ledger:0
2735+msgid "REFERENCE"
2736+msgstr "REFERENCIA"
2737+
2738+#. module: account_financial_report
2739+#: selection:afr,filter:0
2740+#: selection:wizard.report,filter:0
2741+msgid "By Period"
2742+msgstr "Por Período"
2743+
2744+#. module: account_financial_report
2745+#: selection:afr,columns:0
2746+#: selection:wizard.report,columns:0
2747+msgid "4 QTR's | YTD"
2748+msgstr "4 TRM's | YTD"
2749+
2750+#. module: account_financial_report
2751+#: model:ir.actions.act_window,name:account_financial_report.action_wizard_report
2752+#: model:ir.ui.menu,name:account_financial_report.menu_wizard_report
2753+msgid "Account Financial Report (Multireports)"
2754+msgstr "Reportes Financieros (Multireportes)"
2755+
2756+#. module: account_financial_report
2757+#: view:afr:0
2758+#: view:wizard.report:0
2759+msgid "Accounts Info"
2760+msgstr "Información de Cuentas"
2761+
2762+#. module: account_financial_report
2763+#: help:afr,display_account_level:0
2764+#: help:wizard.report,display_account_level:0
2765+msgid "Display accounts up to this level (0 to show all)"
2766+msgstr "Se mostrarán las cuentas hasta este nivel (Seleccionar 0 las mostrará todas)"
2767+
2768+#. module: account_financial_report
2769+#: model:ir.model,name:account_financial_report.model_res_company
2770+msgid "Companies"
2771+msgstr "Compañías"
2772+
2773+#. module: account_financial_report
2774+#: help:afr,fiscalyear_id:0
2775+#: help:wizard.report,fiscalyear:0
2776+msgid "Fiscal Year for this report"
2777+msgstr "Ejercicio Fiscal para este reporte"
2778+
2779+#. module: account_financial_report
2780+#: code:addons/account_financial_report/report/parser.py:87
2781+#: selection:afr,inf_type:0
2782+#: selection:wizard.report,inf_type:0
2783+#, python-format
2784+msgid "Income Statement"
2785+msgstr "Estado de Resultados"
2786+
2787+#. module: account_financial_report
2788+#: report:afr.13cols:0
2789+#: report:afr.1cols:0
2790+#: report:afr.2cols:0
2791+#: report:afr.4cols:0
2792+#: report:afr.5cols:0
2793+#: report:afr.qtrcols:0
2794+msgid "/ Pág.:"
2795+msgstr "/ Pág.:"
2796+
2797+#. module: account_financial_report
2798+#: model:ir.actions.act_window,name:account_financial_report.account_financial_report_action
2799+#: model:res.groups,name:account_financial_report.group_afreport
2800+#: view:wizard.report:0
2801+msgid "Account Financial Report"
2802+msgstr "Reportes Financieros"
2803+
2804+#. module: account_financial_report
2805+#: report:afr.13cols:0
2806+msgid "11"
2807+msgstr "11"
2808+
2809+#. module: account_financial_report
2810+#: report:afr.13cols:0
2811+msgid "10"
2812+msgstr "10"
2813+
2814+#. module: account_financial_report
2815+#: report:afr.5cols:0
2816+msgid "Code"
2817+msgstr "Código"
2818+
2819+#. module: account_financial_report
2820+#: model:ir.actions.report.xml,name:account_financial_report.1_col_report
2821+msgid "Balance 1 Columna"
2822+msgstr "Balance 1 Columna"
2823+
2824+#. module: account_financial_report
2825+#: view:wizard.report:0
2826+msgid "Print"
2827+msgstr "Imprimir"
2828+
2829+#. module: account_financial_report
2830+#: field:afr,filter:0
2831+#: field:wizard.report,filter:0
2832+msgid "Date/Period Filter"
2833+msgstr "Filtro Fecha/Período"
2834+
2835+#. module: account_financial_report
2836+#: view:afr:0
2837+#: view:wizard.report:0
2838+msgid "FiscalYear Info"
2839+msgstr "Información del Ejercicio Fiscal"
2840+
2841+#. module: account_financial_report
2842+#: selection:afr,columns:0
2843+#: selection:wizard.report,columns:0
2844+msgid "Initial | Debit | Credit | YTD"
2845+msgstr "Inicial | Débito | Crédito | YTD"
2846+
2847+#. module: account_financial_report
2848+#: field:afr,period_ids:0
2849+#: field:wizard.report,periods:0
2850+msgid "Periods"
2851+msgstr "Períodos"
2852+
2853+#. module: account_financial_report
2854+#: report:afr.qtrcols:0
2855+msgid "Q1"
2856+msgstr "Q1"
2857+
2858+#. module: account_financial_report
2859+#: report:afr.qtrcols:0
2860+msgid "Q3"
2861+msgstr "Q3"
2862+
2863+#. module: account_financial_report
2864+#: report:afr.qtrcols:0
2865+msgid "Q2"
2866+msgstr "Q2"
2867+
2868+#. module: account_financial_report
2869+#: report:afr.qtrcols:0
2870+msgid "Q4"
2871+msgstr "Q4"
2872+
2873+#. module: account_financial_report
2874+#: help:afr,analytic_ledger:0
2875+#: help:wizard.report,analytic_ledger:0
2876+msgid "Allows to Generate an Analytic Ledger for accounts with moves. Available when Balance Sheet and 'Initial | Debit | Credit | YTD' are selected"
2877+msgstr "Permite generar un Mayor Analítico para las cuentas con movimientos. Disponible cuando se selecciona 'Balance General' e 'Inicial | Débito | Crédito | YTD'"
2878+
2879+#. module: account_financial_report
2880+#: help:wizard.report,afr_id:0
2881+msgid "If you have already set a Custom Report, Select it Here."
2882+msgstr "Si ya ha configurado un Reporte Personalizado, Selecciónelo Aquí."
2883+
2884+#. module: account_financial_report
2885+#: selection:afr,columns:0
2886+#: selection:wizard.report,columns:0
2887+msgid "Initial | Debit | Credit | Period | YTD"
2888+msgstr "Inicial | Débito | Crédito | Período | YTD"
2889+
2890+#. module: account_financial_report
2891+#: selection:afr,columns:0
2892+#: selection:wizard.report,columns:0
2893+msgid "End. Balance"
2894+msgstr "Bal. Final"
2895+
2896+#. module: account_financial_report
2897+#: report:afr.analytic.ledger:0
2898+msgid "DATE"
2899+msgstr "FECHA"
2900+
2901+#. module: account_financial_report
2902+#: view:res.company:0
2903+msgid "Keep sign on Reports for these accounts and children accounts that are within Accreditable Accounts"
2904+msgstr "Mantiene el signo en los reportes para estas cuentas y las cuentas hijas que están dentro de las Cuentas Acreditables"
2905+
2906+#. module: account_financial_report
2907+#: code:addons/account_financial_report/report/parser.py:100
2908+#: code:addons/account_financial_report/report/parser.py:109
2909+#, python-format
2910+msgid "From "
2911+msgstr "Desde "
2912+
2913+#. module: account_financial_report
2914+#: field:afr,inf_type:0
2915+#: field:wizard.report,inf_type:0
2916+msgid "Type"
2917+msgstr "Tipo"
2918+
2919+#. module: account_financial_report
2920+#: field:afr,date_to:0
2921+#: field:wizard.report,date_to:0
2922+msgid "End date"
2923+msgstr "Fecha final"
2924+
2925+#. module: account_financial_report
2926+#: view:afr:0
2927+#: view:wizard.report:0
2928+msgid "Account's Sign Conventions"
2929+msgstr "Convención de Signos de las Cuentas"
2930+
2931+#. module: account_financial_report
2932+#: model:ir.actions.report.xml,name:account_financial_report.13_col_report
2933+msgid "Balance 13 Columnas"
2934+msgstr "Balance 13 Columnas"
2935+
2936+#. module: account_financial_report
2937+#: view:res.company:0
2938+msgid "Accreditable Accounts"
2939+msgstr "Cuentas Acreditables"
2940+
2941+#. module: account_financial_report
2942+#: model:ir.model,name:account_financial_report.model_afr
2943+msgid "afr"
2944+msgstr "afr"
2945+
2946+#. module: account_financial_report
2947+#: field:afr,name:0
2948+msgid "Name"
2949+msgstr "Nombre"
2950+
2951+#. module: account_financial_report
2952+#: code:addons/account_financial_report/report/parser.py:83
2953+#: field:afr,analytic_ledger:0
2954+#: model:ir.actions.report.xml,name:account_financial_report.analytic_ledger_report
2955+#: field:wizard.report,analytic_ledger:0
2956+#, python-format
2957+msgid "Analytic Ledger"
2958+msgstr "Mayor Analítico"
2959+
2960+#. module: account_financial_report
2961+#: view:res.company:0
2962+#: field:res.company,debit_account_ids:0
2963+msgid "Debitable Accounts"
2964+msgstr "Cuentas Debitables"
2965+
2966+#. module: account_financial_report
2967+#: help:afr,period_ids:0
2968+#: help:wizard.report,periods:0
2969+msgid "All periods in the fiscal year if empty"
2970+msgstr "Todos los períodos en el ejercicio fiscal si se deja vacío"
2971+
2972+#. module: account_financial_report
2973+#: code:addons/account_financial_report/wizard/wizard.py:179
2974+#: code:addons/account_financial_report/wizard/wizard.py:242
2975+#, python-format
2976+msgid "Error !"
2977+msgstr "Error !"
2978+
2979+#. module: account_financial_report
2980+#: model:ir.model,name:account_financial_report.model_wizard_report
2981+msgid "wizard.report"
2982+msgstr "wizard.report"
2983+
2984+#. module: account_financial_report
2985+#: field:afr,lab_str:0
2986+#: field:wizard.report,lab_str:0
2987+msgid "Description"
2988+msgstr "Descripción"
2989+
2990+#. module: account_financial_report
2991+#: view:afr:0
2992+#: view:wizard.report:0
2993+msgid "Report Info"
2994+msgstr "Información del Reporte"
2995+
2996+#. module: account_financial_report
2997+#: selection:afr,display_account:0
2998+#: selection:wizard.report,display_account:0
2999+msgid "All Accounts"
3000+msgstr "Todas las Cuentas"
3001+
3002+#. module: account_financial_report
3003+#: field:afr,tot_check:0
3004+#: field:wizard.report,tot_check:0
3005+msgid "Summarize?"
3006+msgstr "Totalizar?"
3007+
3008+#. module: account_financial_report
3009+#: help:afr,tot_check:0
3010+#: help:wizard.report,tot_check:0
3011+msgid "Checking will add a new line at the end of the Report which will Summarize Columns in Report"
3012+msgstr "Seleccionarlo agregará una nueva línea al final del Reporte el cual Totalizará las Columnas en el Reporte"
3013+
3014+#. module: account_financial_report
3015+#: help:afr,lab_str:0
3016+#: help:wizard.report,lab_str:0
3017+msgid "Description for the Summary"
3018+msgstr "Descripción para el Total"
3019+
3020+#. module: account_financial_report
3021+#: selection:afr,columns:0
3022+#: selection:wizard.report,columns:0
3023+msgid "12 Months | YTD"
3024+msgstr "12 Meses | YTD"
3025+
3026+#. module: account_financial_report
3027+#: view:afr:0
3028+#: view:wizard.report:0
3029+msgid "Total"
3030+msgstr "Total"
3031+
3032
3033=== added directory 'account_financial_report/model'
3034=== added file 'account_financial_report/model/__init__.py'
3035--- account_financial_report/model/__init__.py 1970-01-01 00:00:00 +0000
3036+++ account_financial_report/model/__init__.py 2014-08-15 20:07:23 +0000
3037@@ -0,0 +1,27 @@
3038+#!/usr/bin/python
3039+# -*- encoding: utf-8 -*-
3040+###########################################################################
3041+# Module Writen to OpenERP, Open Source Management Solution
3042+# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
3043+# All Rights Reserved
3044+# Credits######################################################
3045+# Coded by: Humberto Arocha <hbto@vauxoo.com>
3046+# Planified by: Rafael Silva <rsilvam@vauxoo.com>
3047+# Audited by: Nhomar Hernandez <nhomar@vauxoo.com>
3048+#############################################################################
3049+# This program is free software: you can redistribute it and/or modify
3050+# it under the terms of the GNU Affero General Public License as published by
3051+# the Free Software Foundation, either version 3 of the License, or
3052+# (at your option) any later version.
3053+#
3054+# This program is distributed in the hope that it will be useful,
3055+# but WITHOUT ANY WARRANTY; without even the implied warranty of
3056+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
3057+# GNU Affero General Public License for more details.
3058+#
3059+# You should have received a copy of the GNU Affero General Public License
3060+# along with this program. If not, see <http://www.gnu.org/licenses/>.
3061+##########################################################################
3062+
3063+import account_financial_report
3064+import res_company
3065
3066=== added file 'account_financial_report/model/account_financial_report.py'
3067--- account_financial_report/model/account_financial_report.py 1970-01-01 00:00:00 +0000
3068+++ account_financial_report/model/account_financial_report.py 2014-08-15 20:07:23 +0000
3069@@ -0,0 +1,186 @@
3070+# -*- encoding: utf-8 -*-
3071+###########################################################################
3072+# Module Writen to OpenERP, Open Source Management Solution
3073+# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
3074+# All Rights Reserved
3075+# Credits######################################################
3076+# Coded by: Humberto Arocha humberto@openerp.com.ve
3077+# Angelica Barrios angelicaisabelb@gmail.com
3078+# Jordi Esteve <jesteve@zikzakmedia.com>
3079+# Javier Duran <javieredm@gmail.com>
3080+# Planified by: Humberto Arocha
3081+# Finance by: LUBCAN COL S.A.S http://www.lubcancol.com
3082+# Audited by: Humberto Arocha humberto@openerp.com.ve
3083+#############################################################################
3084+# This program is free software: you can redistribute it and/or modify
3085+# it under the terms of the GNU General Public License as published by
3086+# the Free Software Foundation, either version 3 of the License, or
3087+# (at your option) any later version.
3088+#
3089+# This program is distributed in the hope that it will be useful,
3090+# but WITHOUT ANY WARRANTY; without even the implied warranty of
3091+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
3092+# GNU General Public License for more details.
3093+#
3094+# You should have received a copy of the GNU General Public License
3095+# along with this program. If not, see <http://www.gnu.org/licenses/>.
3096+##############################################################################
3097+
3098+from osv import osv, fields
3099+import pooler
3100+import time
3101+from tools.translate import _
3102+
3103+
3104+class account_financial_report(osv.osv):
3105+ _name = "afr"
3106+
3107+ _columns = {
3108+ 'name': fields.char('Name', size=128, required=True),
3109+ 'company_id': fields.many2one('res.company', 'Company', required=True),
3110+ 'currency_id': fields.many2one(
3111+ 'res.currency', 'Currency', help="Currency at which this report will be expressed. If not selected will be used the one set in the company"),
3112+ 'inf_type': fields.selection(
3113+ [('BS', 'Balance Sheet'), ('IS', 'Income Statement')], 'Type', required=True),
3114+ 'columns': fields.selection([('one', 'End. Balance'), ('two', 'Debit | Credit'), ('four', 'Initial | Debit | Credit | YTD'),
3115+ ('five', 'Initial | Debit | Credit | Period | YTD'), ('qtr', "4 QTR's | YTD"), ('thirteen', '12 Months | YTD')], 'Columns', required=True),
3116+ 'display_account': fields.selection([('all', 'All Accounts'), ('bal', 'With Balance'),
3117+ ('mov', 'With movements'), ('bal_mov', 'With Balance / Movements')], 'Display accounts'),
3118+ 'display_account_level': fields.integer(
3119+ 'Up to level', help='Display accounts up to this level (0 to show all)'),
3120+ 'account_ids': fields.many2many(
3121+ 'account.account', 'afr_account_rel', 'afr_id', 'account_id', 'Root accounts', required=True),
3122+ 'fiscalyear_id': fields.many2one(
3123+ 'account.fiscalyear', 'Fiscal year', help='Fiscal Year for this report', required=True),
3124+ 'period_ids': fields.many2many('account.period', 'afr_period_rel', 'afr_id',
3125+ 'period_id', 'Periods', help='All periods in the fiscal year if empty'),
3126+
3127+ 'analytic_ledger': fields.boolean(
3128+ 'Analytic Ledger', help="Allows to Generate an Analytic Ledger for accounts with moves. Available when Balance Sheet and 'Initial | Debit | Credit | YTD' are selected"),
3129+ 'journal_ledger': fields.boolean(
3130+ 'journal Ledger', help="Allows to Generate an journal Ledger for accounts with moves. Available when Balance Sheet and 'Initial | Debit | Credit | YTD' are selected"),
3131+ 'partner_balance': fields.boolean('Partner Balance', help="Allows to "
3132+ "Generate a Partner Balance for accounts with moves. Available when "
3133+ "Balance Sheet and 'Initial | Debit | Credit | YTD' are selected"),
3134+ 'tot_check': fields.boolean(
3135+ 'Summarize?', help='Checking will add a new line at the end of the Report which will Summarize Columns in Report'),
3136+ 'lab_str':
3137+ fields.char(
3138+ 'Description',
3139+ help='Description for the Summary',
3140+ size=128),
3141+ 'target_move': fields.selection([('posted', 'All Posted Entries'),
3142+ ('all', 'All Entries'),
3143+ ], 'Entries to Include', required=True,
3144+ help='Print All Accounting Entries or just Posted Accounting Entries'),
3145+
3146+ #~ Deprecated fields
3147+ 'filter': fields.selection([('bydate', 'By Date'), ('byperiod', 'By Period'),
3148+ ('all', 'By Date and Period'), ('none', 'No Filter')], 'Date/Period Filter'),
3149+ 'date_to': fields.date('End date'),
3150+ 'date_from': fields.date('Start date'),
3151+ }
3152+
3153+ _defaults = {
3154+ 'display_account_level': lambda *a: 0,
3155+ 'inf_type': lambda *a: 'BS',
3156+ 'company_id': lambda self, cr, uid, c:
3157+ self.pool.get(
3158+ 'res.company')._company_default_get(
3159+ cr,
3160+ uid,
3161+ 'account.invoice',
3162+ context=c),
3163+ 'fiscalyear_id': lambda self, cr, uid, c:
3164+ self.pool.get('account.fiscalyear').find(cr, uid),
3165+ 'display_account': lambda *a: 'bal_mov',
3166+ 'columns': lambda *a: 'five',
3167+
3168+ 'date_from': lambda *a: time.strftime('%Y-%m-%d'),
3169+ 'date_to': lambda *a: time.strftime('%Y-%m-%d'),
3170+ 'filter': lambda *a: 'byperiod',
3171+ 'target_move': 'posted',
3172+ }
3173+
3174+ def copy(self, cr, uid, id, defaults, context=None):
3175+ if context is None:
3176+ context = {}
3177+ previous_name = self.browse(cr, uid, id, context=context).name
3178+ new_name = _('Copy of %s') % previous_name
3179+ lst = self.search(cr, uid, [(
3180+ 'name', 'like', new_name)], context=context)
3181+ if lst:
3182+ new_name = '%s (%s)' % (new_name, len(lst) + 1)
3183+ defaults['name'] = new_name
3184+ return (
3185+ super(
3186+ account_financial_report,
3187+ self).copy(
3188+ cr,
3189+ uid,
3190+ id,
3191+ defaults,
3192+ context=context)
3193+ )
3194+
3195+ def onchange_inf_type(self, cr, uid, ids, inf_type, context=None):
3196+ if context is None:
3197+ context = {}
3198+ res = {'value': {}}
3199+
3200+ if inf_type != 'BS':
3201+ res['value'].update({'analytic_ledger': False})
3202+
3203+ return res
3204+
3205+ def onchange_columns(self, cr, uid, ids, columns,
3206+ fiscalyear_id, period_ids, context=None):
3207+ if context is None:
3208+ context = {}
3209+ res = {'value': {}}
3210+
3211+ if columns != 'four':
3212+ res['value'].update({'analytic_ledger': False})
3213+ if columns != 'currency':
3214+ res['value'].update({'analytic_ledger': True})
3215+ if columns in ('qtr', 'thirteen'):
3216+ p_obj = self.pool.get("account.period")
3217+ period_ids = p_obj.search(cr, uid, [('fiscalyear_id', '=', fiscalyear_id), (
3218+ 'special', '=', False)], context=context)
3219+ res['value'].update({'period_ids': period_ids})
3220+ else:
3221+ res['value'].update({'period_ids': []})
3222+ return res
3223+
3224+ def onchange_analytic_ledger(
3225+ self, cr, uid, ids, company_id, analytic_ledger, context=None):
3226+ if context is None:
3227+ context = {}
3228+ context['company_id'] = company_id
3229+ res = {'value': {}}
3230+ cur_id = self.pool.get('res.company').browse(
3231+ cr, uid, company_id, context=context).currency_id.id
3232+ res['value'].update({'currency_id': cur_id})
3233+ return res
3234+
3235+ def onchange_company_id(self, cr, uid, ids, company_id, context=None):
3236+ if context is None:
3237+ context = {}
3238+ context['company_id'] = company_id
3239+ res = {'value': {}}
3240+
3241+ if not company_id:
3242+ return res
3243+
3244+ cur_id = self.pool.get('res.company').browse(
3245+ cr, uid, company_id, context=context).currency_id.id
3246+ fy_id = self.pool.get('account.fiscalyear').find(
3247+ cr, uid, context=context)
3248+ res['value'].update({'fiscalyear_id': fy_id})
3249+ res['value'].update({'currency_id': cur_id})
3250+ res['value'].update({'account_ids': []})
3251+ res['value'].update({'period_ids': []})
3252+ return res
3253+
3254+
3255+account_financial_report()
3256
3257=== added file 'account_financial_report/model/res_company.py'
3258--- account_financial_report/model/res_company.py 1970-01-01 00:00:00 +0000
3259+++ account_financial_report/model/res_company.py 2014-08-15 20:07:23 +0000
3260@@ -0,0 +1,43 @@
3261+#!/usr/bin/python
3262+# -*- encoding: utf-8 -*-
3263+###########################################################################
3264+# Module Writen to OpenERP, Open Source Management Solution
3265+# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
3266+# All Rights Reserved
3267+# Credits######################################################
3268+# Coded by: Humberto Arocha <hbto@vauxoo.com>
3269+# Planified by: Rafael Silva <rsilvam@vauxoo.com>
3270+# Audited by: Nhomar Hernandez <nhomar@vauxoo.com>
3271+#############################################################################
3272+# This program is free software: you can redistribute it and/or modify
3273+# it under the terms of the GNU Affero General Public License as published by
3274+# the Free Software Foundation, either version 3 of the License, or
3275+# (at your option) any later version.
3276+#
3277+# This program is distributed in the hope that it will be useful,
3278+# but WITHOUT ANY WARRANTY; without even the implied warranty of
3279+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
3280+# GNU Affero General Public License for more details.
3281+#
3282+# You should have received a copy of the GNU Affero General Public License
3283+# along with this program. If not, see <http://www.gnu.org/licenses/>.
3284+##########################################################################
3285+
3286+from osv import osv
3287+from osv import fields
3288+from tools.translate import _
3289+
3290+
3291+class res_company(osv.osv):
3292+ _inherit = 'res.company'
3293+ _columns = {
3294+ 'credit_account_ids': fields.many2many('account.account',
3295+ 'credit_account_company_rel',
3296+ 'company_id', 'account_id',
3297+ 'Creditable Accounts'),
3298+ 'debit_account_ids': fields.many2many('account.account',
3299+ 'debit_account_company_rel',
3300+ 'company_id', 'account_id',
3301+ 'Debitable Accounts'),
3302+ }
3303+res_company()
3304
3305=== added directory 'account_financial_report/report'
3306=== added file 'account_financial_report/report/__init__.py'
3307--- account_financial_report/report/__init__.py 1970-01-01 00:00:00 +0000
3308+++ account_financial_report/report/__init__.py 2014-08-15 20:07:23 +0000
3309@@ -0,0 +1,28 @@
3310+# -*- encoding: utf-8 -*-
3311+###########################################################################
3312+# Module Writen to OpenERP, Open Source Management Solution
3313+# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
3314+# All Rights Reserved
3315+# Credits######################################################
3316+# Coded by: Humberto Arocha humberto@openerp.com.ve
3317+# Angelica Barrios angelicaisabelb@gmail.com
3318+# Jordi Esteve <jesteve@zikzakmedia.com>
3319+# Planified by: Humberto Arocha
3320+# Finance by: LUBCAN COL S.A.S http://www.lubcancol.com
3321+# Audited by: Humberto Arocha humberto@openerp.com.ve
3322+#############################################################################
3323+# This program is free software: you can redistribute it and/or modify
3324+# it under the terms of the GNU General Public License as published by
3325+# the Free Software Foundation, either version 3 of the License, or
3326+# (at your option) any later version.
3327+#
3328+# This program is distributed in the hope that it will be useful,
3329+# but WITHOUT ANY WARRANTY; without even the implied warranty of
3330+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
3331+# GNU General Public License for more details.
3332+#
3333+# You should have received a copy of the GNU General Public License
3334+# along with this program. If not, see <http://www.gnu.org/licenses/>.
3335+##############################################################################
3336+
3337+import parser
3338
3339=== added file 'account_financial_report/report/balance_full.rml'
3340--- account_financial_report/report/balance_full.rml 1970-01-01 00:00:00 +0000
3341+++ account_financial_report/report/balance_full.rml 2014-08-15 20:07:23 +0000
3342@@ -0,0 +1,131 @@
3343+<?xml version="1.0"?>
3344+<document filename="test.pdf">
3345+ <template pageSize="(21.59cm,27.94cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
3346+ <pageTemplate id="first">
3347+ <frame id="first" x1="1cm" y1="1.0cm" width="19.0cm" height="23cm"/>
3348+ <pageGraphics>
3349+ <setFont name="Helvetica-Oblique" size="6"/>
3350+
3351+ <image x="1.0cm" y="24.0cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
3352+<!--
3353+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
3354+-->
3355+ <place x="-3.5cm" y="22.50cm" width="19cm" height="5.0cm">
3356+ <blockTable colWidths="9.6cm,9.4cm" style="TITLE">
3357+ <tr>
3358+ <td><para style="TOP_TITLE"></para></td>
3359+ <td><para style="TITLE_CENTER_NAME">
3360+ <font>[[ (company.name and company.name or 'NOMBRE DE COMPANIA NO DISPONIBLE')]]</font>
3361+ <font>[[ get_vat_by_country(data['form']) ]]</font>
3362+ </para></td>
3363+ </tr>
3364+ <tr>
3365+ <td><para style="TOP_TITLE"></para></td>
3366+ <td><para style="TITLE_CENTER">(Expressed in [[data['form'] and ('%s'%( exchange_name(data['form']))) or '']])</para></td>
3367+ </tr>
3368+ <tr>
3369+ <td><para style="TOP_TITLE"></para></td>
3370+ <td><para style="TITLE_CENTER">[[data['form'] and get_month(data['form']) or '']]</para></td>
3371+ </tr>
3372+ </blockTable>
3373+ </place>
3374+ <drawRightString x="207mm" y="5mm">Printing Date: [[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time=True) ]] [[ get_informe_text(data['form']) ]] / Pág.: <pageNumber/>-<pageCount/></drawRightString>
3375+
3376+ </pageGraphics>
3377+
3378+ </pageTemplate>
3379+ </template>
3380+ <stylesheet>
3381+ <blockTableStyle id="BODY">
3382+ <blockValign value="TOP"/>
3383+ <blockAlignment value="RIGHT"/>
3384+ <blockTopPadding length="1.0"/>
3385+ <blockBottomPadding length="1.0"/>
3386+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,1" stop="-1,-1" thickness='0.25'/>
3387+ </blockTableStyle>
3388+ <blockTableStyle id="TITLE">
3389+ <blockValign value="TOP"/>
3390+ </blockTableStyle>
3391+ <blockTableStyle id="BODY_STRIKE">
3392+ <blockValign value="TOP"/>
3393+ <blockAlignment value="RIGHT"/>
3394+ <blockTopPadding length="1.0"/>
3395+ <blockBottomPadding length="1.0"/>
3396+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,1" stop="-1,-1" thickness='0.5'/>
3397+ </blockTableStyle>
3398+ <blockTableStyle id="TOP_TABLE">
3399+ <blockAlignment value="LEFT"/>
3400+ <blockValign value="TOP"/>
3401+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1" thickness='0.25'/>
3402+ </blockTableStyle>
3403+
3404+ <initialize>
3405+ <paraStyle name="all" alignment="justify"/>
3406+ </initialize>
3407+ <paraStyle
3408+ name="TITLE_LEFT_ALIGN"
3409+ fontName="Helvetica-Bold"
3410+ fontSize="8.0"
3411+ leading="10"
3412+ alignment="RIGHT"
3413+ spaceBefore="0.0"
3414+ spaceAfter="0.0"/>
3415+ <paraStyle
3416+ name="TOP_TITLE"
3417+ fontName="Helvetica-Bold"
3418+ fontSize="9"
3419+ leftIndent="0.0"
3420+ alignment="LEFT"/>
3421+ <paraStyle name="TITLE_CENTER" fontName="Helvetica-Bold" fontSize="9" leading="10" leftIndent="0.0" alignment="CENTER"/>
3422+ <paraStyle name="TITLE_CENTER_NAME" fontName="Helvetica-Bold" fontSize="12" leading="13" leftIndent="0.0" alignment="CENTER"/>
3423+ <paraStyle name="TITLES"
3424+ fontName="Helvetica-Bold"
3425+ fontSize="8.0"
3426+ leading="10"
3427+ alignment="LEFT"
3428+ spaceBefore="0.0"
3429+ spaceAfter="0.0"/>
3430+ <paraStyle name="TITLE" alignment="CENTER" fontName="Helvetica" fontSize="18.0" leading="20" spaceBefore="-3.0" textColor="black"/>
3431+ </stylesheet>
3432+ <images/>
3433+ <story>
3434+ <para>[[setLang(user.lang)]]</para>
3435+
3436+ <blockTable colWidths="2.5cm,13.5cm,3.0cm" style="BODY" repeatRows="1">
3437+ <tr noRowsplits="1">
3438+ <td>
3439+ <para style="TITLE_LEFT_ALIGN">
3440+ <font>[[ setTag('para','para',{'alignment':"RIGHT"}) ]]</font>
3441+ <font>CODE</font>
3442+ </para>
3443+ </td>
3444+ <td>
3445+ <para style="TITLES">ACCOUNT</para>
3446+ </td>
3447+ <td>
3448+ <para style="TITLE_LEFT_ALIGN">BALANCE</para>
3449+ </td>
3450+ </tr>
3451+ <tr>
3452+ <td>
3453+ <para style="TITLE_LEFT_ALIGN">[[ repeatIn(lines(data['form']), 'a') ]]
3454+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3455+ <i>[[a['label']==True and a['code'] or '' ]]</i>
3456+ </para>
3457+ </td>
3458+ <td>
3459+ <para style="TITLES">
3460+ <font>[[ ((a['total'] and not a['label']) and setTag('para','para',{'alignment':"RIGHT"}) or (a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}))) or removeParentNode('font') ]]</font>
3461+ <font>[[ a['type']=='view' and a['name'].upper() or a['name'].title() ]]</font>
3462+ </para>
3463+ </td>
3464+ <td>
3465+ <para style="TITLE_LEFT_ALIGN">
3466+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3467+ <font>[[ (a['total']==True) and formatLang(a['balance'] and a['balance'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3468+ </para>
3469+ </td>
3470+ </tr>
3471+ </blockTable>
3472+ </story>
3473+</document>
3474
3475=== added file 'account_financial_report/report/balance_full_13_cols.rml'
3476--- account_financial_report/report/balance_full_13_cols.rml 1970-01-01 00:00:00 +0000
3477+++ account_financial_report/report/balance_full_13_cols.rml 2014-08-15 20:07:23 +0000
3478@@ -0,0 +1,235 @@
3479+<?xml version="1.0"?>
3480+<document filename="test.pdf">
3481+ <template pageSize="(43.18cm,27.94cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
3482+ <pageTemplate id="first">
3483+ <frame id="first" x1="0.5cm" y1="1.0cm" width="41.0cm" height="23cm"/>
3484+ <pageGraphics>
3485+ <setFont name="Helvetica-Oblique" size="6"/>
3486+
3487+ <image x="1.0cm" y="24.0cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
3488+<!--
3489+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
3490+-->
3491+
3492+ <place x="-3.5cm" y="22.50cm" width="19cm" height="5.0cm">
3493+ <blockTable colWidths="9.6cm,9.4cm" style="TITLE">
3494+ <tr>
3495+ <td><para style="TOP_TITLE"></para></td>
3496+ <td><para style="TITLE_CENTER_NAME">
3497+ <font>[[ (company.name and company.name or 'NOMBRE DE COMPANIA NO DISPONIBLE')]]</font>
3498+ <font>[[ get_vat_by_country(data['form']) ]]</font>
3499+ </para></td>
3500+ </tr>
3501+ <tr>
3502+ <td><para style="TOP_TITLE"></para></td>
3503+ <td><para style="TITLE_CENTER">[[ get_informe_text(data['form']) ]]</para></td>
3504+ </tr>
3505+ <tr>
3506+ <td><para style="TOP_TITLE"></para></td>
3507+ <td><para style="TITLE_CENTER">(Expressed in [[data['form'] and ('%s'%( exchange_name(data['form']))) or '']])</para></td>
3508+ </tr>
3509+ <tr>
3510+ <td><para style="TOP_TITLE"></para></td>
3511+ <td><para style="TITLE_CENTER">[[data['form'] and get_month(data['form']) or '']]</para></td>
3512+ </tr>
3513+ </blockTable>
3514+ </place>
3515+ <drawRightString x="420mm" y="5mm">Printing Date: [[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time=True) ]] [[ get_informe_text(data['form']) ]] / Pág.: <pageNumber/>-<pageCount/></drawRightString>
3516+ </pageGraphics>
3517+
3518+ </pageTemplate>
3519+ </template>
3520+ <stylesheet>
3521+ <blockTableStyle id="TITLE">
3522+ <blockValign value="TOP"/>
3523+ </blockTableStyle>
3524+ <blockTableStyle id="BODY">
3525+ <blockValign value="TOP"/>
3526+ <blockAlignment value="RIGHT"/>
3527+ <blockTopPadding length="1.0"/>
3528+ <blockBottomPadding length="1.0"/>
3529+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,1" stop="-1,-1" thickness='0.25'/>
3530+ </blockTableStyle>
3531+ <blockTableStyle id="BODY_STRIKE">
3532+ <blockValign value="TOP"/>
3533+ <blockAlignment value="RIGHT"/>
3534+ <blockTopPadding length="1.0"/>
3535+ <blockBottomPadding length="1.0"/>
3536+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,1" stop="-1,-1" thickness='0.5'/>
3537+ </blockTableStyle>
3538+ <blockTableStyle id="TOP_TABLE">
3539+ <blockAlignment value="LEFT"/>
3540+ <blockValign value="TOP"/>
3541+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1" thickness='0.25'/>
3542+ </blockTableStyle>
3543+
3544+ <initialize>
3545+ <paraStyle
3546+ name="all"
3547+ alignment="justify"
3548+ fontName="Helvetica"
3549+ fontSize="6.0"
3550+ />
3551+ </initialize>
3552+ <paraStyle
3553+ name="TITLE_LEFT_ALIGN"
3554+ fontName="Helvetica-Bold"
3555+ fontSize="6.0"
3556+ leading="10"
3557+ alignment="RIGHT"
3558+ spaceBefore="0.0"
3559+ spaceAfter="0.0"/>
3560+ <paraStyle name="TOP_TITLE" fontName="Helvetica-Bold" fontSize="7" leftIndent="0.0" alignment="LEFT"/>
3561+ <paraStyle name="TITLES" fontName="Helvetica-Bold" fontSize="6.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
3562+ <paraStyle name="TITLE_CENTER" fontName="Helvetica-Bold" fontSize="7" leading="10" leftIndent="0.0" alignment="CENTER"/>
3563+ <paraStyle name="TITLE_CENTER_NAME" fontName="Helvetica-Bold" fontSize="12" leading="13" leftIndent="0.0" alignment="CENTER"/>
3564+ <paraStyle name="TITLE" alignment="CENTER" fontName="Helvetica" fontSize="18.0" leading="20" spaceBefore="-3.0" textColor="black"/>
3565+ </stylesheet>
3566+ <images/>
3567+ <story>
3568+ <para>[[setLang(user.lang)]]</para>
3569+ <blockTable colWidths="2.0cm,6.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY" repeatRows="1">
3570+ <tr noRowsplits="1">
3571+ <td>
3572+ <para style="TITLE_LEFT_ALIGN">
3573+ <font>CODE</font>
3574+ </para>
3575+ </td>
3576+ <td>
3577+ <para style="TITLES">ACCOUNT</para>
3578+ </td>
3579+ <td>
3580+ <para style="TITLE_LEFT_ALIGN">01</para>
3581+ </td>
3582+ <td>
3583+ <para style="TITLE_LEFT_ALIGN">02</para>
3584+ </td>
3585+ <td>
3586+ <para style="TITLE_LEFT_ALIGN">03</para>
3587+ </td>
3588+ <td>
3589+ <para style="TITLE_LEFT_ALIGN">04</para>
3590+ </td>
3591+ <td>
3592+ <para style="TITLE_LEFT_ALIGN">05</para>
3593+ </td>
3594+ <td>
3595+ <para style="TITLE_LEFT_ALIGN">06</para>
3596+ </td>
3597+ <td>
3598+ <para style="TITLE_LEFT_ALIGN">07</para>
3599+ </td>
3600+ <td>
3601+ <para style="TITLE_LEFT_ALIGN">08</para>
3602+ </td>
3603+ <td>
3604+ <para style="TITLE_LEFT_ALIGN">09</para>
3605+ </td>
3606+ <td>
3607+ <para style="TITLE_LEFT_ALIGN">10</para>
3608+ </td>
3609+ <td>
3610+ <para style="TITLE_LEFT_ALIGN">11</para>
3611+ </td>
3612+ <td>
3613+ <para style="TITLE_LEFT_ALIGN">12</para>
3614+ </td>
3615+ <td>
3616+ <para style="TITLE_LEFT_ALIGN">YTD</para>
3617+ </td>
3618+ </tr>
3619+ <tr>
3620+ <td>
3621+ <para style="TITLE_LEFT_ALIGN">[[ repeatIn(lines(data['form']), 'a') ]]
3622+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3623+ <i>[[a['label']==True and a['code'] or '' ]]</i>
3624+ </para>
3625+ </td>
3626+ <td>
3627+ <para style="TITLES">
3628+ <font>[[ ((a['total'] and not a['label']) and setTag('para','para',{'alignment':"RIGHT"}) or (a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}))) or removeParentNode('font') ]]</font>
3629+ <font>[[ a['type']=='view' and a['name'].upper() or a['name'].title() ]]</font>
3630+ </para>
3631+ </td>
3632+ <td>
3633+ <para style="TITLE_LEFT_ALIGN">
3634+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3635+ <font>[[ (a['total']==True) and formatLang(a['bal1'] and a['bal1'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3636+ </para>
3637+ </td>
3638+ <td>
3639+ <para style="TITLE_LEFT_ALIGN">
3640+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3641+ <font>[[ (a['total']==True) and formatLang(a['bal2'] and a['bal2'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3642+ </para>
3643+ </td>
3644+ <td>
3645+ <para style="TITLE_LEFT_ALIGN">
3646+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3647+ <font>[[ (a['total']==True) and formatLang(a['bal3'] and a['bal3'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3648+ </para>
3649+ </td>
3650+ <td>
3651+ <para style="TITLE_LEFT_ALIGN">
3652+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3653+ <font>[[ (a['total']==True) and formatLang(a['bal4'] and a['bal4'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3654+ </para>
3655+ </td>
3656+ <td>
3657+ <para style="TITLE_LEFT_ALIGN">
3658+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3659+ <font>[[ (a['total']==True) and formatLang(a['bal5'] and a['bal5'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3660+ </para>
3661+ </td>
3662+ <td>
3663+ <para style="TITLE_LEFT_ALIGN">
3664+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3665+ <font>[[ (a['total']==True) and formatLang(a['bal6'] and a['bal6'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3666+ </para>
3667+ </td>
3668+ <td>
3669+ <para style="TITLE_LEFT_ALIGN">
3670+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3671+ <font>[[ (a['total']==True) and formatLang(a['bal7'] and a['bal7'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3672+ </para>
3673+ </td>
3674+ <td>
3675+ <para style="TITLE_LEFT_ALIGN">
3676+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3677+ <font>[[ (a['total']==True) and formatLang(a['bal8'] and a['bal8'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3678+ </para>
3679+ </td>
3680+ <td>
3681+ <para style="TITLE_LEFT_ALIGN">
3682+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3683+ <font>[[ (a['total']==True) and formatLang(a['bal9'] and a['bal9'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3684+ </para>
3685+ </td>
3686+ <td>
3687+ <para style="TITLE_LEFT_ALIGN">
3688+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3689+ <font>[[ (a['total']==True) and formatLang(a['bal10'] and a['bal10'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3690+ </para>
3691+ </td>
3692+ <td>
3693+ <para style="TITLE_LEFT_ALIGN">
3694+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3695+ <font>[[ (a['total']==True) and formatLang(a['bal11'] and a['bal11'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3696+ </para>
3697+ </td>
3698+ <td>
3699+ <para style="TITLE_LEFT_ALIGN">
3700+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3701+ <font>[[ (a['total']==True) and formatLang(a['bal12'] and a['bal12'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3702+ </para>
3703+ </td>
3704+ <td>
3705+ <para style="TITLE_LEFT_ALIGN">
3706+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3707+ <font>[[ (a['total']==True) and formatLang(a['bal13'] and a['bal13'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3708+ </para>
3709+ </td>
3710+ </tr>
3711+ </blockTable>
3712+ </story>
3713+</document>
3714
3715=== added file 'account_financial_report/report/balance_full_2_cols.rml'
3716--- account_financial_report/report/balance_full_2_cols.rml 1970-01-01 00:00:00 +0000
3717+++ account_financial_report/report/balance_full_2_cols.rml 2014-08-15 20:07:23 +0000
3718@@ -0,0 +1,131 @@
3719+<?xml version="1.0"?>
3720+<document filename="test.pdf">
3721+ <template pageSize="(21.59cm,27.94cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
3722+ <pageTemplate id="first">
3723+ <frame id="first" x1="1cm" y1="1.0cm" width="19.0cm" height="23cm"/>
3724+ <pageGraphics>
3725+ <setFont name="Helvetica-Oblique" size="6"/>
3726+
3727+ <image x="1.0cm" y="24.0cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
3728+<!--
3729+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
3730+-->
3731+ <place x="-3.5cm" y="22.50cm" width="19cm" height="5.0cm">
3732+ <blockTable colWidths="9.6cm,9.4cm" style="TITLE">
3733+ <tr>
3734+ <td><para style="TOP_TITLE"></para></td>
3735+ <td><para style="TITLE_CENTER_NAME">
3736+ <font>[[ (company.name and company.name or 'NOMBRE DE COMPANIA NO DISPONIBLE')]]</font>
3737+ <font>[[ get_vat_by_country(data['form']) ]]</font>
3738+ </para></td>
3739+ </tr>
3740+ <tr>
3741+ <td><para style="TOP_TITLE"></para></td>
3742+ <td><para style="TITLE_CENTER">[[ get_informe_text(data['form']) ]]</para></td>
3743+ </tr>
3744+ <tr>
3745+ <td><para style="TOP_TITLE"></para></td>
3746+ <td><para style="TITLE_CENTER">(Expressed in [[data['form'] and ('%s'%( exchange_name(data['form']))) or '']])</para></td>
3747+ </tr>
3748+ <tr>
3749+ <td><para style="TOP_TITLE"></para></td>
3750+ <td><para style="TITLE_CENTER">[[data['form'] and get_month(data['form']) or '']]</para></td>
3751+ </tr>
3752+ </blockTable>
3753+ </place>
3754+ <drawRightString x="207mm" y="5mm">Printing Date: [[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time=True) ]] [[ get_informe_text(data['form']) ]] / Pág.: <pageNumber/>-<pageCount/></drawRightString>
3755+ </pageGraphics>
3756+
3757+ </pageTemplate>
3758+ </template>
3759+ <stylesheet>
3760+ <blockTableStyle id="TITLE">
3761+ <blockValign value="TOP"/>
3762+ </blockTableStyle>
3763+ <blockTableStyle id="BODY">
3764+ <blockValign value="TOP"/>
3765+ <blockAlignment value="RIGHT"/>
3766+ <blockTopPadding length="1.0"/>
3767+ <blockBottomPadding length="1.0"/>
3768+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,1" stop="-1,-1" thickness='0.25'/>
3769+ </blockTableStyle>
3770+ <blockTableStyle id="BODY_STRIKE">
3771+ <blockValign value="TOP"/>
3772+ <blockAlignment value="RIGHT"/>
3773+ <blockTopPadding length="1.0"/>
3774+ <blockBottomPadding length="1.0"/>
3775+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,1" stop="-1,-1" thickness='0.5'/>
3776+ </blockTableStyle>
3777+ <blockTableStyle id="TOP_TABLE">
3778+ <blockAlignment value="LEFT"/>
3779+ <blockValign value="TOP"/>
3780+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1" thickness='0.25'/>
3781+ </blockTableStyle>
3782+
3783+ <initialize>
3784+ <paraStyle name="all" alignment="justify"/>
3785+ </initialize>
3786+ <paraStyle
3787+ name="TITLE_LEFT_ALIGN"
3788+ fontName="Helvetica-Bold"
3789+ fontSize="8.0"
3790+ leading="10"
3791+ alignment="RIGHT"
3792+ spaceBefore="0.0"
3793+ spaceAfter="0.0"/>
3794+ <paraStyle name="TOP_TITLE" fontName="Helvetica-Bold" fontSize="9" leftIndent="0.0" alignment="LEFT"/>
3795+ <paraStyle name="TITLES" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
3796+ <paraStyle name="TITLE_CENTER" fontName="Helvetica-Bold" fontSize="9" leading="10" leftIndent="0.0" alignment="CENTER"/>
3797+ <paraStyle name="TITLE_CENTER_NAME" fontName="Helvetica-Bold" fontSize="12" leading="13" leftIndent="0.0" alignment="CENTER"/>
3798+ <paraStyle name="TITLE" alignment="CENTER" fontName="Helvetica" fontSize="18.0" leading="20" spaceBefore="-3.0" textColor="black"/>
3799+ </stylesheet>
3800+ <images/>
3801+ <story>
3802+ <para>[[setLang(user.lang)]]</para>
3803+ <blockTable colWidths="2.5cm,9.5cm,3.5cm,3.5cm" style="BODY" repeatRows="1">
3804+ <tr noRowsplits="1">
3805+ <td>
3806+ <para style="TITLE_LEFT_ALIGN">
3807+ <font>CODE</font>
3808+ </para>
3809+ </td>
3810+ <td>
3811+ <para style="TITLES">ACCOUNT</para>
3812+ </td>
3813+ <td>
3814+ <para style="TITLE_LEFT_ALIGN">DEBIT</para>
3815+ </td>
3816+ <td>
3817+ <para style="TITLE_LEFT_ALIGN">CREDIT</para>
3818+ </td>
3819+ </tr>
3820+ <tr>
3821+ <td>
3822+ <para style="TITLE_LEFT_ALIGN">[[ repeatIn(lines(data['form']), 'a') ]]
3823+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3824+ <i>[[a['label']==True and a['code'] or '' ]]</i>
3825+ </para>
3826+ </td>
3827+ <td>
3828+ <para style="TITLES">
3829+ <font>[[ ((a['total'] and not a['label']) and setTag('para','para',{'alignment':"RIGHT"}) or (a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}))) or removeParentNode('font') ]]</font>
3830+ <font>[[ a['type']=='view' and a['name'].upper() or a['name'].title() ]]</font>
3831+ </para>
3832+ </td>
3833+ <td>
3834+ <para style="TITLE_LEFT_ALIGN">
3835+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3836+ <font>[[ (a['total']==True) and formatLang(a['debit'], digits=2, grouping=True) or '']]</font>
3837+ </para>
3838+ </td>
3839+ <td>
3840+ <para style="TITLE_LEFT_ALIGN">
3841+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3842+ <font>[[ (a['total']==True) and formatLang(a['credit'], digits=2, grouping=True) or '']]</font>
3843+ </para>
3844+ </td>
3845+
3846+ </tr>
3847+ </blockTable>
3848+ </story>
3849+</document>
3850
3851=== added file 'account_financial_report/report/balance_full_4_cols.rml'
3852--- account_financial_report/report/balance_full_4_cols.rml 1970-01-01 00:00:00 +0000
3853+++ account_financial_report/report/balance_full_4_cols.rml 2014-08-15 20:07:23 +0000
3854@@ -0,0 +1,149 @@
3855+<?xml version="1.0"?>
3856+<document filename="test.pdf">
3857+ <template pageSize="(21.59cm,27.94cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
3858+ <pageTemplate id="first">
3859+ <frame id="first" x1="0.5cm" y1="1.0cm" width="20.5cm" height="23cm"/>
3860+ <pageGraphics>
3861+ <setFont name="Helvetica-Oblique" size="6"/>
3862+
3863+ <image x="1.0cm" y="24.0cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
3864+<!--
3865+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
3866+-->
3867+
3868+ <place x="-3.5cm" y="22.50cm" width="19cm" height="5.0cm">
3869+ <blockTable colWidths="9.6cm,9.4cm" style="TITLE">
3870+ <tr>
3871+ <td><para style="TOP_TITLE"></para></td>
3872+ <td><para style="TITLE_CENTER_NAME">
3873+ <font>[[ (company.name and company.name or 'NOMBRE DE COMPANIA NO DISPONIBLE')]]</font>
3874+ <font>[[ get_vat_by_country(data['form']) ]]</font>
3875+ </para></td>
3876+ </tr>
3877+ <tr>
3878+ <td><para style="TOP_TITLE"></para></td>
3879+ <td><para style="TITLE_CENTER">[[ get_informe_text(data['form']) ]]</para></td>
3880+ </tr>
3881+ <tr>
3882+ <td><para style="TOP_TITLE"></para></td>
3883+ <td><para style="TITLE_CENTER">(Expressed in [[data['form'] and ('%s'%( exchange_name(data['form']))) or '']])</para></td>
3884+ </tr>
3885+ <tr>
3886+ <td><para style="TOP_TITLE"></para></td>
3887+ <td><para style="TITLE_CENTER">[[data['form'] and get_month(data['form']) or '']]</para></td>
3888+ </tr>
3889+ </blockTable>
3890+ </place>
3891+ <drawRightString x="207mm" y="5mm">Printing Date: [[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time=True) ]] [[ get_informe_text(data['form']) ]] / Pág.: <pageNumber/>-<pageCount/></drawRightString>
3892+ </pageGraphics>
3893+
3894+ </pageTemplate>
3895+ </template>
3896+ <stylesheet>
3897+ <blockTableStyle id="TITLE">
3898+ <blockValign value="TOP"/>
3899+ </blockTableStyle>
3900+ <blockTableStyle id="BODY">
3901+ <blockValign value="TOP"/>
3902+ <blockAlignment value="RIGHT"/>
3903+ <blockTopPadding length="1.0"/>
3904+ <blockBottomPadding length="1.0"/>
3905+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,1" stop="-1,-1" thickness='0.25'/>
3906+ </blockTableStyle>
3907+ <blockTableStyle id="BODY_STRIKE">
3908+ <blockValign value="TOP"/>
3909+ <blockAlignment value="RIGHT"/>
3910+ <blockTopPadding length="1.0"/>
3911+ <blockBottomPadding length="1.0"/>
3912+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,1" stop="-1,-1" thickness='0.5'/>
3913+ </blockTableStyle>
3914+ <blockTableStyle id="TOP_TABLE">
3915+ <blockAlignment value="LEFT"/>
3916+ <blockValign value="TOP"/>
3917+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1" thickness='0.25'/>
3918+ </blockTableStyle>
3919+
3920+ <initialize>
3921+ <paraStyle name="all" alignment="justify"/>
3922+ </initialize>
3923+ <paraStyle
3924+ name="TITLE_LEFT_ALIGN"
3925+ fontName="Helvetica-Bold"
3926+ fontSize="6.0"
3927+ leading="10"
3928+ alignment="RIGHT"
3929+ spaceBefore="0.0"
3930+ spaceAfter="0.0"/>
3931+ <paraStyle name="TOP_TITLE" fontName="Helvetica-Bold" fontSize="7" leftIndent="0.0" alignment="LEFT"/>
3932+ <paraStyle name="TITLES" fontName="Helvetica-Bold" fontSize="6.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
3933+ <paraStyle name="TITLE_CENTER" fontName="Helvetica-Bold" fontSize="7" leading="10" leftIndent="0.0" alignment="CENTER"/>
3934+ <paraStyle name="TITLE_CENTER_NAME" fontName="Helvetica-Bold" fontSize="12" leading="13" leftIndent="0.0" alignment="CENTER"/>
3935+ <paraStyle name="TITLE" alignment="CENTER" fontName="Helvetica" fontSize="18.0" leading="20" spaceBefore="-3.0" textColor="black"/>
3936+ </stylesheet>
3937+ <images/>
3938+ <story>
3939+ <para>[[setLang(user.lang)]]</para>
3940+ <blockTable colWidths="2.5cm,6.5cm,2.5cm,3.5cm,3.5cm,2.5cm" style="BODY" repeatRows="1">
3941+ <tr noRowsplits="1">
3942+ <td>
3943+ <para style="TITLE_LEFT_ALIGN">
3944+ <font>CODE</font>
3945+ </para>
3946+ </td>
3947+ <td>
3948+ <para style="TITLES">ACCOUNT</para>
3949+ </td>
3950+ <td>
3951+ <para style="TITLE_LEFT_ALIGN">INITIAL</para>
3952+ </td>
3953+ <td>
3954+ <para style="TITLE_LEFT_ALIGN">DEBIT</para>
3955+ </td>
3956+ <td>
3957+ <para style="TITLE_LEFT_ALIGN">CREDIT</para>
3958+ </td>
3959+ <td>
3960+ <para style="TITLE_LEFT_ALIGN">BALANCE</para>
3961+ </td>
3962+ </tr>
3963+ <tr>
3964+ <td>
3965+ <para style="TITLE_LEFT_ALIGN">[[ repeatIn(lines(data['form']), 'a') ]]
3966+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3967+ <i>[[a['label']==True and a['code'] or '' ]]</i>
3968+ </para>
3969+ </td>
3970+ <td>
3971+ <para style="TITLES">
3972+ <font>[[ ((a['total'] and not a['label']) and setTag('para','para',{'alignment':"RIGHT"}) or (a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}))) or removeParentNode('font') ]]</font>
3973+ <font>[[ a['type']=='view' and a['name'].upper() or a['name'].title() ]]</font>
3974+ </para>
3975+ </td>
3976+ <td>
3977+ <para style="TITLE_LEFT_ALIGN">
3978+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3979+ <font>[[ (a['total']==True) and formatLang(a['balanceinit'] and a['balanceinit'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3980+ </para>
3981+ </td>
3982+ <td>
3983+ <para style="TITLE_LEFT_ALIGN">
3984+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3985+ <font>[[ (a['total']==True) and formatLang(a['debit'], digits=2, grouping=True) or '']]</font>
3986+ </para>
3987+ </td>
3988+ <td>
3989+ <para style="TITLE_LEFT_ALIGN">
3990+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3991+ <font>[[ (a['total']==True) and formatLang(a['credit'], digits=2, grouping=True) or '']]</font>
3992+ </para>
3993+ </td>
3994+ <td>
3995+ <para style="TITLE_LEFT_ALIGN">
3996+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
3997+ <font>[[ (a['total']==True) and formatLang(a['balance'] and a['balance'] * a.get('change_sign',1) or 0.0, digits=2, grouping=True) or '']]</font>
3998+ </para>
3999+ </td>
4000+ </tr>
4001+ </blockTable>
4002+ </story>
4003+</document>
4004
4005=== added file 'account_financial_report/report/balance_full_4_cols_analytic_ledger.rml'
4006--- account_financial_report/report/balance_full_4_cols_analytic_ledger.rml 1970-01-01 00:00:00 +0000
4007+++ account_financial_report/report/balance_full_4_cols_analytic_ledger.rml 2014-08-15 20:07:23 +0000
4008@@ -0,0 +1,294 @@
4009+<?xml version="1.0"?>
4010+<document filename="test.pdf">
4011+ <template pageSize="(27.94cm,21.59cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
4012+ <pageTemplate id="first">
4013+ <frame id="first" x1="1.0cm" y1="1.0cm" width="26.0cm" height="16.65cm"/>
4014+ <pageGraphics>
4015+ <setFont name="Helvetica-Oblique" size="6"/>
4016+
4017+ <image x="1.0cm" y="17.65cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
4018+<!--
4019+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
4020+-->
4021+
4022+ <place x="-3.5cm" y="16.15cm" width="19cm" height="5.0cm">
4023+ <blockTable colWidths="9.6cm,9.4cm" style="TITLE">
4024+ <tr>
4025+ <td><para style="TOP_TITLE"></para></td>
4026+ <td><para style="TITLE_CENTER_NAME">
4027+ <font>[[ (company.name and company.name or 'NOMBRE DE COMPANIA NO DISPONIBLE')]]</font>
4028+ <font>[[ get_vat_by_country(data['form']) ]]</font>
4029+ </para></td>
4030+ </tr>
4031+ <tr>
4032+ <td><para style="TOP_TITLE"></para></td>
4033+ <td><para style="TITLE_CENTER">[[ get_informe_text(data['form']) ]]</para></td>
4034+ </tr>
4035+ <tr>
4036+ <td><para style="TOP_TITLE"></para></td>
4037+ <td><para style="TITLE_CENTER">(Expressed in [[data['form'] and (' %s'%( exchange_name(data['form']))) or '']])</para></td>
4038+ </tr>
4039+ <tr>
4040+ <td><para style="TOP_TITLE"></para></td>
4041+ <td><para style="TITLE_CENTER">[[data['form'] and get_month(data['form']) or '']]</para></td>
4042+ </tr>
4043+ </blockTable>
4044+ </place>
4045+ <drawRightString x="270mm" y="5mm">Printing Date: [[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time=True) ]] [[ get_informe_text(data['form']) ]] / Pág.: <pageNumber/>-<pageCount/></drawRightString>
4046+ </pageGraphics>
4047+
4048+ </pageTemplate>
4049+ </template>
4050+ <stylesheet>
4051+ <blockTableStyle id="BODY_LINE">
4052+ <blockValign value="TOP"/>
4053+ <blockAlignment value="RIGHT"/>
4054+ <blockTopPadding length="1.0"/>
4055+ <blockBottomPadding length="1.0"/>
4056+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,0" stop="-1,-1" thickness='0.25'/>
4057+ </blockTableStyle>
4058+ <blockTableStyle id="TITLE">
4059+ <blockValign value="TOP"/>
4060+ </blockTableStyle>
4061+ <blockTableStyle id="BODY">
4062+ <blockValign value="TOP"/>
4063+ <blockAlignment value="RIGHT"/>
4064+ <blockTopPadding length="1.0"/>
4065+ <blockBottomPadding length="1.0"/>
4066+ <lineStyle kind="LINEBELOW" colorName="darkgrey" start="0,0" stop="-1,-1" thickness='0.25'/>
4067+ </blockTableStyle>
4068+ <blockTableStyle id="BODY_STRIKE">
4069+ <blockValign value="TOP"/>
4070+ <blockAlignment value="RIGHT"/>
4071+ <blockTopPadding length="1.0"/>
4072+ <blockBottomPadding length="1.0"/>
4073+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,1" stop="-1,-1" thickness='0.5'/>
4074+ </blockTableStyle>
4075+ <blockTableStyle id="TOP_TABLE">
4076+ <blockAlignment value="LEFT"/>
4077+ <blockValign value="TOP"/>
4078+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1" thickness='0.25'/>
4079+ </blockTableStyle>
4080+
4081+ <initialize>
4082+ <paraStyle name="all" alignment="justify"/>
4083+ </initialize>
4084+
4085+ <paraStyle
4086+ name="TITLE_LEFT_ALIGN_NEW"
4087+ fontName="Courier"
4088+ fontSize="7.0"
4089+ leading="10"
4090+ alignment="RIGHT"
4091+ spaceBefore="0.0"
4092+ spaceAfter="0.0"/>
4093+ <paraStyle name="TITLES_NEW"
4094+ fontName="Courier"
4095+ fontSize="7.0"
4096+ leading="10"
4097+ alignment="LEFT"
4098+ spaceBefore="0.0"
4099+ spaceAfter="0.0"/>
4100+ <paraStyle
4101+ name="TITLE_LEFT_ALIGN"
4102+ fontName="Helvetica-Bold"
4103+ fontSize="7.0"
4104+ leading="10"
4105+ alignment="RIGHT"
4106+ spaceBefore="0.0"
4107+ spaceAfter="0.0"/>
4108+ <paraStyle name="TOP_TITLE" fontName="Helvetica-Bold" fontSize="7" leftIndent="0.0" alignment="LEFT"/>
4109+ <paraStyle
4110+ name="TITLES"
4111+ fontName="Helvetica-Bold"
4112+ fontSize="7.0"
4113+ leading="10"
4114+ alignment="LEFT"
4115+ spaceBefore="0.0"
4116+ spaceAfter="0.0"/>
4117+ <paraStyle name="TITLE_CENTER" fontName="Helvetica-Bold" fontSize="7" leading="10" leftIndent="0.0" alignment="CENTER"/>
4118+ <paraStyle name="TITLE_CENTER_NAME" fontName="Helvetica-Bold" fontSize="12" leading="13" leftIndent="0.0" alignment="CENTER"/>
4119+ <paraStyle
4120+ name="TITLE"
4121+ alignment="CENTER"
4122+ fontName="Helvetica"
4123+ fontSize="18.0"
4124+ leading="20"
4125+ spaceBefore="-3.0"
4126+ textColor="black"/>
4127+ </stylesheet>
4128+ <images/>
4129+ <story>
4130+ <para>[[setLang(user.lang)]]</para>
4131+
4132+ <blockTable colWidths="2.5cm,13.5cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY" repeatRows="0">
4133+ <tr noRowsplits="0">
4134+ <td>
4135+ <para style="TITLE_LEFT_ALIGN">
4136+ <font>CODE</font>
4137+ </para>
4138+ </td>
4139+ <td>
4140+ <para style="TITLES">ACCOUNT</para>
4141+ </td>
4142+ <td>
4143+ <para style="TITLE_LEFT_ALIGN">INITIAL</para>
4144+ </td>
4145+ <td>
4146+ <para style="TITLE_LEFT_ALIGN">DEBIT</para>
4147+ </td>
4148+ <td>
4149+ <para style="TITLE_LEFT_ALIGN">CREDIT</para>
4150+ </td>
4151+ <td>
4152+ <para style="TITLE_LEFT_ALIGN">BALANCE</para>
4153+ </td>
4154+ </tr>
4155+ </blockTable>
4156+
4157+ <blockTable colWidths="2.25cm,2.0cm,7.75cm,2.5cm,4.0cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE" repeatRows="1">
4158+<!--
4159+ [[ (a['type'] &lt;&gt; 'view') or removeParentNode('blockTable') ]]
4160+-->
4161+ <tr noRowsplits="1">
4162+ <td>
4163+ <para style="TITLES_NEW">
4164+ <font>DATE</font>
4165+ </para>
4166+ </td>
4167+ <td>
4168+ <para style="TITLES_NEW">
4169+ <font>PERIOD</font>
4170+ </para>
4171+ </td>
4172+ <td>
4173+ <para style="TITLES_NEW">REFERENCE</para>
4174+ </td>
4175+ <td>
4176+ <para style="TITLES_NEW">JOURNAL ENTRY</para>
4177+ </td>
4178+ <td>
4179+ <para style="TITLES_NEW">PARTNER</para>
4180+ </td>
4181+ <td>
4182+ <para style="TITLE_LEFT_ALIGN"></para>
4183+ </td>
4184+ <td>
4185+ <para style="TITLE_LEFT_ALIGN"></para>
4186+ </td>
4187+ <td>
4188+ <para style="TITLE_LEFT_ALIGN"></para>
4189+ </td>
4190+ </tr>
4191+ </blockTable>
4192+
4193+
4194+
4195+
4196+
4197+ <section>
4198+ <para>[[ repeatIn([x for x in lines(data['form']) if x['type'] != 'view'], 'a') ]]</para>
4199+ <blockTable colWidths="2.5cm,13.5cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY" repeatRows="0">
4200+ <tr>
4201+ <td>
4202+ <para style="TITLE_LEFT_ALIGN">
4203+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4204+ <i>[[a['label']==True and a['code'] or '' ]]</i>
4205+ </para>
4206+ </td>
4207+ <td>
4208+ <para style="TITLES">
4209+ <font>[[ ((a['total'] and not a['label']) and setTag('para','para',{'alignment':"RIGHT"}) or (a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}))) or removeParentNode('font') ]]</font>
4210+ <font>[[ a['type']=='view' and a['name'].upper() or a['name'].title() ]]</font>
4211+ </para>
4212+ </td>
4213+ <td>
4214+ <para style="TITLE_LEFT_ALIGN">
4215+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4216+ <font>[[ (a['total']==True) and formatLang(a['balanceinit'] and a['balanceinit'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4217+ </para>
4218+ </td>
4219+ <td>
4220+ <para style="TITLE_LEFT_ALIGN">
4221+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4222+ <font>[[ (a['total']==True) and formatLang(a['debit'], digits=2, grouping=True) or '']]</font>
4223+ </para>
4224+ </td>
4225+ <td>
4226+ <para style="TITLE_LEFT_ALIGN">
4227+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4228+ <font>[[ (a['total']==True) and formatLang(a['credit'], digits=2, grouping=True) or '']]</font>
4229+ </para>
4230+ </td>
4231+ <td>
4232+ <para style="TITLE_LEFT_ALIGN">
4233+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4234+ <font>[[ (a['total']==True) and formatLang(a['balance'] and a['balance'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4235+ </para>
4236+ </td>
4237+ </tr>
4238+ </blockTable>
4239+
4240+ <section>
4241+ <para>[[ repeatIn(a['mayor'], 'm') ]]</para>
4242+ <blockTable colWidths="2.25cm,2.0cm,7.75cm,2.5cm,4.0cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE" repeatRows="1">
4243+<!--
4244+ [[ (a['type'] &lt;&gt; 'view') or removeParentNode('blockTable') ]]
4245+-->
4246+ <tr>
4247+ <td>
4248+ <para style="TITLES_NEW">
4249+ <font> [[ formatLang( m['date'], date=True) ]]</font>
4250+ </para>
4251+ </td>
4252+ <td>
4253+ <para style="TITLES_NEW">
4254+ <font>[[ m['period'] ]]</font>
4255+ </para>
4256+ </td>
4257+ <td>
4258+ <para style="TITLES_NEW">
4259+ <font>[[ m['name'] ]] [[ m['ref'] and (' - Ref %s'%m['ref']) or '' ]] </font>
4260+ </para>
4261+ </td>
4262+ <td>
4263+ <para style="TITLES_NEW">
4264+ <font>[[ m['entry'] ]]</font>
4265+ </para>
4266+<!--
4267+ <para style="TITLES_NEW">
4268+ <font>[[ m['journal'] ]]</font>
4269+ </para>
4270+-->
4271+ </td>
4272+ <td>
4273+ <para style="TITLES_NEW">
4274+ <font>[[ m['partner'] ]]</font>
4275+ </para>
4276+ </td>
4277+ <td>
4278+ <para style="TITLE_LEFT_ALIGN">
4279+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4280+ <font>[[ (a['total']==True) and formatLang(m['debit'], digits=2, grouping=True) or '']]</font>
4281+ </para>
4282+ </td>
4283+ <td>
4284+ <para style="TITLE_LEFT_ALIGN">
4285+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4286+ <font>[[ (a['total']==True) and formatLang(m['credit'], digits=2, grouping=True) or '']]</font>
4287+ </para>
4288+ </td>
4289+ <td>
4290+ <para style="TITLE_LEFT_ALIGN">
4291+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4292+ <font>[[ (a['total']==True) and formatLang(m['balance'] and m['balance'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4293+ </para>
4294+ </td>
4295+ </tr>
4296+ </blockTable>
4297+ </section>
4298+ <spacer length="2.5mm"/>
4299+ </section>
4300+
4301+ </story>
4302+</document>
4303
4304=== added file 'account_financial_report/report/balance_full_4_cols_journal_ledger.rml'
4305--- account_financial_report/report/balance_full_4_cols_journal_ledger.rml 1970-01-01 00:00:00 +0000
4306+++ account_financial_report/report/balance_full_4_cols_journal_ledger.rml 2014-08-15 20:07:23 +0000
4307@@ -0,0 +1,397 @@
4308+<?xml version="1.0"?>
4309+<document filename="test.pdf">
4310+ <template pageSize="(27.94cm,21.59cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
4311+ <pageTemplate id="first">
4312+ <frame id="first" x1="1.0cm" y1="1.0cm" width="26.0cm" height="16.65cm"/>
4313+ <pageGraphics>
4314+ <setFont name="Helvetica-Oblique" size="6"/>
4315+
4316+ <image x="1.0cm" y="17.65cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
4317+<!--
4318+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
4319+-->
4320+
4321+ <place x="-3.5cm" y="16.15cm" width="19cm" height="5.0cm">
4322+ <blockTable colWidths="9.6cm,9.4cm" style="TITLE">
4323+ <tr>
4324+ <td><para style="TOP_TITLE"></para></td>
4325+ <td><para style="TITLE_CENTER_NAME">
4326+ <font>[[ (company.name and company.name or 'NOMBRE DE COMPANIA NO DISPONIBLE')]]</font>
4327+ <font>[[ company.partner_id.vat and ('- %s-%s-%s'%(company.partner_id.vat[2:3],company.partner_id.vat[3:11],company.partner_id.vat[11:12])) or '' ]]</font>
4328+ </para></td>
4329+ </tr>
4330+ <tr>
4331+ <td><para style="TOP_TITLE"></para></td>
4332+ <td><para style="TITLE_CENTER">[[ get_informe_text(data['form']) ]]</para></td>
4333+ </tr>
4334+ <tr>
4335+ <td><para style="TOP_TITLE"></para></td>
4336+ <td><para style="TITLE_CENTER">(Expressed in [[data['form'] and (' %s'%( exchange_name(data['form']))) or '']])</para></td>
4337+ </tr>
4338+ <tr>
4339+ <td><para style="TOP_TITLE"></para></td>
4340+ <td><para style="TITLE_CENTER">[[data['form'] and get_month(data['form']) or '']]</para></td>
4341+ </tr>
4342+ </blockTable>
4343+ </place>
4344+ <drawRightString x="270mm" y="5mm">Printing Date: [[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time=True) ]] [[ get_informe_text(data['form']) ]] / Pág.: <pageNumber/>-<pageCount/></drawRightString>
4345+ </pageGraphics>
4346+ </pageTemplate>
4347+ </template>
4348+ <stylesheet>
4349+ <blockTableStyle id="BODY_LINE">
4350+ <blockValign value="TOP"/>
4351+ <blockAlignment value="RIGHT"/>
4352+ <blockTopPadding length="1.0"/>
4353+ <blockBottomPadding length="1.0"/>
4354+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,0" stop="-1,-1" thickness='0.25'/>
4355+ </blockTableStyle>
4356+ <blockTableStyle id="BODY_LINE_FILLED">
4357+ <blockBackground colorName="lightgrey" start="0,0" stop="-1,-1"/>
4358+ <blockValign value="TOP"/>
4359+ <blockAlignment value="RIGHT"/>
4360+ <blockTopPadding length="1.0"/>
4361+ <blockBottomPadding length="1.0"/>
4362+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,0" stop="-1,-1" thickness='0.25'/>
4363+ </blockTableStyle>
4364+ <blockTableStyle id="TITLE">
4365+ <blockValign value="TOP"/>
4366+ </blockTableStyle>
4367+ <blockTableStyle id="BODY">
4368+ <blockValign value="TOP"/>
4369+ <blockAlignment value="RIGHT"/>
4370+ <blockTopPadding length="1.0"/>
4371+ <blockBottomPadding length="1.0"/>
4372+ <lineStyle kind="LINEBELOW" colorName="darkgrey" start="0,0" stop="-1,-1" thickness='0.25'/>
4373+ </blockTableStyle>
4374+ <blockTableStyle id="BODY_STRIKE">
4375+ <blockValign value="TOP"/>
4376+ <blockAlignment value="RIGHT"/>
4377+ <blockTopPadding length="1.0"/>
4378+ <blockBottomPadding length="1.0"/>
4379+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,1" stop="-1,-1" thickness='0.5'/>
4380+ </blockTableStyle>
4381+ <blockTableStyle id="TOP_TABLE">
4382+ <blockAlignment value="LEFT"/>
4383+ <blockValign value="TOP"/>
4384+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1" thickness='0.25'/>
4385+ </blockTableStyle>
4386+
4387+ <initialize>
4388+ <paraStyle name="all" alignment="justify"/>
4389+ </initialize>
4390+
4391+ <paraStyle
4392+ name="TITLE_LEFT_ALIGN_NEW"
4393+ fontName="Courier"
4394+ fontSize="7.0"
4395+ leading="10"
4396+ alignment="RIGHT"
4397+ spaceBefore="0.0"
4398+ spaceAfter="0.0"/>
4399+ <paraStyle name="TITLES_NEW"
4400+ fontName="Courier"
4401+ fontSize="7.0"
4402+ leading="10"
4403+ alignment="LEFT"
4404+ spaceBefore="0.0"
4405+ spaceAfter="0.0"/>
4406+ <paraStyle name="TITLES_NEW_P"
4407+ fontName="Helvetica-Bold"
4408+ fontSize="6.0"
4409+ leading="10"
4410+ alignment="LEFT"
4411+ spaceBefore="0.0"
4412+ spaceAfter="0.0"/>
4413+ <paraStyle name="TITLES_NEW_RIGHT"
4414+ fontName="Courier"
4415+ fontSize="7.0"
4416+ leading="10"
4417+ alignment="RIGHT"
4418+ spaceBefore="0.0"
4419+ spaceAfter="0.0"/>
4420+ <paraStyle
4421+ name="TITLE_LEFT_ALIGN"
4422+ fontName="Helvetica-Bold"
4423+ fontSize="7.0"
4424+ leading="10"
4425+ alignment="RIGHT"
4426+ spaceBefore="0.0"
4427+ spaceAfter="0.0"/>
4428+ <paraStyle name="TOP_TITLE" fontName="Helvetica-Bold" fontSize="7" leftIndent="0.0" alignment="LEFT"/>
4429+ <paraStyle
4430+ name="TITLES"
4431+ fontName="Helvetica-Bold"
4432+ fontSize="7.0"
4433+ leading="10"
4434+ alignment="LEFT"
4435+ spaceBefore="0.0"
4436+ spaceAfter="0.0"/>
4437+ <paraStyle name="TITLE_CENTER" fontName="Helvetica-Bold" fontSize="7" leading="10" leftIndent="0.0" alignment="CENTER"/>
4438+ <paraStyle name="TITLE_CENTER_NAME" fontName="Helvetica-Bold" fontSize="12" leading="13" leftIndent="0.0" alignment="CENTER"/>
4439+ <paraStyle
4440+ name="TITLE"
4441+ alignment="CENTER"
4442+ fontName="Helvetica"
4443+ fontSize="18.0"
4444+ leading="20"
4445+ spaceBefore="-3.0"
4446+ textColor="black"/>
4447+ </stylesheet>
4448+ <images/>
4449+ <story>
4450+ <para>[[setLang(user.lang)]]</para>
4451+
4452+ <blockTable colWidths="2.5cm,13.5cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY" repeatRows="0">
4453+ <tr noRowsplits="0">
4454+ <td>
4455+ <para style="TITLE_LEFT_ALIGN">
4456+ <font>CODE</font>
4457+ </para>
4458+ </td>
4459+ <td>
4460+ <para style="TITLES">ACCOUNT</para>
4461+ </td>
4462+ <td>
4463+ <para style="TITLE_LEFT_ALIGN">INITIAL</para>
4464+ </td>
4465+ <td>
4466+ <para style="TITLE_LEFT_ALIGN">DEBIT</para>
4467+ </td>
4468+ <td>
4469+ <para style="TITLE_LEFT_ALIGN">CREDIT</para>
4470+ </td>
4471+ <td>
4472+ <para style="TITLE_LEFT_ALIGN">BALANCE</para>
4473+ </td>
4474+ </tr>
4475+ </blockTable>
4476+ <blockTable colWidths="6.0cm,3.0cm,3.0cm,2.5cm,4.0cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE" repeatRows="0">
4477+<!--
4478+ [[ (a['type'] &lt;&gt; 'view') or removeParentNode('blockTable') ]]
4479+-->
4480+ <tr noRowsplits="1">
4481+ <td>
4482+ <para style="TITLES_NEW">
4483+ <font>DATE</font>
4484+ </para>
4485+ </td>
4486+ <td>
4487+ <para style="TITLES_NEW">
4488+ <font>PERIOD</font>
4489+ </para>
4490+ </td>
4491+ <td>
4492+ <para style="TITLES_NEW">JOURNAL ENTRY</para>
4493+ </td>
4494+ <td>
4495+ <para style="TITLE_LEFT_ALIGN"></para>
4496+ </td>
4497+ <td>
4498+ <para style="TITLE_LEFT_ALIGN"></para>
4499+ </td>
4500+ <td>
4501+ <para style="TITLE_LEFT_ALIGN"></para>
4502+ </td>
4503+ <td>
4504+ <para style="TITLE_LEFT_ALIGN"></para>
4505+ </td>
4506+ <td>
4507+ <para style="TITLE_LEFT_ALIGN"></para>
4508+ </td>
4509+ </tr>
4510+ </blockTable>
4511+ <section>
4512+ <para>[[ repeatIn([x for x in lines(data['form']) if x['type'] != 'view'], 'a') ]]</para>
4513+ <blockTable colWidths="2.5cm,13.5cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY" repeatRows="0">
4514+ <tr>
4515+ <td>
4516+ <para style="TITLE_LEFT_ALIGN">
4517+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4518+ <i>[[a['label']==True and a['code'] or '' ]]</i>
4519+ </para>
4520+ </td>
4521+ <td>
4522+ <para style="TITLES">
4523+ <font>[[ ((a['total'] and not a['label']) and setTag('para','para',{'alignment':"RIGHT"}) or (a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}))) or removeParentNode('font') ]]</font>
4524+ <font>[[ a['type']=='view' and a['name'].upper() or a['name'].title() ]]</font>
4525+ </para>
4526+ </td>
4527+ <td>
4528+ <para style="TITLE_LEFT_ALIGN">
4529+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4530+ <font>[[ (a['total']==True) and formatLang(a['balanceinit'] and a['balanceinit'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4531+ </para>
4532+ </td>
4533+ <td>
4534+ <para style="TITLE_LEFT_ALIGN">
4535+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4536+ <font>[[ (a['total']==True) and formatLang(a['debit'], digits=2, grouping=True) or '']]</font>
4537+ </para>
4538+ </td>
4539+ <td>
4540+ <para style="TITLE_LEFT_ALIGN">
4541+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4542+ <font>[[ (a['total']==True) and formatLang(a['credit'], digits=2, grouping=True) or '']]</font>
4543+ </para>
4544+ </td>
4545+ <td>
4546+ <para style="TITLE_LEFT_ALIGN">
4547+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4548+ <font>[[ (a['total']==True) and formatLang(a['balance'] and a['balance'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4549+ </para>
4550+ </td>
4551+ </tr>
4552+ </blockTable>
4553+
4554+ <section>
4555+ <para>[[ repeatIn(a['journal'], 'j') ]]</para>
4556+ <blockTable colWidths="6.0cm,3.0cm,3.0cm,2.5cm,4.0cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE" repeatRows="1">
4557+<!--
4558+ [[ (a['type'] &lt;&gt; 'view') or removeParentNode('blockTable') ]]
4559+-->
4560+ <tr>
4561+ <td>
4562+ <para style="TITLES_NEW_P">
4563+ <font> [[ formatLang( j['date'], date=True) ]]</font>
4564+ </para>
4565+ </td>
4566+ <td>
4567+ <para style="TITLES_NEW_P">
4568+ <font>[[ j['period'] ]]</font>
4569+ </para>
4570+ </td>
4571+ <td>
4572+ <para style="TITLES_NEW_P">
4573+ <font>[[ j['name'] ]] </font>
4574+ </para>
4575+ </td>
4576+ <td>
4577+ <para style="TITLES_NEW">
4578+ <font></font>
4579+ </para>
4580+
4581+ </td>
4582+ <td>
4583+ <para style="TITLES_NEW">
4584+ <font></font>
4585+ </para>
4586+ </td>
4587+ <td>
4588+ <para style="TITLE_LEFT_ALIGN">
4589+ </para>
4590+ </td>
4591+ <td>
4592+ <para style="TITLE_LEFT_ALIGN">
4593+ </para>
4594+ </td>
4595+ <td>
4596+ <para style="TITLE_LEFT_ALIGN">
4597+ </para>
4598+ </td>
4599+ </tr>
4600+ </blockTable>
4601+ <section>
4602+ <para>[[ repeatIn(j.get('obj').line_id, 'k') ]]</para>
4603+ <blockTable colWidths="6.0cm,3.0cm,3.0cm,1.5cm,5.0cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE_FILLED" repeatRows="1">
4604+ <tr>
4605+ <td>
4606+ <para style="TITLES_NEW">
4607+ <font> [[ k.account_id.code == a['code'] and k.name or removeParentNode('blockTable') ]]</font>
4608+ </para>
4609+ </td>
4610+ <td>
4611+ <para style="TITLES_NEW">
4612+ <font>[[ k.ref and k.ref or '']]</font>
4613+ </para>
4614+ </td>
4615+ <td>
4616+ <para style="TITLES_NEW">
4617+ <font>[[ k.partner_id and k.partner_id.name or '']]</font>
4618+ </para>
4619+ </td>
4620+ <td>
4621+ <para style="TITLES_NEW">
4622+ <font>[[ k.account_id and k.account_id.code or '']]</font>
4623+ </para>
4624+ </td>
4625+ <td>
4626+ <para style="TITLES_NEW">
4627+ <font>[[ k.account_id and k.account_id.name or '']]</font>
4628+ </para>
4629+ </td>
4630+ <td>
4631+ <para style="TITLES_NEW_RIGHT">
4632+ <font>[[ k.account_id.type&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4633+ <font>[[ k.debit and formatLang(k.debit, digits=2, grouping=True) or '' ]] </font>
4634+ </para>
4635+ </td>
4636+ <td>
4637+ <para style="TITLES_NEW_RIGHT">
4638+ <font>[[ k.account_id.type&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4639+ <font>[[ k.credit and formatLang(k.credit, digits=2, grouping=True) or '' ]] </font>
4640+ </para>
4641+ </td>
4642+ <td>
4643+ <para style="TITLES_NEW_RIGHT">
4644+ <font>[[ k.account_id.type&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4645+ <font>[[ k.reconcile_id and k.reconcile_id.name or k.reconcile_partial_id and k.reconcile_partial_id.name or '']]</font>
4646+ </para>
4647+ </td>
4648+ </tr>
4649+ </blockTable>
4650+ <blockTable colWidths="6.0cm,3.0cm,3.0cm,1.5cm,5.0cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE" repeatRows="1">
4651+ <tr>
4652+ <td>
4653+ <para style="TITLES_NEW">
4654+ <font> [[ k.account_id.code != a['code'] and k.name or removeParentNode('blockTable') ]]</font>
4655+ </para>
4656+ </td>
4657+ <td>
4658+ <para style="TITLES_NEW">
4659+ <font>[[ k.ref and k.ref or '']]</font>
4660+ </para>
4661+ </td>
4662+ <td>
4663+ <para style="TITLES_NEW">
4664+ <font>[[ k.partner_id and k.partner_id.name or '']]</font>
4665+ </para>
4666+ </td>
4667+ <td>
4668+ <para style="TITLES_NEW">
4669+ <font>[[ k.account_id and k.account_id.code or '']]</font>
4670+ </para>
4671+ </td>
4672+ <td>
4673+ <para style="TITLES_NEW">
4674+ <font>[[ k.account_id and k.account_id.name or '']]</font>
4675+ </para>
4676+ </td>
4677+ <td>
4678+ <para style="TITLES_NEW_RIGHT">
4679+ <font>[[ k.account_id.type&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4680+ <font>[[ k.debit and formatLang(k.debit, digits=2, grouping=True) or '' ]] </font>
4681+ </para>
4682+ </td>
4683+ <td>
4684+ <para style="TITLES_NEW_RIGHT">
4685+ <font>[[ k.account_id.type&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4686+ <font>[[ k.credit and formatLang(k.credit, digits=2, grouping=True) or '' ]] </font>
4687+ </para>
4688+ </td>
4689+ <td>
4690+ <para style="TITLES_NEW_RIGHT">
4691+ <font>[[ k.account_id.type&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4692+ <font>[[ k.reconcile_id and k.reconcile_id.name or k.reconcile_partial_id and k.reconcile_partial_id.name or '']]</font>
4693+ </para>
4694+ </td>
4695+ </tr>
4696+ </blockTable>
4697+ </section>
4698+ <spacer length="1.5mm"/>
4699+ </section>
4700+ <spacer length="2.5mm"/>
4701+ </section>
4702+
4703+ </story>
4704+</document>
4705
4706=== added file 'account_financial_report/report/balance_full_4_cols_partner_balance.rml'
4707--- account_financial_report/report/balance_full_4_cols_partner_balance.rml 1970-01-01 00:00:00 +0000
4708+++ account_financial_report/report/balance_full_4_cols_partner_balance.rml 2014-08-15 20:07:23 +0000
4709@@ -0,0 +1,273 @@
4710+<?xml version="1.0"?>
4711+<document filename="test.pdf">
4712+ <template pageSize="(27.94cm,21.59cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
4713+ <pageTemplate id="first">
4714+ <frame id="first" x1="1.0cm" y1="1.0cm" width="26.0cm" height="16.65cm"/>
4715+ <pageGraphics>
4716+ <setFont name="Helvetica-Oblique" size="6"/>
4717+
4718+ <image x="1.0cm" y="17.65cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
4719+<!--
4720+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
4721+-->
4722+
4723+ <place x="-3.5cm" y="16.15cm" width="19cm" height="5.0cm">
4724+ <blockTable colWidths="9.6cm,9.4cm" style="TITLE">
4725+ <tr>
4726+ <td><para style="TOP_TITLE"></para></td>
4727+ <td><para style="TITLE_CENTER_NAME">
4728+ <font>[[ (company.name and company.name or 'NOMBRE DE COMPANIA NO DISPONIBLE')]]</font>
4729+ <font>[[ get_vat_by_country(data['form']) ]]</font>
4730+ </para></td>
4731+ </tr>
4732+ <tr>
4733+ <td><para style="TOP_TITLE"></para></td>
4734+ <td><para style="TITLE_CENTER">[[ get_informe_text(data['form']) ]]</para></td>
4735+ </tr>
4736+ <tr>
4737+ <td><para style="TOP_TITLE"></para></td>
4738+ <td><para style="TITLE_CENTER">(Expressed in [[data['form'] and (' %s'%( exchange_name(data['form']))) or '']])</para></td>
4739+ </tr>
4740+ <tr>
4741+ <td><para style="TOP_TITLE"></para></td>
4742+ <td><para style="TITLE_CENTER">[[data['form'] and get_month(data['form']) or '']]</para></td>
4743+ </tr>
4744+ </blockTable>
4745+ </place>
4746+ <drawRightString x="270mm" y="5mm">Printing Date: [[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time=True) ]] [[ get_informe_text(data['form']) ]] / Pág.: <pageNumber/>-<pageCount/></drawRightString>
4747+ </pageGraphics>
4748+
4749+ </pageTemplate>
4750+ </template>
4751+ <stylesheet>
4752+ <blockTableStyle id="BODY_LINE">
4753+ <blockValign value="TOP"/>
4754+ <blockAlignment value="RIGHT"/>
4755+ <blockTopPadding length="1.0"/>
4756+ <blockBottomPadding length="1.0"/>
4757+ <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,0" stop="-1,-1" thickness='0.25'/>
4758+ </blockTableStyle>
4759+ <blockTableStyle id="TITLE">
4760+ <blockValign value="TOP"/>
4761+ </blockTableStyle>
4762+ <blockTableStyle id="BODY">
4763+ <blockValign value="TOP"/>
4764+ <blockAlignment value="RIGHT"/>
4765+ <blockTopPadding length="1.0"/>
4766+ <blockBottomPadding length="1.0"/>
4767+ <lineStyle kind="LINEBELOW" colorName="darkgrey" start="0,0" stop="-1,-1" thickness='0.25'/>
4768+ </blockTableStyle>
4769+ <blockTableStyle id="BODY_STRIKE">
4770+ <blockValign value="TOP"/>
4771+ <blockAlignment value="RIGHT"/>
4772+ <blockTopPadding length="1.0"/>
4773+ <blockBottomPadding length="1.0"/>
4774+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,1" stop="-1,-1" thickness='0.5'/>
4775+ </blockTableStyle>
4776+ <blockTableStyle id="TOP_TABLE">
4777+ <blockAlignment value="LEFT"/>
4778+ <blockValign value="TOP"/>
4779+ <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1" thickness='0.25'/>
4780+ </blockTableStyle>
4781+
4782+ <initialize>
4783+ <paraStyle name="all" alignment="justify"/>
4784+ </initialize>
4785+
4786+ <paraStyle
4787+ name="TITLE_LEFT_ALIGN_NEW"
4788+ fontName="Courier"
4789+ fontSize="7.0"
4790+ leading="10"
4791+ alignment="RIGHT"
4792+ spaceBefore="0.0"
4793+ spaceAfter="0.0"/>
4794+ <paraStyle name="TITLES_NEW"
4795+ fontName="Courier"
4796+ fontSize="7.0"
4797+ leading="10"
4798+ alignment="LEFT"
4799+ spaceBefore="0.0"
4800+ spaceAfter="0.0"/>
4801+ <paraStyle
4802+ name="TITLE_LEFT_ALIGN"
4803+ fontName="Helvetica-Bold"
4804+ fontSize="7.0"
4805+ leading="10"
4806+ alignment="RIGHT"
4807+ spaceBefore="0.0"
4808+ spaceAfter="0.0"/>
4809+ <paraStyle name="TOP_TITLE" fontName="Helvetica-Bold" fontSize="7" leftIndent="0.0" alignment="LEFT"/>
4810+ <paraStyle
4811+ name="TITLES"
4812+ fontName="Helvetica-Bold"
4813+ fontSize="7.0"
4814+ leading="10"
4815+ alignment="LEFT"
4816+ spaceBefore="0.0"
4817+ spaceAfter="0.0"/>
4818+ <paraStyle name="TITLE_CENTER" fontName="Helvetica-Bold" fontSize="7" leading="10" leftIndent="0.0" alignment="CENTER"/>
4819+ <paraStyle name="TITLE_CENTER_NAME" fontName="Helvetica-Bold" fontSize="12" leading="13" leftIndent="0.0" alignment="CENTER"/>
4820+ <paraStyle
4821+ name="TITLE"
4822+ alignment="CENTER"
4823+ fontName="Helvetica"
4824+ fontSize="18.0"
4825+ leading="20"
4826+ spaceBefore="-3.0"
4827+ textColor="black"/>
4828+ </stylesheet>
4829+ <images/>
4830+ <story>
4831+ <para>[[setLang(user.lang)]]</para>
4832+
4833+ <blockTable colWidths="2.5cm,13.5cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY" repeatRows="0">
4834+ <tr noRowsplits="0">
4835+ <td>
4836+ <para style="TITLE_LEFT_ALIGN">
4837+ <font>CODE</font>
4838+ </para>
4839+ </td>
4840+ <td>
4841+ <para style="TITLES">ACCOUNT</para>
4842+ </td>
4843+ <td>
4844+ <para style="TITLE_LEFT_ALIGN">INITIAL</para>
4845+ </td>
4846+ <td>
4847+ <para style="TITLE_LEFT_ALIGN">DEBIT</para>
4848+ </td>
4849+ <td>
4850+ <para style="TITLE_LEFT_ALIGN">CREDIT</para>
4851+ </td>
4852+ <td>
4853+ <para style="TITLE_LEFT_ALIGN">BALANCE</para>
4854+ </td>
4855+ </tr>
4856+ </blockTable>
4857+
4858+ <blockTable colWidths="2.25cm,13.75cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE" repeatRows="1">
4859+<!--
4860+ [[ (a['type'] &lt;&gt; 'view') or removeParentNode('blockTable') ]]
4861+-->
4862+ <tr noRowsplits="1">
4863+ <td>
4864+ <para style="TITLES_NEW">
4865+ <font></font>
4866+ </para>
4867+ </td>
4868+ <td>
4869+ <para style="TITLES_NEW">
4870+ <font>PARTNER</font>
4871+ </para>
4872+ </td>
4873+ <td>
4874+ <para style="TITLES_NEW"></para>
4875+ </td>
4876+ <td>
4877+ <para style="TITLE_LEFT_ALIGN"></para>
4878+ </td>
4879+ <td>
4880+ <para style="TITLE_LEFT_ALIGN"></para>
4881+ </td>
4882+ <td>
4883+ <para style="TITLE_LEFT_ALIGN"></para>
4884+ </td>
4885+ </tr>
4886+ </blockTable>
4887+
4888+
4889+
4890+
4891+
4892+ <section>
4893+ <para>[[ repeatIn([x for x in lines(data['form']) if x['type'] != 'view'], 'a') ]]</para>
4894+ <blockTable colWidths="2.5cm,13.5cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY" repeatRows="0">
4895+ <tr>
4896+ <td>
4897+ <para style="TITLE_LEFT_ALIGN">
4898+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4899+ <i>[[a['label']==True and a['code'] or '' ]]</i>
4900+ </para>
4901+ </td>
4902+ <td>
4903+ <para style="TITLES">
4904+ <font>[[ ((a['total'] and not a['label']) and setTag('para','para',{'alignment':"RIGHT"}) or (a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}))) or removeParentNode('font') ]]</font>
4905+ <font>[[ a['type']=='view' and a['name'].upper() or a['name'].title() ]]</font>
4906+ </para>
4907+ </td>
4908+ <td>
4909+ <para style="TITLE_LEFT_ALIGN">
4910+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4911+ <font>[[ (a['total']==True) and formatLang(a['balanceinit'] and a['balanceinit'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4912+ </para>
4913+ </td>
4914+ <td>
4915+ <para style="TITLE_LEFT_ALIGN">
4916+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4917+ <font>[[ (a['total']==True) and formatLang(a['debit'], digits=2, grouping=True) or '']]</font>
4918+ </para>
4919+ </td>
4920+ <td>
4921+ <para style="TITLE_LEFT_ALIGN">
4922+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4923+ <font>[[ (a['total']==True) and formatLang(a['credit'], digits=2, grouping=True) or '']]</font>
4924+ </para>
4925+ </td>
4926+ <td>
4927+ <para style="TITLE_LEFT_ALIGN">
4928+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier-Bold"}) or removeParentNode('font') ]]</font>
4929+ <font>[[ (a['total']==True) and formatLang(a['balance'] and a['balance'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4930+ </para>
4931+ </td>
4932+ </tr>
4933+ </blockTable>
4934+
4935+ <section>
4936+ <para>[[ repeatIn(a['partner'], 'm') ]]</para>
4937+ <blockTable colWidths="2.25cm,13.75cm,2.5cm,2.5cm,2.5cm,2.5cm" style="BODY_LINE" repeatRows="1">
4938+<!--
4939+ [[ (a['type'] &lt;&gt; 'view') or removeParentNode('blockTable') ]]
4940+-->
4941+ <tr>
4942+ <td>
4943+ <para style="TITLES_NEW">
4944+ </para>
4945+ </td>
4946+ <td>
4947+ <para style="TITLES_NEW">
4948+ <font>[[ m['partner_name'] ]]</font>
4949+ </para>
4950+ </td>
4951+ <td>
4952+ <para style="TITLE_LEFT_ALIGN">
4953+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4954+ <font>[[ (a['total']==True) and formatLang(m['balanceinit'] and m['balanceinit'] * m.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4955+ </para>
4956+ </td>
4957+ <td>
4958+ <para style="TITLE_LEFT_ALIGN">
4959+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4960+ <font>[[ (a['total']==True) and formatLang(m['debit'], digits=2, grouping=True) or '']]</font>
4961+ </para>
4962+ </td>
4963+ <td>
4964+ <para style="TITLE_LEFT_ALIGN">
4965+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4966+ <font>[[ (a['total']==True) and formatLang(m['credit'], digits=2, grouping=True) or '']]</font>
4967+ </para>
4968+ </td>
4969+ <td>
4970+ <para style="TITLE_LEFT_ALIGN">
4971+ <font>[[ a['type']&lt;&gt;'view' and setTag('para','para',{'fontName':"Courier"}) or removeParentNode('font') ]]</font>
4972+ <font>[[ (a['total']==True) and formatLang(m['balance'] and m['balance'] * a.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or '']]</font>
4973+ </para>
4974+ </td>
4975+ </tr>
4976+ </blockTable>
4977+ </section>
4978+ <spacer length="2.5mm"/>
4979+ </section>
4980+
4981+ </story>
4982+</document>
4983
4984=== added file 'account_financial_report/report/balance_full_5_cols.rml'
4985--- account_financial_report/report/balance_full_5_cols.rml 1970-01-01 00:00:00 +0000
4986+++ account_financial_report/report/balance_full_5_cols.rml 2014-08-15 20:07:23 +0000
4987@@ -0,0 +1,158 @@
4988+<?xml version="1.0"?>
4989+<document filename="test.pdf">
4990+ <template pageSize="(21.59cm,27.94cm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
4991+ <pageTemplate id="first">
4992+ <frame id="first" x1="0.5cm" y1="1.0cm" width="20.5cm" height="23cm"/>
4993+ <pageGraphics>
4994+ <setFont name="Helvetica-Oblique" size="6"/>
4995+
4996+ <image x="1.0cm" y="24.0cm" width="5.0cm">[[company.logo and company.logo or removeParentNode('image')]]</image>
4997+<!--
4998+ <drawString x="1.0cm" y="24.5cm">[[company.logo and removeParentNode('para') or company.name]]</drawString>
4999+-->
5000+
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches

to all changes: