| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 22244 |
| 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 |
Odoo 16 Dynamic Financial Reports
A Module for accounting reports
Explore This Module
Overview
Features
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
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
Say hi to us on WhatsApp!
+91 86068 27707
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedTrial Balance is not showing accounts when filtering with the date
if I filter with a date range, the trial balance doesn't show accounts that has no transaction in the date period filtered.
It should show those accounts and the previous transactions' total as initial balance.
Re: Trial Balance is not showing accounts when filtering with the date
We have added a new filter option in the Trial Balance report, allowing you to filter lines based on: All, With movements, With balance is not equal to 0
You can download the latest version to access these changes. Please let us know if you need any assistance or have any feedback.
Profit and Loss report, do not filter results with Analytic Account
Hi
this is good app, here need improvement that Profit and Loss report do not filter results when using Analytic Account. pls check
arrow down to view general ledger missing menu after click
this behaviour is strange, all report arrow down show blank after clicked
here the image of it
https://drive.google.com/file/d/1wTQoTvLZDiyo1YNUpLRctpVbhGpT6I_B/view?usp=sharing
Re: arrow down to view general ledger missing menu after click
Hello, Yulian, We checked the app. It is working fine.
General Ledger Bug
When I go to the general ledger, the loading takes so much time. Here is the log:
2024-11-14 16:28:23 2024-11-14 08:28:23,656 1 WARNING my_db odoo.osv.expression: The domain term '('id', '=', [8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, .......... until 431, 431, 431, 431, 431, 431, 431, 431, 431, 431])' should use the 'in' or 'not in' operator.
Then all of the values like the account, debit, credit, and balance are logged, which makes the loading so long and consumes resources
Re: General Ledger Bug
Thanks for reporting, We have updated the app.
Precision and Rounding Problems
1. Rounding issue with the account's credit, debit, and total it shows 12+ decimal places (e.g. 199.66363636363)
2. The journal item line balance is incorrect due to invalid sum on rounded credit or debit not considering what is after the decimal point, causing balance in all lines to be incorrect
Screenshots: https://drive.google.com/drive/folders/1kSr-4MQ_GNmMCBfrpYLOy_JEiVBcVFxf?usp=sharing
Re: Precision and Rounding Problems
Hello, Thanks for reporting. We have updated the app.
Thank you, it was switched to Simplified Chinese without any data
Great work but..
Hi guys,
Great work making impressive reports, but I noticed something, the movements are not sorted in all. the list of movements neither partner ageing or bank book follows any kind of sorting.
It is posible to have the list of movements sorted by date or by name?
Thanks in advance for your comments and great work.
Re: Great work but..
Hello, We checked the app and we can sort by date. Please check whether you are using the latest version or not.
error
Hello
When installing the module in version 16, the following error is encountered. How should I fix this?
Table name 'account_common_journal_report_account_report_horizontal_group_rel' is too long
Re: error
Are you installing this on enterprise edition?
Great app but there's an issue in the report format
I got this error when opening the report
Traceback (most recent call last): File "c:\odoo16\odoo\http.py", line 1633, in _serve_db return service_model.retrying(self._serve_ir_http, self.env) File "c:\odoo16\odoo\service\model.py", line 133, in retrying result = func() File "c:\odoo16\odoo\http.py", line 1660, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) File "c:\odoo16\odoo\http.py", line 1864, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) File "c:\odoo16\odoo\addons\base\models\ir_http.py", line 154, in _dispatch result = endpoint(**request.params) File "c:\odoo16\odoo\http.py", line 697, in route_wrapper result = endpoint(self, *args, **params_ok) File "c:\odoo16\addons\web\controllers\dataset.py", line 42, in call_kw return self._call_kw(model, method, args, kwargs) File "c:\odoo16\addons\web\controllers\dataset.py", line 33, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "c:\odoo16\odoo\api.py", line 464, in call_kw result = _call_kw_model(method, model, args, kwargs) File "c:\odoo16\odoo\api.py", line 435, in _call_kw_model result = method(recs, *args, **kwargs) File "c:\odoo16\cybrosys-accounting-16.0\dynamic_accounts_report\wizard\balance_sheet.py", line 137, in view_report filter_movelines_parents(report_lines) File "c:\odoo16\cybrosys-accounting-16.0\dynamic_accounts_report\wizard\balance_sheet.py", line 128, in filter_movelines_parents if each['account'] in move_line_accounts: KeyError: 'account' The above server error caused the following client error: nullThe error would appear if I set the field Type as Account (https://prnt.sc/cydP4B3lRcWM)
Please help, thank you
Filters doesn't work in General Ledger
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)Duplicated records
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
Please check your financial report configuration
errors in version 16
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
Hello Adrian, Thanks for reporting. We have updated the module.
Good one, thanks for make it open source.
Re: Good one, thanks for make it open source.
Thanks for the feedback.
Thank you
Thank you, this is really great
Re: Thank you
Thanks for the feedback.
Profit and loss report issue
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
Hello, We cannot reproduce the case you mentioned with this app. Could you please check your account configuration?
Everything Left Aligned in Database
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
Hello, We have updated the module. Please get the latest version
Good
Partner Ledger Rounder/Decimal Points issue
Hello there,
I have found an issue where the partner ledger report shows incorrect values for decimal points as well as wrong formatting.
Instead of depending on the currency used decimal places configuration its fixed to two decimal places. Also, it's always .00 which is also wrong removing everything after the decimal point.
Example:
If the journal value equals 15.555, the partner ledger shows 15.00.
Re: Partner Ledger Rounder/Decimal Points issue
Thanks for reporting. We have updated the app. Please use the latest version to receive this update.
General Ledger Filter Bug Fix
How to repeat:
- Open general ledger in language other than English
- Try applying any filter
Error:
UncaughtPromiseError > TypeError وعد لم يتم رصده > Cannot set properties of null (setting 'value') TypeError: Cannot set properties of null (setting 'value') at Class.apply_filter (http://127.0.0.1:8069/web/assets/debug/web.assets_backend.js:217130:24) (/dynamic_accounts_report/static/src/js/general_ledger.js:409) at HTMLButtonElement. (http://127.0.0.1:8069/web/assets/debug/web.assets_common.js:73797:23) (/web/static/src/legacy/js/core/mixins.js:277) at HTMLDivElement.dispatch (http://127.0.0.1:8069/web/assets/debug/web.assets_common.js:27803:27) (/web/static/lib/jquery/jquery.js:5183) at elemData.handle (http://127.0.0.1:8069/web/assets/debug/web.assets_common.js:27611:28) (/web/static/lib/jquery/jquery.js:4991)
Reason:
A condition that doesn't show the 'journals' filter unless the title name matches the condition
/dynamic_accounts_report/static/src/xml/general_ledger_view.xml:166
Code:
triggering the error in /dynamic_accounts_report/static/src/js/general_ledger.js:409
Re: General Ledger Filter Bug Fix
Thank you for your feedback. We have updated the app; you can now get the latest version.
BUG!! Version number: 16.0.1.0.11, I am a user of Simplified Chinese. Why do I choose the English language, Profit and Loss ，Balance Sheet， No data, Partner Aging has no data in any language environment
Version number: 16.0.1.0.11, Balance Sheet and Profit and Loss are blank, and numerical values cannot be obtained
Re: Version number: 16.0.1.0.11, Balance Sheet and Profit and Loss are blank, and numerical values cannot be obtained
We will check and update.
error
no! i'm using community version
General ledger query bug / analytical account filter
Problem:
- General ledger showing incorrect balance
- General ledger showing duplicated records (same journal id more than once)
Reason:
- Bugged SQL query in general_ledger.py file lines 370-392 and 436-458.
- Bug is triggered when a journal item has two or more analytical accounts assigned to it.
Helpful screenshots to fix the bug: https://drive.google.com/drive/folders/1R6hk_cFH9y4-xPNi9CD62um_t0WilntY?usp=sharing
Re: General ledger query bug / analytical account filter
Thank you for bringing the SQL query bug to our attention. We have fixed the bugs, and you can now access the updated version.
Filters doesn't work in General ledger
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)Still broken.
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.
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
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
We have updated the module. Please get the latest version.
Analytic Account / Financial Reports Bug
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
Thanks for reporting. We have updated the app. Please get the latest version.
financial report configuration
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
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
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:
Filters error:
Partner Ledger Error:
Re: Errors + Performance Issues
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
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
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.
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:
We have updated the module.
General Legger Report Issue
Doesn't shows the account name, just show like this: 211000 - [object Object]
Please advise.
Thanks in advance.
Balance Sheet & Trail Balance Reports Issues
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 assignmentI 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
We have updated the module with fixes.
How to display the real account name?
https://share.vidyard.com/watch/H9UaUF358dksNr7frB7Vdc?
Re: How to display the real account name?
We have updated the module. Please check with the latest version.
How to display the real account name?
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?
We have updated the module. Please check with the latest version.
remove -[object object]
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]
We have updated the module. Please check with the latest version.
hi Good Module , please can you fixed problem
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: nullRe: hi Good Module , please can you fixed problem
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
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: nullaccounts appear
201029 - [object Object]
remove [object object]
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]
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?
please i need solve it
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
Could you please send an email to odoo@cybrosys.com
Hi
for example when open General Legger Report
105001 - [object Object]
why not display account name
in all dynamic report this problem
Re:
Hi, Do you have any other accounts related addons installed?