Account Financial Reports
by Camptocamp https://github.com/OCA/account-financial-reporting , initOS GmbH https://github.com/OCA/account-financial-reporting , redCOR AG https://github.com/OCA/account-financial-reporting , ForgeFlow https://github.com/OCA/account-financial-reporting , Odoo Community Association (OCA) https://github.com/OCA/account-financial-reportingAvailability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
Community Apps Dependencies | Show |
Lines of code | 10022 |
Technical Name |
account_financial_report |
License | AGPL-3 |
Website | https://github.com/OCA/account-financial-reporting |
Versions | 11.0 12.0 13.0 14.0 15.0 16.0 17.0 |
Account Financial Reports
This module adds a set of financial reports. They are accessible under Invoicing / Reporting / OCA accounting reports.
- General ledger
- Trial Balance
- Open Items
- Aged Partner Balance
- VAT Report
- Journal Ledger
Currently General ledger, Trial Balance and Open Items are fully compatible with a foreign currency set up in account in order to display balances. Moreover, any foreign currency used in account move lines is properly shown.
In case that in an account has not been configured a second currency foreign currency balances are not available.
Table of contents
Known issues / Roadmap
- ‘VAT Report’ is valid only for cases where it’s met that for each Tax defined: all the “Account tags” of all the ‘Repartition for Invoices’ or ‘Repartition for Credit Notes’ are different.
- It would be nice to have in reports a column indicating the state of the entries when the option “All Entries” is selected in “Target Moves” field in a wizard
Changelog
11.0.2.5.0 (2019-04-26)
- In the Trial Balance you have an option to hide parent hierarchy levels
11.0.2.4.1 (2019-01-08)
- Handle better multicompany behaviour
- Improve how title appears in the reports
- Improve performance in General Ledger
11.0.2.3.1 (2018-11-29)
- In the Trial Balance you can apply a filter by hierarchy levels
- In the General Ledger you can apply a filter by Analytic Tag
- In the Journal Ledger the field ‘Journal’ is now optional
Bug Tracker
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Credits
Authors
- Camptocamp
- initOS GmbH
- redCOR AG
- ForgeFlow
Contributors
- Jordi Ballester <jordi.ballester@forgeflow.com>
- Yannick Vaucher <yannick.vaucher@camptocamp.com>
- Simone Orsi <simone.orsi@abstract.com>
- Leonardo Pistone <leonardo.pistone@camptocamp.com>
- Damien Crier <damien.crier@camptocamp.com>
- Andrea Stirpe <a.stirpe@onestein.nl>
- Thomas Rehn <thomas.rehn@initos.com>
- Andrea Gallina <4everamd@gmail.com>
- Robert Rottermann <robert@redcor.ch>
- Ciro Urselli <c.urselli@apuliasoftware.it>
- Francesco Apruzzese <opencode@e-ware.org>
- Lorenzo Battistini <https://github.com/eLBati>
- Julien Coux <julien.coux@camptocamp.com>
- Akim Juillerat <akim.juillerat@camptocamp.com>
- Alexis de Lattre <alexis@via.ecp.fr>
- Mihai Fekete <feketemihai@gmail.com>
- Miquel Raïch <miquel.raich@forgeflow.com>
- Joan Sisquella <joan.sisquella@forgeflow.com>
- Tecnativa:
- Pedro M. Baeza
- Sergio Teruel
- Ernesto Tejeda
- Alexandre D. Díaz
- Víctor Martínez
- Lois Rilo <lois.rilo@forgeflow.com>
- Sygel:
- Harald Panten
- Valentin Vinagre
Much of the work in this module was done at a sprint in Sorrento, Italy in April 2016.
Maintainers
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.
This module is part of the OCA/account-financial-reporting project on GitHub.
You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedThis App depends on the "Date Range" app, which is no longer available? Please advise?
Nice reports, except one bug
Hello, When I open contact, and sellect Open items report generation from actions, or if I select partner filter in report form view, I get this error: 500: Internal Server Error Traceback Traceback (most recent call last): File "/odoo/odoo-server/odoo/addons/base/models/ir_http.py", line 229, in _dispatch result = request.dispatch() File "/odoo/odoo-server/odoo/http.py", line 804, in dispatch r = self._call_function(**self.params) File "/odoo/odoo-server/odoo/http.py", line 345, in _call_function return checked_call(self.db, *args, **kwargs) File "/odoo/odoo-server/odoo/service/model.py", line 93, in wrapper return f(dbname, *args, **kwargs) File "/odoo/odoo-server/odoo/http.py", line 338, in checked_call result = self.endpoint(*a, **kw) File "/odoo/odoo-server/odoo/http.py", line 910, in __call__ return self.method(*args, **kw) File "/odoo/odoo-server/odoo/http.py", line 510, in response_wrap response = f(*args, **kw) File "/odoo/custom/addons/report_xlsx/controllers/main.py", line 49, in report_routes reportname, docids, converter, **data File "/odoo/odoo-server/odoo/http.py", line 510, in response_wrap response = f(*args, **kw) File "/odoo/odoo-server/addons/web/controllers/main.py", line 1952, in report_routes html = report.with_context(context).render_qweb_html(docids, data=data)[0] File "/odoo/odoo-server/odoo/addons/base/models/ir_actions_report.py", line 757, in render_qweb_html data = self._get_rendering_context(docids, data) File "/odoo/odoo-server/odoo/addons/base/models/ir_actions_report.py", line 774, in _get_rendering_context data.update(report_model._get_report_values(docids, data=data)) File "/odoo/custom/addons/account_financial_report/report/open_items.py", line 344, in _get_report_values account_ids, partner_ids, date_at_object, target_move, company_id, date_from File "/odoo/custom/addons/account_financial_report/report/open_items.py", line 203, in _get_data self._cr.execute(query) File "/odoo/odoo-server/odoo/sql_db.py", line 163, in wrapper return f(self, *args, **kwargs) File "/odoo/odoo-server/odoo/sql_db.py", line 240, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: syntax error at or near ")" LINE 11: and aml.partner_id in (40,) and am.state = 'posted'... ^
v15 Upgrade
Hello,
Is this app going to be upgraded to v15 any time soon?