v 16.0 Third Party 10726
Download for v 16.0 Deploy on Odoo.sh Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Community Apps Dependencies
Lines of code 22149
Technical Name dynamic_accounts_report
LicenseLGPL-3
Websitehttps://www.cybrosys.com
Versions 14.0 15.0 13.0 16.0 17.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 22149
Technical Name dynamic_accounts_report
LicenseLGPL-3
Websitehttps://www.cybrosys.com
Versions 14.0 15.0 13.0 16.0 17.0
Community

Odoo 16 Dynamic Financial Reports

A Module for accounting reports

Explore This Module

Overview

The Financial Reports module helps in accessing the various reports in the Odoo Community edition, which supports a dynamic view. You can use the Filters and Group by tools to get the data according to your requirement. Moreover, the reports which can be accessed are Dynamic Accounting General Ledger, Trial Balance, Balance Sheet, Profit and Loss, Cash Flow Statements, Partner Ledger, Partner Ageing, Daybook, Bankbook, and Cashbook Reports in Odoo 14 community edition. Additionally, the users can also print the reports in PDF and XLSX Format.

Features

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.
Configurable Financial Reports Backend configuration for financial reports, you can configure the hierarchy of financial reports.
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.

Screenshots

Dynamic Financial Reports Menu

Financial Reports Configuration

General Ledger

General Ledger Drill-Down View

Filters in General Ledger

(Custom Date Range, Journals, Accounts, Analytic Accounts, Analytic Tags & Target Move)

Option to view source move in General Ledger

General Ledger Journal Entry

Trial Balance Report

General Ledger view from Trial Balance

General Ledger Wizard with Drill-down view

Filters Applied in Trial Balance

Custom Date Range, Journals & Target Move )

Journal Entry from Trial Balance

Trial Balance PDF Report

Trial Balance XLSX Report

Balance Sheet

View General Ledger from Balance Sheet

General Ledger Wizard with Drill down view

Filters Applied in Balance Sheet

(Custom Date Range, Journals, Accounts, Account Tags, Analytic Accounts, Analytic Tags & Target Move)

Balance Sheet PDF Report

Balance Sheet XLSX Report

Profit and Loss Account

View General Ledger from Balance Sheet

Filters Applied in Profit and Loss

(Custom Date Range, Journals, Accounts, Account Tags, Analytic Accounts, Analytic Tags & Target Move)

View General Ledger from Profit and Loss

View Source Move from General Ledger Wizard

Profit and Loss PDF Report

Profit and Loss XLSX Report

Partner Ledger Report

Partner Ledger Drill Down view

Filters in Partner Ledger

(Custom Date Range, Partner, Accounts, Account Tags, Analytic Accounts, Analytic Tags & Target Move)

View Source move from Partner Ledger

Journal Entry from Partner Ledger

Partner Ledger PDF Report

Partner Ledger XLSX Report

Aged Partner Balance Report

Aged Partner Balance Drill Down

Filters in Partner Ageing Report

(Custom Date Range, Partners, Partner Tags, Account Type, & Target Move)

View source move from Partner Ageing

Partner Ageing PDF Report

Partner Ageing XLSX Report

Cash Flow Statements Report

Cash Flow Statements Drill Down view

Filters in Cash Flow Statement

Cash Flow Statement PDF Report

Cash Flow Statement XLSX Report

Cash Book Report

Filters in Cash Book Report

(Custom Date Range, Accounts, Journals, Analytic Accounts, Anlaytic Tags & Target Move)

Cash Book Report Drill Down view

Journal Entry from Cash Book Report

Cash Book PDF Report

Cash Book XLSX Report

Bank Book Report

Filters in Bank Book Report

(Custom Date Range, Accounts, Journals, Analytic Accounts, Anlaytic Tags & Target Move)

Bank Book Report Drill Down view

View Source move from Bank Book Report

Journal Entry from Bank Book Report

Bank Book PDF Report

Bank Book XLSX Report

Day Book Report

Filters in Day Book Report

Day Book Report Drill Down view

View Source move from Day Book Report

Journal Entry from Day Book Report

Day Book PDF Report

Day Book XLSX Report

Related Products

Suggested Products


Our Services

Odoo Customization
Odoo Implementation
Odoo Support
Hire Odoo Developer
Odoo Integration
Odoo Migration
Odoo Consultancy
Odoo Implementation
Odoo Licensing Consultancy

Our Industries

Trading

Easily procure and sell your products

POS

Easy configuration and convivial experience

Education

