Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
Community Apps Dependencies | Show |
Lines of code | 24675 |
Technical Name |
dynamic_accounts_report |
License | LGPL-3 |
Website | https://www.cybrosys.com |
Versions | 15.0 13.0 14.0 16.0 17.0 |
Odoo 14 Dynamic Financial Reports
Dynamic Accounting General Ledger, Trial Balance, Balance Sheet, Profit and Loss, Cash Flow Statements, Partner Ledger, Partner Ageing, Day book, Bank book and Cash book Reports in Odoo 14 community edition.
Dynamic Financial Reports for Odoo14 Community Edition.
Now generate dynamic financial reports for Odoo 14 Eommunity Edition.
Various Filters to Compare.
Option to compare report values with various filters available.
Print to PDF and XLSX Format.
One 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. One can open form view of each journal entries and view the complete details here.
Configurable Financial Reports.
Backend configuration for financial reports. One can configure the heirarchy of financial reports.
Screenshots
1
Dynamic Financial Reports Menu
2
Financial Reports Configuration
3
General Ledger
4
Trial Balance Report
5
Balance Sheet
6
Profit and Loss Account
7
Partner Ledger Report
8
Aged Partner Balance Report
9
Cash Flow Statements Report
10
Cash Book Report
11
Bank Book Report
12
Day Book Report
Suggested Products
Check out our other products
Our Services
We provide following services
Odoo Customization
Odoo Implementation
Odoo Support
Hire Odoo Developer
Odoo Integration
Odoo Migration
Odoo Consultancy
Odoo Implementation
Odoo Licensing Consultancy
Our Industries
Our industry specifics and process segments to solve your complex business barriers.
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
Need Help?
Do you have any queries regarding our products & services? Let us know.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedHello Cybrosys team, can you help to solve this error because I got the same problem as Michael Prataman Argojuwono when try to export General Ledger as excel. Thank you
Error:
Odoo Server Error
Traceback (most recent call last):
File "d:\odoo-14\plm-custom\dynamic_accounts_report\controllers\controllers.py", line 27, in get_report_xlsx
report_obj.get_dynamic_xlsx_report(options, response, report_data, dfr_data)
File "d:\odoo-14\plm-custom\dynamic_accounts_report\wizard\general_ledger.py", line 671, in get_dynamic_xlsx_report
for line_data in rec_data['move_lines']:
KeyError: 'move_lines'
Re: Hello Cybrosys team, can you help to solve this error because I got the same problem as Michael Prataman Argojuwono when try to export General Ledger as excel. Thank you
Hello, Thanks for informing us. We have updated the app. Please get the latest version.
Hi your module is awesome but i got problem when print or export Gl. can u haelme pls
The module is great but Dependencies module Odoo 14 Full Accounting Kit, please support alternate
Odoo 14 Accounting (Odoo Mates , Odoo S.A.)
Re:
There many exclusive features available in Full Accounting Kit
-Accounting Dashboard with all necessary details.
-Reconciliation Widget -Multiple Invoice Copies option.(eg: Original,Duplicate and Triplicate) -PDC management. -Customer credit limit.
-Handle Recurring payments. -Manage Customer follow-ups. -Cash Flow Statements.
-Day Book Report. -Bank Book Report. -Cash book report.
Great
Hi, I'm using the application dynamic_account_report I would like to thank you for such an excellent application but I would like to add a filter to be able to compare between periods (annual, monthly, etc.) similar to how it works in the financial reports of the enterprise versionplease these three keys: Ctrl + Alt + L, Beautify the code
odoo14 community:
in pycharm, please these three keys: Ctrl + Alt + L, Beautify the code, Current code is not standard, there are JS file calendar, it is best to use the official calendar, the date of the report can be translated into the Other languages.
please help
Error:
Odoo Server Error
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 684, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 360, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 348, in checked_call
result = self.endpoint(*a, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 913, in __call__
return self.method(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 532, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1389, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1381, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 392, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 365, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/dynamic_accounts_report/wizard/ageing.py", line 59, in view_report
records = self._get_report_values(data)
File "/usr/lib/python3/dist-packages/odoo/addons/dynamic_accounts_report/wizard/ageing.py", line 152, in _get_report_values
data['period_length'])
File "/usr/lib/python3/dist-packages/odoo/addons/dynamic_accounts_report/wizard/ageing.py", line 433, in _get_partner_move_lines
lines[partner_id].append({
Exception
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 640, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 316, in _handle_exception
raise exception.with_traceback(None) from new_cause
KeyError: False
Re: please help
Hello, We will look into it and get back to you ASAP
There is a problem
here is a problem with the filters to choose between all entries and posted
Always filters on staged posted only and when you try to select all entries, the filters disappear
Nice App
i get an error widow in profit and loss report how can i contact u
Re: i get an error widow in profit and loss report how can i contact u
Hi, send an email to odoo@cybrosys.com
Our team will connect you.
Really good
How can I change the report signs, cause Incomes are displayed as negative, and expenses as positive. I tried Accounting >> Configuration >> Account Reports and change the Sign on Reports, but it didn't work.
Also, how can I display numbers with thousand separator?
Awesome app
I like the way the reports are generated. I have one request, is it possible to have the P & L reports displayed in the following sequence.-
Income
Expenses
instead of
Expenses
Income
Re: Awesome app
Hello, Thanks for informing. We will update that as soon as possible.
You can change this order from UI,
You can go to Accounting >> Configuration >> Account Reports and change the sequence of Income and expenses
Really cool app
but there is a problem
Profit and loss report and Balance Sheet report gives blank screen no data
Please help
Re:
Hello,
Our team will contact you on email (noureldeen9012@gmail.com). Hope we can reach you on that. otherwise, let us know.
does it support multicurrency view/show
overall its great module.
does it support multicurrency view/show ?
as we tested in 14 ce, it doesnot show corrected incase multicurrency
pls advise if corrected, then we download it again.
thanks
Hello I can't install it I'm getting this error
The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead. Model: Follow-up Criteria (follow
Re: Hello I can't install it I'm getting this error
Please share the full traceback of the error to odoo@cybrosys.com
UncaughtPromiseError > KeyNotFoundError
Uncaught Promise > Cannot find t_b in this registry!
KeyNotFoundError: Cannot find t_b in this registry!
at Registry.get (http://localhost:8069/web/assets/130-73a2316/web.assets_backend.min.js:938:76)
at _executeClientAction (http://localhost:8069/web/assets/130-73a2316/web.assets_backend.min.js:2293:87)
at Object.doAction (http://localhost:8069/web/assets/130-73a2316/web.assets_backend.min.js:2310:192)
at async Object.selectMenu (http://localhost:8069/web/assets/130-73a2316/web.assets_backend.min.js:2413:1)
Partner Ledger only show Unreconciled enteries
Hi Cybrosys Techno Solutions Team,
This app is very helpful
Kindly check the Partner Ledger only shows Unreconciled entries , I try v 14 and 15 and get the same result,
when I create a new invoice or bill it shows normally when payment Done, it does not appear at the Partner Ledger, so please advise.
BR
Partner Ageing
We have created invoice with payment terms 30% Now, Balance 60 Days invoice amount is 1,18000
but in partner ageing it showing 35,400.00(30%) in 0-30 column and remaining 82,600.00 in not due. it should show remaining amount in 0-60 column
Re: Partner Ageing
These columns(0-30,30-60,...) are the number of days due. So in your case, as per your payment term, 30% of your invoice will become due 'Now' and the remaining 70% will become only due 'after 60 days'. 70% is not due till your invoice becomes 60 days age.
very robust report
m having problem while generating trial balance report, this is the error, could you check and advise
Error:
Odoo Server Error
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 685, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 361, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 349, in checked_call
result = self.endpoint(*a, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 914, in __call__
return self.method(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 533, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1394, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1386, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 395, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 368, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/mnt/extra-addons/dynamic_accounts_report/wizard/trial_balance.py", line 48, in view_report
records = self._get_report_values(data)
File "/mnt/extra-addons/dynamic_accounts_report/wizard/trial_balance.py", line 109, in _get_report_values
account_res = self._get_accounts(accounts, display_account, data)
File "/mnt/extra-addons/dynamic_accounts_report/wizard/trial_balance.py", line 167, in _get_accounts
self.env.cr.execute(request, params)
File "<decorator-gen-3>", line 2, in execute
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 101, in check
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 298, in execute
res = self._obj.execute(query, params)
Exception
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 641, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 317, in _handle_exception
raise exception.with_traceback(None) from new_cause
psycopg2.ProgrammingError: syntax error at or near "jrnl"
LINE 1: ...alance FROM account_move_lineJOIN account_journal jrnl ON (a...
^
Missing Features
Missing Hierarchy and subtotal option in trial balance report and in general ledger.
Partner having zero balance is not being displayed in partner ledger though it has some journal entries.
Re: Missing Features
Thanks for reporting, We will check and update.
trail balance error
error when try to open trail balance report
trail-balance error
We have error when opening trail balance report
RPC_ERROR
Odoo Server Error
Traceback (most recent call last):
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/http.py", line 688, in dispatch
result = self._call_function(**self.params)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/http.py", line 360, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/http.py", line 349, in checked_call
result = self.endpoint(*a, **kw)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/http.py", line 917, in __call__
return self.method(*args, **kw)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/http.py", line 536, in response_wrap
response = f(*args, **kw)
File "/home/ahmed/odoo-env/odoo15/odoo/addons/web/controllers/main.py", line 1335, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/home/ahmed/odoo-env/odoo15/odoo/addons/web/controllers/main.py", line 1327, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/api.py", line 460, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/api.py", line 433, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/home/ahmed/odoo-env/odoo15/addons/dynamic_accounts_report/wizard/trial_balance.py", line 52, in view_report
records = self._get_report_values(data)
File "/home/ahmed/odoo-env/odoo15/addons/dynamic_accounts_report/wizard/trial_balance.py", line 135, in _get_report_values
account_res = self._get_accounts(accounts, display_account, data)
File "/home/ahmed/odoo-env/odoo15/addons/dynamic_accounts_report/wizard/trial_balance.py", line 195, in _get_accounts
self.env.cr.execute(request, params)
File "<decorator-gen-3>", line 2, in execute
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/sql_db.py", line 89, in check
return f(self, *args, **kwargs)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/sql_db.py", line 310, in execute
res = self._obj.execute(query, params)
Exception
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/http.py", line 644, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/home/ahmed/odoo-env/odoo15/odoo/odoo/http.py", line 302, in _handle_exception
raise exception.with_traceback(None) from new_cause
psycopg2.errors.SyntaxError: syntax error at or near "jrnl"
LINE 1: ...alance FROM account_move_lineJOIN account_journal jrnl ON (
Re: trail-balance error
thanks for reporting.
We will check and get back to you.
P&L and Balance Sheets reports throw error
Find the cause of the excel export error in a non-English language
Error:
Odoo Server Error
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 684, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 360, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 348, in checked_call
result = self.endpoint(*a, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 913, in __call__
return self.method(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 532, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1389, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1381, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 392, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 365, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/dynamic_accounts_report/wizard/ageing.py", line 59, in view_report
records = self._get_report_values(data)
File "/usr/lib/python3/dist-packages/odoo/addons/dynamic_accounts_report/wizard/ageing.py", line 152, in _get_report_values
data['period_length'])
File "/usr/lib/python3/dist-packages/odoo/addons/dynamic_accounts_report/wizard/ageing.py", line 450, in _get_partner_move_lines
lines[partner_id].append({
Exception
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 640, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 316, in _handle_exception
raise exception.with_traceback(None) from new_cause
KeyError: False
there is a date format of other languages(yy-mm-dd), export Excel will report an error
Date range can call odoo date, otherwise cannot translate the date format of other languages, and there is a date format of other languages, export Excel will report an error
Open the report, which is great, but cannot export XLSX, the following error is displayed
Method Not Allowed
The method is not allowed for the requested URL.
Re:
Thanks fro reporting. We will look into it asap.
There is a problem
here is a problem with the filters to choose between all entries and posted
Always filters on staged posted only and when you try to select all entries, the filters disappear
Re: There is a problem
Hi, Can you please share more info to odoo@cybrosys.com?
exact version you are using. and the web browser you re trying with etc?
nice app with a small problem for me
When viewing the Profit and Loss report it shows the income accounts twice once under income and once under operating income, this started only after upgrading the base accounting kit app.
the income showing an exaggerated profit on PNL, however the Balance sheet shows correct
I have version 14.0.1.2.2
Any ideas or suggestions?
Profit and loss report and Balance Sheet report gives blank screen no data Please help
Profit and loss report and Balance Sheet report gives blank screen no data
Please help
While trying to install, there is an error
get an error during installation
Can you help please ?
Can you help please ?
Re: get an error during installation
Hi, form this error message,It doesn't look like something related to this module.
anyway, Please send an email to odoo@cybrosys.com. Our team will check what is going on.
this error occure when press partner ageing report menu
Error:
Odoo Server Error
Traceback (most recent call last):
File "/opt/odoo14/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/opt/odoo14/odoo/odoo/http.py", line 683, in dispatch
result = self._call_function(**self.params)
File "/opt/odoo14/odoo/odoo/http.py", line 359, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo14/odoo/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo14/odoo/odoo/http.py", line 347, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 912, in __call__
return self.method(*args, **kw)
File "/opt/odoo14/odoo/odoo/http.py", line 531, in response_wrap
response = f(*args, **kw)
File "/opt/odoo14/odoo/addons/web/controllers/main.py", line 1389, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/opt/odoo14/odoo/addons/web/controllers/main.py", line 1381, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/opt/odoo14/odoo/odoo/api.py", line 392, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/opt/odoo14/odoo/odoo/api.py", line 365, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/home/pc/Music/odoo-custom-addons14/dynamic_accounts_report/wizard/ageing.py", line 59, in view_report
records = self._get_report_values(data)
File "/home/pc/Music/odoo-custom-addons14/dynamic_accounts_report/wizard/ageing.py", line 149, in _get_report_values
account_res = self._get_partner_move_lines(data, partners, date_from,
File "/home/pc/Music/odoo-custom-addons14/dynamic_accounts_report/wizard/ageing.py", line 416, in _get_partner_move_lines
lines[partner_id].append({
Exception
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/odoo14/odoo/odoo/http.py", line 639, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo14/odoo/odoo/http.py", line 315, in _handle_exception
raise exception.with_traceback(None) from new_cause
KeyError: False
Re:
Hello, We tried to reproduce the error. Can you send an email to odoo@cybrosys.com. So that our team can reach back to you and understand the issue better.?
In Addition to my previous comment
I can't select the drop down list from the Dynamic report.
Thanks
Tadelo
Re: In Addition to my previous comment
We could only find the issue in Aging report. thanks for your comment. If you are facing somewhere else. Please email us on odoo@cybrosys.com
I can't change the default age range
Dear Team,
Could you please help me to change the default age range on your module.
Thanks
Re: I can't change the default age range
We changed the time period to 30 days since that is more common. if you want a another range, please contact us on odoo@cybrosys.com. our team will help you change it.