Merge lp:~vauxoo/account-financial-report/7.0-afr-multicurrency-dev-1985-kty into lp:~vauxoo/account-financial-report/vxafr
- 7.0-afr-multicurrency-dev-1985-kty
- Merge into 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 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Katherine Zaoral (Vauxoo) | Approve | ||
Review via email: mp+231019@code.launchpad.net |
Commit message
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 : | # |
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' |
948 | Binary 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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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'] <> '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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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'] <> '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']<>'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']<>'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']<>'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'] <> '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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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'] <> '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<>'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<>'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<>'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<>'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<>'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<>'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'] <> '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']<>'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']<>'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']<>'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']<>'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']<>'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']<>'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'] <> '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']<>'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']<>'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']<>'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']<>'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.
LGTM