A platform for educational management

Manufacturing

Plan, track and schedule your operations

E-commerce & Website

Mobile friendly, awe-inspiring product pages

Service Management

Keep track of services and invoice

Restaurant

Run your bar or restaurant methodically

Hotel Management

An all-inclusive hotel management application

Support

Need Help?

Got questions or need help? Get in touch.

odoo@cybrosys.com

WhatsApp

Say hi to us on WhatsApp!

+91 86068 27707

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.
Filters doesn't work in General Ledger
by
Abdullah BinShehab
on 1/18/24, 6:46 AM

When we try using filters in General Ledger we go t this error:

TypeError: Cannot set properties of null (setting 'value')
    at Class.apply_filter (http://localhost:8069/web/assets/458-20adca2/web.assets_backend.min.js:16567:45)
    at HTMLButtonElement. (http://localhost:8069/web/assets/401-4df2d41/web.assets_common.min.js:5901:11)
    at HTMLDivElement.dispatch (http://localhost:8069/web/assets/401-4df2d41/web.assets_common.min.js:2459:447)
    at elemData.handle (http://localhost:8069/web/assets/401-4df2d41/web.assets_common.min.js:2445:166)




Analytic Account / Financial Reports Bug
by
Nasser Tahan
on 12/3/23, 1:07 PM

Hello there,

I have found a bug that shows multiple lines of the same account in the financial reports.

Trigger: Add analytic accounts to the invoice  
https://drive.google.com/file/d/18UHhObfke6d1Jz8ko3ozFrr1P7A1WssW/view?usp=sharing

Effect: multiple lines of the same account in the financial reports 

https://drive.google.com/drive/folders/1AS0w3lStagXFtZ1dixZxPFsi6J_d_pcl?usp=sharing

I'm using the latest version of the module.

Re: Analytic Account / Financial Reports Bug
by
Cybrosys Technologies
on 12/4/23, 12:39 AM Author

We have updated the module. Please get the latest version.


Duplicated records
by
aymanhammo@gmail.com
on 10/25/23, 7:17 AM

In "Profit & Loss" and "Balance Sheet" reports it shows multiple lines for each account instead of grouping them.


Check here:https://drive.google.com/drive/folders/1AS0w3lStagXFtZ1dixZxPFsi6J_d_pcl?usp=sharing

Re: Duplicated records
by
Cybrosys Technologies
on 10/25/23, 7:52 AM Author

Please check your financial report configuration


errors in version 16
by
Adrian Porras
on 8/7/23, 3:19 PM

Hello, your module in version 16 has problems in translation and views, because if you completely translate the module into Spanish Mexico, for some reason the views of the Profit and loss and balance sheet reports are blocked, I was tracking the error and I I realized that if you translate the action of balance sheet and profit and loss to another language, it is what causes the views to be blocked... I also realized that the fields that they placed above the "apply" button, (range of dates, accounts, Diaries, etc...) when you put a condition, for example a range of dates, and click the apply button, an error appears TypeError: Cannot read properties of undefined (reading '0'), I am seeing that in their qweb reports, they did not add the foreach of o...

Re: errors in version 16
by
Cybrosys Technologies
on 9/13/23, 2:48 AM Author

Hello Adrian, Thanks for reporting. We have updated the module.


Good one, thanks for make it open source.
by
Pahal Solutions
on 7/14/23, 2:02 AM


Re: Good one, thanks for make it open source.
by
Cybrosys Technologies
on 7/14/23, 5:04 AM Author

Thanks for the feedback.


Thank you
by
Ahmad Fatoni Febri Wihando
on 6/9/23, 8:30 AM

Thank you, this is really great

Re: Thank you
by
Cybrosys Technologies
on 6/12/23, 5:09 AM Author

Thanks for the feedback.


Profit and loss report issue
by
vbhvpy@gmail.com
on 4/3/23, 10:43 AM

Hello,
We are using this module, in profit and loss reporting 400001 - Cost of Goods Sold in Trading  account which has type Cost of Revenue is appearing in the Income and Expense both sections, Ideally it should be appear in only one section. i took latest module too still facing same issue.
Kindly advise As early as possible ....
Thank you & Regards

Re: Profit and loss report issue
by
Cybrosys Technologies
on 5/29/23, 12:34 AM Author

Hello, We cannot reproduce the case you mentioned with this app. Could you please check your account configuration?


Everything Left Aligned in Database
by
Owais Ahmed
on 1/21/23, 11:06 AM

When I installed this module in my v16 Community Database Everything in Database got left aligned include PO,SO, Invoice etc



Re: Everything Left Aligned in Database
by
Cybrosys Technologies
on 3/31/23, 6:52 AM Author

Hello, We have updated the module. Please get the latest version


Good
by
Mustafa Mahmoud Abbas Obeid
on 1/2/23, 6:23 AM

by
Abdullah BinShehab
on 1/18/24, 6:44 AM



Filters doesn't work in General ledger
by
Abdullah BinShehab
on 1/18/24, 6:42 AM

When we try to use Account filter in General ledger: We got this error:

 Cannot set properties of null (setting 'value') 

TypeError: Cannot set properties of null (setting 'value')
    at Class.apply_filter (http://localhost:8069/web/assets/458-20adca2/web.assets_backend.min.js:16567:45)
    at HTMLButtonElement. (http://localhost:8069/web/assets/401-4df2d41/web.assets_common.min.js:5901:11)
    at HTMLDivElement.dispatch (http://localhost:8069/web/assets/401-4df2d41/web.assets_common.min.js:2459:447)
    at elemData.handle (http://localhost:8069/web/assets/401-4df2d41/web.assets_common.min.js:2445:166)



by
Abdullah BinShehab
on 1/18/24, 6:30 AM



Still broken.
by
Paul Marshall
on 1/10/24, 5:20 AM

Still broken after several updates. None of the filter buttons or line expanders work. I uninstalled the module and now I have no reports. Cybrosys are sloppy developers. I have encountered bugs in several of their apps. They take weeks to respond to support requests. Like most offshore Odoo developers they have no accountability and simply pass blame.

Re: Still broken.
by
Cybrosys Technologies
on 1/12/24, 12:58 AM Author

Hello Paul, 
We have checked our system. We found a few emails from you. Most of them complain about the compatibility with other apps. As we all know we cannot make all the apps compatible. And we are sorry for the delay in response, We are trying our best to respond as soon as possible.


Analytic Account / Financial Reports Bug
by
Nasser Tahan
on 11/14/23, 3:19 AM

Hello there,

I have found a bug that shows multiple lines of the same account in the financial reports.

Trigger: Add analytic accounts to the invoice  https://drive.google.com/file/d/18UHhObfke6d1Jz8ko3ozFrr1P7A1WssW/view?usp=sharing

Effect: multiple lines of the same account in the financial reports 

https://drive.google.com/drive/folders/1AS0w3lStagXFtZ1dixZxPFsi6J_d_pcl?usp=sharing

I'm using the latest version of the module.

Re: Analytic Account / Financial Reports Bug
by
Cybrosys Technologies
on 1/1/24, 5:14 AM Author

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


financial report configuration
by
Nasser Tahan
on 11/12/23, 5:30 AM

Hello there,

How can I reach financial report configuration page, I looked everywhere but I can't seem to reach it.

Re: financial report configuration
by
Cybrosys Technologies
on 11/14/23, 12:01 AM Author

First, navigate to the configuration menu. Then select account reports under accounting in the configuration menu. Here we can see financial reports, select desired financial reports and configure the required field


Errors + Performance Issues
by
aymanhammo@gmail.com
on 10/12/23, 3:24 AM

Hello there,

I've been trying to work with the reports you provided which have a great interface. But there are so many problems that make it unusable:

  • General Ledger crashes the whole server (CPU usage goes up to 100%, SSH, and services all hang up until the server is restarted)
  • Filters do not apply on all reports and show an error like on profit and loss report (Check below)
  • Partner ledger report shows an error (Check below)

Filters error:

TypeError: Cannot read properties of undefined (reading '0') at Class.apply_filter (https://domain.com/web/assets/debug/web.assets_backend.js:221692:43) (https://domain.com/web/assets/debug/web.assets_backend.js:221692) at HTMLButtonElement. (https://domain.com/web/assets/debug/web.assets_common.js:73698:23) (/web/static/src/legacy/js/core/mixins.js:277) at HTMLDivElement.dispatch (https://domain.com/web/assets/debug/web.assets_common.js:27771:27) (/web/static/lib/jquery/jquery.js:5183) at elemData.handle (https://domain.com/web/assets/debug/web.assets_common.js:27579:28) (/web/static/lib/jquery/jquery.js:4991)

Partner Ledger Error:

Error: QWeb2 - template['PLFilterView']: No enumerator given to foreach
    at Object.exception (https://domain.com/web/assets/debug/web.assets_common.js:68099:19) (/web/static/lib/qweb/qweb2.js:48)
    at Object.foreach (https://domain.com/web/assets/debug/web.assets_common.js:68261:22) (/web/static/lib/qweb/qweb2.js:210)
    at Engine.eval (eval at _render (https://domain.com/web/assets/debug/web.assets_common.js:68523:33), :78:23) (/web/static/lib/qweb/qweb2.js:472)
    at Engine._render (https://domain.com/web/assets/debug/web.assets_common.js:68512:58) (/web/static/lib/qweb/qweb2.js:461)
    at Engine.render (https://domain.com/web/assets/debug/web.assets_common.js:68504:26) (/web/static/lib/qweb/qweb2.js:453)
    at https://domain.com/web/assets/debug/web.assets_backend.js:221955:65 (https://domain.com/web/assets/debug/web.assets_backend.js:221955)
Re: Errors + Performance Issues
by
Cybrosys Technologies
on 10/18/23, 5:40 AM Author
This may occur due to low specification for the server of the client and the huge number of records. 
Could you please share the details with odoo@cybrosys.com?

Incorrect Accounting Entry when Purchased order Booked
by
Rai Murtaza
on 10/12/23, 2:25 AM

Hi,

I am using 16 versions of this module and configured proper accounts on each point but when I purchase orders booked Accounting entry is not made perfectly. My issue occurred on average costing method with automated. At the time of vendor bill creation total value hit on the cost of goods sold account. please check your support will be highly appreciated

Thanks

Re: Incorrect Accounting Entry when Purchased order Booked
by
Cybrosys Technologies
on 11/1/23, 2:49 AM Author

We have checked your problem, and we believe the issue may be related to your configuration. Our module does not have any functions that trigger when creating a purchase order. If you could provide more context or details, we can take a closer look and assist you further.


by
Adrian Porras
on 8/7/23, 3:19 PM

Hello, your module in version 16 has problems in translation and views, because if you completely translate the module into Spanish Mexico, for some reason the views of the Profit and loss and balance sheet reports are blocked, I was tracking the error and I I realized that if you translate the action of balance sheet and profit and loss to another language, it is what causes the views to be blocked... I also realized that the fields that they placed above the "apply" button, (range of dates, accounts, Diaries, etc...) when you put a condition, for example a range of dates, and click the apply button, an error appears TypeError: Cannot read properties of undefined (reading '0'), I am seeing that in their qweb reports, they did not add the foreach of o...

Re:
by
Cybrosys Technologies
on 9/18/23, 1:36 AM Author

We have updated the module.


General Legger Report Issue
by
Abdullah BinShehab
on 7/29/23, 2:53 AM

Doesn't shows the account name, just show like this:  211000 - [object Object]

Please advise.

Thanks in advance.


Balance Sheet & Trail Balance Reports Issues
by
Abdullah BinShehab
on 7/26/23, 3:07 AM
  File "C:\Program Files\Odoo16\server\odoo\addons\dynamic_accounts_report\wizard\general_ledger.py", line 111, in view_report
    'eng_title': eng_title,
UnboundLocalError: local variable 'eng_title' referenced before assignment

I got this error when click on the General Legger button under the account,

Please advise

Thanks in advance.

Re: Balance Sheet & Trail Balance Reports Issues
by
Cybrosys Technologies
on 9/18/23, 2:28 AM Author

We have updated the module with fixes.


How to display the real account name?
by
Ahmad Fatoni Febri Wihando
on 6/6/23, 9:45 AM

https://share.vidyard.com/watch/H9UaUF358dksNr7frB7Vdc?

Re: How to display the real account name?
by
Cybrosys Technologies
on 6/9/23, 6:48 AM Author

We have updated the module. Please check with the latest version.


How to display the real account name?
by
Ahmad Fatoni Febri Wihando
on 6/6/23, 9:12 AM

I only use accounting addons from cybrosys, namely: base_accounting_kit, base_account_budget, dynamic_accounts_report

However, is it still the name of the account that appears on the balance sheet and profit and loss [object object], or are there other special settings to display the actual account?

https://share.vidyard.com/watch/AykoBpWS11PzJ6z1QjoGo9?

Re: How to display the real account name?
by
Cybrosys Technologies
on 6/9/23, 6:48 AM Author

We have updated the module. Please check with the latest version.


remove -[object object]
by
Ahmad Fatoni Febri Wihando
on 6/1/23, 10:54 AM

I don't have an application of this kind, but still in the balance sheet and income statement the account name remains [object object]

Re: remove -[object object]
by
Cybrosys Technologies
on 6/9/23, 6:48 AM Author

We have updated the module. Please check with the latest version.


hi Good Module , please can you fixed problem
by
Mohamed Omary
on 5/20/23, 4:07 AM
Traceback (most recent call last):
  File "D:\odoo\odoo16\odoo\http.py", line 1583, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "D:\odoo\odoo16\odoo\service\model.py", line 134, in retrying
    result = func()
  File "D:\odoo\odoo16\odoo\http.py", line 1610, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "D:\odoo\odoo16\odoo\http.py", line 1807, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "D:\odoo\odoo16\odoo\addons\base\models\ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "D:\odoo\odoo16\odoo\http.py", line 696, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "d:\odoo\odoo16\addons\web\controllers\dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "d:\odoo\odoo16\addons\web\controllers\dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "D:\odoo\odoo16\odoo\api.py", line 457, in call_kw
    result = _call_kw_model(method, model, args, kwargs)
  File "D:\odoo\odoo16\odoo\api.py", line 430, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "d:\odoo\custom\addons16\cybroaddons\dynamic_accounts_report\wizard\general_ledger.py", line 111, in view_report
    'eng_title': eng_title,
UnboundLocalError: local variable 'eng_title' referenced before assignment

The above server error caused the following client error:
null


Re: hi Good Module , please can you fixed problem
by
Cybrosys Technologies
on 5/28/23, 11:47 PM Author

Please make sure you have downloaded the latest version. 
If the issue still exists, Please write to odoo@cybrosys.com


Hi when try to click details account
by
Mohamed Omary
on 5/19/23, 10:22 AM
Traceback (most recent call last):
  File "D:\odoo\odoo16\odoo\http.py", line 1583, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "D:\odoo\odoo16\odoo\service\model.py", line 134, in retrying
    result = func()
  File "D:\odoo\odoo16\odoo\http.py", line 1610, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "D:\odoo\odoo16\odoo\http.py", line 1807, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "D:\odoo\odoo16\odoo\addons\base\models\ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "D:\odoo\odoo16\odoo\http.py", line 696, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "d:\odoo\odoo16\addons\web\controllers\dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "d:\odoo\odoo16\addons\web\controllers\dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "D:\odoo\odoo16\odoo\api.py", line 457, in call_kw
    result = _call_kw_model(method, model, args, kwargs)
  File "D:\odoo\odoo16\odoo\api.py", line 430, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "d:\odoo\custom\addons16\cybroaddons\dynamic_accounts_report\wizard\general_ledger.py", line 111, in view_report
    'eng_title': eng_title,
UnboundLocalError: local variable 'eng_title' referenced before assignment

The above server error caused the following client error:
null



by
msdeek@codefish.com.eg
on 5/5/23, 3:15 PM

accounts appear 
201029 - [object Object] 


remove [object object]
by
Ahmad Fatoni Febri Wihando
on 3/10/23, 3:14 AM

what addons are needed so that the balance sheet and income statement can display the name of the account instead of - [object object]?

Re: remove [object object]
by
Cybrosys Technologies
on 3/31/23, 7:33 AM Author

No other addons are required. it should show the name. do you have any other apps for the same feature installed?


Does it support Arabic?
by
Abdulaziz Alanazi
on 1/21/23, 7:46 AM



please i need solve it
by
Samir Mahmoud Hassan
on 12/21/22, 1:53 PM

UncaughtPromiseError > KeyNotFoundError
Uncaught Promise > Cannot find dfr_n in this registry!
KeyNotFoundError: Cannot find dfr_n in this registry!
at Registry.get (http://localhost:8069/web/assets/101-8ead118/web.assets_backend.min.js:940:76)
at _executeClientAction (http://localhost:8069/web/assets/101-8ead118/web.assets_backend.min.js:2302:87)
at Object.doAction (http://localhost:8069/web/assets/101-8ead118/web.assets_backend.min.js:2319:192)
at async Object.selectMenu (http://localhost:8069/web/assets/101-8ead118/web.assets_backend.min.js:2422:1)

Re: please i need solve it
by
Cybrosys Technologies
on 12/22/22, 1:13 AM Author

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


by
Mohamed Omary
on 12/7/22, 10:34 AM

Hi 

for example when open General Legger Report

105001 - [object Object]  

why not display account name 

in all dynamic report this problem 


Re:
by
Cybrosys Technologies
on 12/14/22, 11:34 PM Author

Hi, Do you have any other accounts related addons installed?