Skip to Content
Menu

Odoo18 Dynamic Accounting Reports

by
Odoo 48
v 18.0 Third Party 17844
Download for v 18.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Community Apps Dependencies
Lines of code 27608
Technical Name dynamic_accounts_report
LicenseLGPL-3
Websitehttps://www.cybrosys.com
Versions 13.0 14.0 15.0 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Community Apps Dependencies
Lines of code 27608
Technical Name dynamic_accounts_report
LicenseLGPL-3
Websitehttps://www.cybrosys.com
Versions 13.0 14.0 15.0 16.0 17.0 18.0
Community

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.

Odoo18 Dynamic Accounting Reports

Are you ready to make your business more organized?
Improve now!

odoo@cybrosys.com +91 9074270811
acc_bg

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
Add
  • Initial Commit

Our Services

....

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
No thousand separator
by
tjong faritno
on 5/1/25, 1:55 PM

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.


Very good app
by
Wael Marzouk
on 3/26/25, 9:08 AM

Regarding version 18, I’d like to know how to split “Expenses” into sections.

for example, 

  1. HR expense (which will contain some accounts)
  2. Operations expenses (which will contain other accounts)
  3. General Expenses (which will contain other acounts)


Thanks to give me the feedback soon

Re: Very good app
by
Cybrosys Technologies
on 3/29/25, 1:37 AM Author

Could you please send an email to odoo@cybrosys.com?


Perfect app
by
Wilfried Sip
on 11/15/24, 11:11 AM

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:67
Re: Perfect app
by
Cybrosys Technologies
on 11/22/24, 1:47 AM Author

Thanks for reporting, We have updated the app. Please get the latest version.


by
dion arya pamungkas
on 4/17/25, 5:40 AM

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:
by
Cybrosys Technologies
on 4/24/25, 6:42 AM Author

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
by
Wael Marzouk
on 3/26/25, 9:08 AM

Regarding version 18, I’d like to know how to split “Expenses” into sections.

for example, 

  1. HR expense (which will contain some accounts)
  2. Operations expenses (which will contain other accounts)
  3. General Expenses (which will contain other acounts)


Thanks to give me the feedback soon


Balance Sheet Report Issue
by
Umar Alvi
on 3/16/25, 4:46 PM

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
by
Cybrosys Technologies
on 5/14/25, 3:52 AM Author

Thanks for reporting. We have updated the app.


Balance Sheet Figures issue
by
Umar Alvi
on 3/13/25, 3:14 AM

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
by
Umar Alvi
on 3/13/25, 3:14 AM

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
by
shonpal puri
on 1/23/25, 4:36 AM

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
by
Cybrosys Technologies
on 1/24/25, 4:59 AM Author

The App is meant for the Community edition. 


by
dion arya pamungkas
on 1/22/25, 9:22 PM

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:
by
Cybrosys Technologies
on 2/6/25, 6:15 AM Author

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)
by
SO Sen
on 11/26/24, 9:36 PM


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)
by
Cybrosys Technologies
on 12/6/24, 1:11 AM Author

Thank you for informing us. We have updated the app, and you can now download the latest version.


error report on General Ledger
by
SO Sen
on 11/26/24, 12:16 AM


Re: error report on General Ledger
by
Cybrosys Technologies
on 11/26/24, 1:11 AM Author

Hello, Could you please share more details?
You can email us at odoo@cybrosys.com


Error While Installing Module
by
John Doe
on 11/6/24, 11:33 PM

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=&#39;account_budget&#39;]">' 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
by
Cybrosys Technologies
on 11/13/24, 12:08 AM Author

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.