| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 28217 |
| Technical Name |
dynamic_accounts_report |
| License | LGPL-3 |
| Website | https://www.cybrosys.com |
| Versions | 13.0 14.0 15.0 16.0 17.0 18.0 |
Dynamic Reports for Trial Balance, Profit and Loss, General Ledger, Tax Report, etc.
Odoo18 Dynamic Accounting Reports
Key Highlights
Various Filters to Compare
Option to compare report values with various filtering tools available.
Print reports in PDF and XLSX Format
You can print the reports in both the PDF and XLSX format.
Access the Journal Entries
Easy access to the corresponding journal entries directly from the dynamic report view.
Drill-down Approach in Reports
The user can drill down from the main report to the journal entries. You can open the form view of each journal entry and view the complete details here.
Are you ready to make your business more
organized?
Improve now!
odoo@cybrosys.com
+91 9074270811
Dynamic Financial Reports Menu
General Ledger Report
General Ledger Drill-Down View
Option to View Journal Entry in General Ledger
General Ledger Journal Entry
Trial Balance Report
General Ledger view from Trial Balance.
Trial Balance PDF Report
Trial Balance Excel Report
Balance sheet Report
Balance Sheet Drill-Down View
General Ledger from Balance Sheet
Balance Sheet PDF Report
Balance Sheet Excel Report
Profit and Loss Report
Profit and Loss Drill-Down View
General Ledger from Profit and Loss
Profit and Loss PDF Report
Profit and Loss Excel Report
Partner Ledger Report
Partner Ledger Drill-Down View
Open the corresponding partner by clicking Open
Open the corresponding Jornal Items by clicking Jornal Items
Partner Ledger PDF Report
Partner Ledger Excel Report
Aged Receivable Report
Aged Receivable Drill-Down View
Open the corresponding partner by clicking Open
Open the Jornal Items by clicking Jornal Items
Aged Receivable PDF Report
Aged Receivable Excel Report
Aged Payable Report
Aged Payable Drill-Down View
Open the corresponding partner by clicking Open
Open the Jornal Items by clicking Jornal Items
Aged Payable PDF Report
Aged Payable Excel Report
Cash Book Report
Cash Book Drill-Down View
Cash Book PDF Report
Cash Book Excel Report
Bank Book Report
Bank Book Drill-Down View
Bank Book PDF Report
Bank Book Excel Report
Tax Report
Tax PDF Report
Tax Excel Report
Various Filters to Compare.
Print reports in PDF Format.
Print reports in XLSX Format.
Access the Journal Entries.
Drill-down Approach in Reports.
Real-Time Data Updates.
Latest Release 18.0.1.0.0
16th October, 2024- Initial Commit
Please log in to comment on this module
Thank you
Hello Team There is a problem with the Trail Balance in the filter and the balance of the first period at the start of work, for example on 1-8-2025, and I chose the date, it displays its opening credits before that date, Odoo 18.
Re: Thank you
We have updated the module, and you can now download the latest version.
Waiting for version 19
Hi Team,
I'm using your Dynamic Account Reporting module on Odoo 18 Community, and I'm facing an issue specifically with the Trial Balance report.
When I apply a comparison filter like “Last Year”, the correct start_date and end_date are passed to the backend, and the response from the get_filter_values method contains the updated account balances. However, the UI does not update — it continues to show the same values.
It seems the frontend is not refreshing or rendering the updated data returned from the backend. Could you please check if this is a known issue? And if the Trial Balance widget is expected to re-render after filter changes?
Thanks in advance.
Re:
Hello Arya, Thanks for reporting. We have updated the app. Please get the latest version.
No thousand separator
Hi,
Thank you for the hard work your team has put in. I would greatly appreciate it if you could add a thousand separator to your module, as it is crucial for our needs.
Thank you in advance for considering this adjustment.
Re: No thousand separator
Thousand separators have been successfully added to the reports. Please download the latest version from the Odoo Apps Store.
Very good app
Regarding version 18, I’d like to know how to split “Expenses” into sections.
for example,
Thanks to give me the feedback soon
Re: Very good app
Could you please send an email to odoo@cybrosys.com?
Perfect app
The app is working perfect but it is giving me a problem with the module of website.
If i install the module and try to edit the website if give me the following error, please let me know what to do, thank you.
Odoo Client Error
UncaughtPromiseError > TypeError
Uncaught Promise > $(...).getScrollingElement is not a function
TypeError: $(...).getScrollingElement is not a function at WebsiteSnippetsMenu.start (https://xxx.xxx.com/web/assets/1/06d8698/website.backend_assets_all_wysiwyg.min.js:2477:155) at WebsiteSnippetsMenu.start (https://xxx.xxx.com/web/assets/1/06d8698/website.backend_assets_all_wysiwyg.min.js:3254:13) at WebsiteSnippetsMenu.<anonymous> (https://xxx.xxx.com/web/assets/1/06d8698/website.backend_assets_all_wysiwyg.min.js:2470:4738) at RootFiber.complete (https://xxx.xxx.com/web/assets/1/bd57389/web.assets_web.min.js:981:196) at Scheduler.processFiber (https://xxx.xxx.com/web/assets/1/bd57389/web.assets_web.min.js:1554:43) at Scheduler.processTasks (https://xxx.xxx.com/web/assets/1/bd57389/web.assets_web.min.js:1548:62) at https://xxx.xxx.com/web/assets/1/bd57389/web.assets_web.min.js:1545:67Re: Perfect app
Thanks for reporting, We have updated the app. Please get the latest version.
error in export Excel
TypeError: XLSXReportController.get_report_xlsx() missing 1 required positional argument: 'options'
2025-11-03 19:50:32,286 1250468 ERROR new2rehab odoo.sql_db: bad query: b"\n SELECT latest_version\n FROM ir_module_module\n WHERE name='base'\n "
ERROR: relation "ir_module_module" does not exist
LINE 3: FROM ir_module_module
^
Re: error in export Excel
Sorry, we were unable to reproduce the problem on our end. To help us investigate further, could you please provide additional details on the issue? If possible, kindly share a screen recording or relevant screenshots showing the steps that lead to the problem.
You can email odoo@cybrosys.com.
This error message also appears in most other accounting reports, not only in the Trial Balance.
RPC_ERROR when opening Trial Balance report in Arabic language, and total values disappear in both Arabic and English (Odoo 18)
🐞 Issue Description:
When the system interface is set to Arabic, opening or refreshing the Trial Balance report in Odoo 18 (Community Edition) triggers an internal server error (RPC_ERROR).
However, when the system is set to English, the report loads without an RPC error.
In addition, when using the “Total” filter, the total row disappears completely from the report — this issue occurs in both Arabic and English interfaces.
⚙️ Error Details:
RPC_ERROR Odoo Server Error Occured on localhost:8069 on model account.trial.balance on 2025-10-31 14:22:03 GMT Traceback (most recent call last): File "C:\Program Files\Odoo 18.0.20250920\server\odoo\http.py", line 2144, in _transactioning return service_model.retrying(func, env=self.env) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\server\odoo\service\model.py", line 156, in retrying result = func() ^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\server\odoo\http.py", line 2111, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\server\odoo\http.py", line 2359, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\server\odoo\addons\base\models\ir_http.py", line 333, in _dispatch result = endpoint(**request.params) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\server\odoo\http.py", line 754, in route_wrapper result = endpoint(self, *args, **params_ok) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\server\odoo\addons\web\controllers\dataset.py", line 36, in call_kw return call_kw(request.env[model], method, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\server\odoo\api.py", line 535, in call_kw result = getattr(recs, name)(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "c:\program files\odoo 18.0.20250920\server\dynamic_accounting_reports\dynamic_accounts_report\models\account_trial_balance.py", line 135, in get_filter_values 0] if comparison_type == 'year' else datetime.strptime( ^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20250920\python\Lib\_strptime.py", line 333, in _strptime raise ValueError("time data '' does not match format '%Y-%m-%d'") ValueError: time data '' does not match format '%Y-%m-%d' The above server error caused the following client error: RPC_ERROR: Odoo Server Error RPC_ERROR at makeErrorFromResponse (http://localhost:8069/web/assets/e8792a3/web.assets_web.min.js:3151:163) at XMLHttpRequest.<anonymous> (http://localhost:8069/web/assets/e8792a3/web.assets_web.min.js:3156:13)Ada error ini :
Odoo Server Error
RPC_ERROR
Odoo Server Error
Occured on 192.168.23.86:8020 on model ir.module.module and id 14 on 2025-04-17 09:37:46 GMT
Traceback (most recent call last): File "/usr/lib/python3/dist-packages/odoo/http.py", line 1963, in _transactioning return service_model.retrying(func, env=self.env) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 156, in retrying result = func() ^^^^^^ File "/usr/lib/python3/dist-packages/odoo/http.py", line 1930, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/http.py", line 2178, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 333, in _dispatch result = endpoint(**request.params) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/http.py", line 727, in route_wrapper result = endpoint(self, *args, **params_ok) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 42, in call_button action = call_kw(request.env[model], method, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/api.py", line 533, in call_kw result = getattr(recs, name)(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/decorator.py", line 232, in fun return caller(func, *(extras + args), **kw) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_module.py", line 75, in check_and_log return method(self, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_module.py", line 480, in button_immediate_install return self._button_immediate_function(self.env.registry[self._name].button_install) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_module.py", line 604, in _button_immediate_function registry = modules.registry.Registry.new(self._cr.dbname, update_module=True) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/decorator.py", line 232, in fun return caller(func, *(extras + args), **kw) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 97, in locked return func(inst, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 127, in new odoo.modules.load_modules(registry, force_demo, status, update_module) File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 484, in load_modules processed_modules += load_marked_modules(env, graph, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 365, in load_marked_modules loaded, processed = load_module_graph( ^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 186, in load_module_graph load_openerp_module(package.name) File "/usr/lib/python3/dist-packages/odoo/modules/module.py", line 384, in load_openerp_module __import__(qualname) File "/mnt/ins-addons/base_accounting_kit/__init__.py", line 24, in <module> from . import wizard File "/mnt/ins-addons/base_accounting_kit/wizard/__init__.py", line 36, in <module> from . import import_bank_statement File "/mnt/ins-addons/base_accounting_kit/wizard/import_bank_statement.py", line 31, in <module> from qifparse.parser import QifParser ModuleNotFoundError: No module named 'qifparse'Re:
It was related to the accounting kit app. We have updated that app with the external dependency. You can resolve it by simply installing the package using:
"pip install qifparse"
Very good app
Regarding version 18, I’d like to know how to split “Expenses” into sections.
for example,
Thanks to give me the feedback soon
Balance Sheet Report Issue
Balance sheet report is not showing as on to date data for community edition odoo18. Even filters for previous year or current year isn't working as well.
Can you update on it?
Re: Balance Sheet Report Issue
Thanks for reporting. We have updated the app.
Balance Sheet Figures issue
Hi,
Balance sheet report filters might not working properly as its populating only current years figures in report. Its not commulating all years figures plus also not showing balance sheet from previous years.
Balance Sheet Figures issue
Hi,
Balance sheet report filters might not working properly as its populating only current years figures in report. Its not commulating all years figures plus also not showing balance sheet from previous years.
Table name 'account_common_journal_report_account_report_horizontal_group_rel' is too long. When trying to install module
Validation Error
Table name 'account_common_journal_report_account_report_horizontal_group_rel' is too long
Re: Table name 'account_common_journal_report_account_report_horizontal_group_rel' is too long. When trying to install module
The App is meant for the Community edition.
i have installed this module, when i check on Balance Sheet and Profit and Loss, and filter date from 01/01/2024 until 12/31/2024, it doesn't show data from last year, but when i check on General Legder and filter it from 01/01/2024 until 12/31/2024, it show the data.
why the filter on Balance Sheet an Profit and Loss not working?
Re:
The app has been updated in the App Store.
Odoo Client Error UncaughtPromiseError > ReferenceError Uncaught Promise > $ is not defined Occured on 192.168.88.96:8069 on 2024-11-27 02:35:12 GMT ReferenceError: $ is not defined at GeneralLedger.applyFilter (http://192.168.88.96:8069/web/assets/0ef07d1/web.assets_web.min.js:22406:213)
Re: Odoo Client Error UncaughtPromiseError > ReferenceError Uncaught Promise > $ is not defined Occured on 192.168.88.96:8069 on 2024-11-27 02:35:12 GMT ReferenceError: $ is not defined at GeneralLedger.applyFilter (http://192.168.88.96:8069/web/assets/0ef07d1/web.assets_web.min.js:22406:213)
Thank you for informing us. We have updated the app, and you can now download the latest version.
error report on General Ledger
Re: error report on General Ledger
Hello, Could you please share more details?
You can email us at odoo@cybrosys.com
Error While Installing Module
Below is the error I get while installing the module, please advise how to fix.
Odoo Server Error
Occured on localhost:8069 on model ir.module.module and id 17 on 2024-11-07 04:31:27 GMT
Traceback (most recent call last): File "C:\Program Files\Odoo 18.0.20241105\server\odoo\http.py", line 1954, in _transactioning return service_model.retrying(func, env=self.env) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\service\model.py", line 137, in retrying result = func() ^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\http.py", line 1921, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\http.py", line 2168, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\addons\base\models\ir_http.py", line 329, in _dispatch result = endpoint(**request.params) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\http.py", line 727, in route_wrapper result = endpoint(self, *args, **params_ok) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\addons\web\controllers\dataset.py", line 40, in call_button action = call_kw(request.env[model], method, args, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\api.py", line 517, in call_kw result = getattr(recs, name)(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\python\Lib\site-packages\decorator.py", line 232, in fun return caller(func, *(extras + args), **kw) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\addons\base\models\ir_module.py", line 75, in check_and_log return method(self, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\addons\base\models\ir_module.py", line 480, in button_immediate_install return self._button_immediate_function(self.env.registry[self._name].button_install) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\addons\base\models\ir_module.py", line 604, in _button_immediate_function registry = modules.registry.Registry.new(self._cr.dbname, update_module=True) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\python\Lib\site-packages\decorator.py", line 232, in fun return caller(func, *(extras + args), **kw) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\tools\func.py", line 97, in locked return func(inst, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\modules\registry.py", line 131, in new odoo.modules.load_modules(registry, force_demo, status, update_module) File "C:\Program Files\Odoo 18.0.20241105\server\odoo\modules\loading.py", line 479, in load_modules processed_modules += load_marked_modules(env, graph, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\modules\loading.py", line 363, in load_marked_modules loaded, processed = load_module_graph( ^^^^^^^^^^^^^^^^^^ File "C:\Program Files\Odoo 18.0.20241105\server\odoo\modules\loading.py", line 226, in load_module_graph load_data(env, idref, mode, kind='data', package=package) File "C:\Program Files\Odoo 18.0.20241105\server\odoo\modules\loading.py", line 70, in load_data tools.convert_file(env, package.name, filename, idref, mode, noupdate, kind) File "C:\Program Files\Odoo 18.0.20241105\server\odoo\tools\convert.py", line 608, in convert_file convert_xml_import(env, module, fp, idref, mode, noupdate) File "C:\Program Files\Odoo 18.0.20241105\server\odoo\tools\convert.py", line 679, in convert_xml_import obj.parse(doc.getroot()) File "C:\Program Files\Odoo 18.0.20241105\server\odoo\tools\convert.py", line 594, in parse self._tag_root(de) File "C:\Program Files\Odoo 18.0.20241105\server\odoo\tools\convert.py", line 548, in _tag_root raise ParseError(msg) from None # Restart with "--log-handler odoo.tools.convert:DEBUG" for complete traceback ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ odoo.tools.convert.ParseError: while parsing file:/c:/program%20files/odoo%2018.0.20241105/server/odoo/addons/base_accounting_kit/views/res_config_settings_views.xml:3 Error while parsing or validating view: Element '<xpath expr="//setting[@id='account_budget']">' cannot be located in parent view View error context: {'file': 'c:\\program files\\odoo ' '18.0.20241105\\server\\odoo\\addons\\base_accounting_kit\\views\\res_config_settings_views.xml', 'line': 1, 'name': 'res.config.view.inherited.base.accounting.kit', 'view': ir.ui.view(3352,), 'view.model': 'res.config.settings', 'view.parent': ir.ui.view(1299,), 'xmlid': 'res_config_settings_view_form_base_accounting_kit'} The above server error caused the following client error: RPC_ERROR: Odoo Server Error RPC_ERROR at makeErrorFromResponse (http://localhost:8069/web/assets/9bda9fd/web.assets_web.min.js:3072:163) at XMLHttpRequest.<anonymous> (http://localhost:8069/web/assets/9bda9fd/web.assets_web.min.js:3077:13)Close
Re: Error While Installing Module
It happens when there is some conflict with other custom addons. Do you have any in your database? Please let us know. You can email us at odoo@cybrosys.com.