| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 13444 |
| Technical Name |
ks_dynamic_financial_report |
| License | OPL-1 |
| Website | https://store.ksolves.com/ |
| Versions | 12.0 13.0 14.0 15.0 16.0 17.0 18.0 |
Dynamic Financial Report
Hot Features
-
Robust Overview Of Various Reports
One can easily view every aspect of a report to detect small shortcomings, understand the financial standing of the business and present them to relevant people.
-
Differentiate Feature
The differentiate filter helps in comparing or tallying a report with the previous reports of varying periods(month, quarter, etc). It will let you compare the results to visualize where the business is headed for..
-
Dynamic Financial Report-
It is a feature that helps you to create and customize your own reports with ease. You can create a report in a new format and incorporate it with an existing parent report.
-
Send Email(to user)
Using this feature, the user can send any report that is required to him/her email address. The pdf of that report is automatically generated and sent.
User Guide
Installation
1. Copy and paste it to your Add-ons folder.
2. Click on Update Apps list from the menu and now Dynamic Financial Report App will appear in App list.
3. Go to Apps menu, search for 'Dynamic Financial Report' and click Install button.
4. You are ready for use Dynamic Financial Report
Various Types Of Reports / Available Filters
- Profit and loss Report
- Balance Sheet Report
- Executive Summary Report
- Cash and Flow Report
- General Ledger Report
- Consolidate Journal Report
- Age Receivable Report
- Age Payable Report
- Trial Balance Report
- Tax Report Report
Available Filters
- Date Filter: It is possible to filter the report based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- Differentiate Filter: The report can also be compared with the previous period or a custom period(defined by the user)
- Journal Filter: The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
- Analytic Filter: Analytic accounting helps you to analyse costs and revenues whatever the use case. You can sell or purchase services, track time or analyse the production performance through analytical filters
- Partner Filter : One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed..
- Account Type Filter: The Account button allows the user to select from Payable and Receivable
- Option Filter: The Options button provides options to view Posted Entries, Unposted Entries(Draft), Show Reconciled Entries, Show Unreconciled Entries, To Change Date Range and To Print Report With Details.
Profit and Loss Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The report can also be compared with the previous period or a custom period(defined by the user)
- The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), and To Change Date Range.
Balance Sheet Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The report can also be compared with the previous period or a custom period(defined by the user)
- The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), and To Change Date Range.
Executive Summary Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The report can also be compared with the previous period or a custom period(defined by the user)
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), and To Change Date Range.
Cash Flow Statement Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), and To Change Date Range.
General Ledger Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), To Change Date Range, and To Print Report With Details.
Partner Ledger Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range
- One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed.
- The Account button allows the user to select from Payable and Receivable
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), Show Reconciled Entries, Show Unreconciled Entries, To Change Date Range, and To Print Report With Details.
Age Receivable Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), To Change Date Range, and To Print Report With Details.
Age Payable Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- One can enter the name of the partner in the Partner Search button and the corresponding report will be displayed.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), To Change Date Range, and To Print Report With Details.
Trial Balance Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), To Change Date Range, and To Print Report With Details.
Consolidate Report
- It is possible to filter the report from the As Of Date button based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The Journals All button provides the option to filter the report based on Bank, Cash, Cash Basis Taxes, Customer Invoices, Exchange Difference, Miscellaneous Operations, Vendor Bills.
- The Options button provides options to view Posted Entries, Unposted Entries(Draft), To Change Date Range, and To Print Report With Details.
Tax Report
- It is possible to filter the report based on various date filter options- Today, End Of Last Month, End Of Last Quarter, End Of Last Financial Year, and Custom date range.
- The report can also be compared with the previous period or a custom period(defined by the user)
Functionalities
- Print(Pdf):- To print pdf of existing report.
- Export(XLSX):- To Print Excel report of existing report
- Send Email:- To send the pdf attached mail to the user for current report
Dynamically Creating Financial Reports
- Go to the configuration menu present in the navigation bar. Click on the Dynamic Financial Reports. On clicking, a form is opened.
- Fill in the fields that are required:
- Report Name- Provide a name to the report
- Report Menu- Choose the menu of the report where you wish to see the Report Menu For example If you choose Accounting->Reporting->Generic Statements then the name of the report will be shown in the Reporting Section of the Navigation Bar. Parent- If you want to keep the report in the existing reports menu, then you can accordingly choose the Type. There are 5 types to create the reports
- Total- if we choose Total as a type then our report will be shown or created as a sum of the records
- Subtraction- If you choose subtraction as a type, then the report will be created which displays the difference of the records.
- Accounts- If you choose Accounts as a type, then the report will be created according to the selected accounts
- Account Type- If you choose Account type as a type then, the report will created according to the selected accounts type.
- Report Value- If you choose Report Value as a type then the report will be made on the basis of values like operating income , assets etc.
Our Releases
Latest Release 16.0.2.2.0
■ Fix: The issue of incomplete data display for partial payment invoices when the "Unreconciled" filter is applied in the partner ledger report has been resolved.
Release 16.0.2.1.9
■ Improvement - Added search option in accounts filter.
Release 16.0.2.1.8
■ Fix - Showing only first few records in Age receivable and payable report lines.
■ Improvement - Changed the partner ledger and general ledger report lines pagination style.
Release 16.0.2.1.7
■ Fix - Showing Only first 20 records in Partner Ledger report lines.
Release 16.0.2.1.6
■ Fix - Showing wrong data in the partner ledger printed report.
Release 16.0.2.1.5
■ Enhancement - Data will show in sorting order in age payable and age receivable reports.
■ Fix - Pagination is not displaying in partner ledger and general ledger reports.
Release 16.0.2.1.4
■ Fix - Partner Ledger is not opening in the blank database.
Release 16.0.2.1.3
■ Fix - Journal Entries data not displaying in Partner Ledger.
■ Fix - Partner Ledger and General Ledger bugs.
Release 16.0.2.1.2
■ Enhancement- Added sum of EQUITY and LIABILITIES in the balance sheet report.
Release 16.0.2.1.1
■ Enhancement- Added the configuration to update the equity formula.
■ Enhancement- Working of Excel report in Other languages.
Release 16.0.2.1.0
■ Enhancement- Added Pagination Feature in Partner Ledger Report and Account Entries of General Ledger Report.
■ Enhancement- Managed all filters in Partner Ledger Report with pagination.
Release 16.0.2.0.0
■ Enhancement- Added Pagination Feature in Age Receivable and General Ledger Report.
■ Enhancement- Managed all filters in Age Receivable and General Ledger Report with pagination.
■ Improvement - Credit issue fixed in Partner Ledger pdf report.
Release 16.0.1.2.2
■ Improvement- Improved rendering of data for Consolidate Report
Release 16.0.1.2.1
■ Fix- Partner Search Filter issue in Partner Ledger Report.
Release 16.0.1.2.0
■ Improvement- Fixed the loading issue in Partner Ledger.
Release 16.0.1.1.9
■ Improvement- Improved the working of missing record when click the Send Mail button inside the all reports.
Release 16.0.1.1.8
■ Improvement- Improved the working of missing record when click the Send Mail button inside the all reports.
Release 16.0.1.1.7
■ Improvement- Improved the working of domain when opening General Ledger and Journal Item from Consolidate Journal report.
Release 16.0.1.1.6
■ Enhancement- Enhanced the partner ledger report rendering to manage all the partners.
Release 16.0.1.1.5
■ Enhancement- Enhanced the working of domain when opening General Ledger and Journal Item from Balance Sheet report.
Release 16.0.1.1.4
■ Improvement- Data in Previous Year Unallocated Earning in Balance Sheet .
■ Improvement- Net Profit Calculation in Profit and Loss report .
■ Improvement- Cash Flow values in Executive Summary report .
Release 16.0.1.1.3
■ Improvement- Calculation of gross profit in profit and loss report.
Release 16.0.1.1.2
■ Enhancement - Enhanced the move line rendering in the partner/general pdf and xlsx report.
Release 16.0.1.1.1
■ Enhancement - Debit minus Credit for Expense and Cost of Revenue in Cash Flow report, Profit and Loss report.
Release 16.0.1.1.0
■ Enhancement- Added Analytic Account Filter
■ Enhancement- Improved working of Disable Trial Initial balance feature
Release 16.0.1.0.5
■ Fixes- Installation issue fixed in enterprise
Release 16.0.1.0.4
■ Enhancement- Code Optimized for Empty Due Date.
Release 16.0.1.0.3
■ Fixes- Reports UI and Bug fixes.
Release 16.0.1.0.2
■ Enhancement- Configuration added for Net Tax in Tax Report.
Release 16.0.1.0.1
■ Enhancement- Code Optimized for Empty Due Date in Age Receivable.
Frequently Asked Question
For extra customizations, you can contact us and communicate the exact modifications that you need. We will certainly help you with that.
Yes, we will provide 90 days of free support for any app-related queries. issues and glitches. It starts from the date of purchase.
Dynamic Financial Report is a feature that helps you to create and customize your own reports with ease. You can create a report in a new format and incorporate it with an existing parent report
The app can significantly reduce the burden of businesses of any scale by automatically generating various reports on a click. Whether you are a small business, MSME or a large enterprise, investing in the app will be fruitful.
The differentiate filter will help you to compare or tally a report with the previous ones(different time segments). It will let you compare the results and understand the financial standing of the new report.
Generally, a report only sums up the overall transaction details of various products in a combined fashion. What if you need to get the transaction history(credit/debit details) of a specific product? This is where an analytical account comes in. Using an analytical account, you can check the credit/debit history of a specific product without affecting the details of the original report.
Ksolves will provide FREE 90 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.
Note:
Extensively Tested on Odoo Vanilla with Ubuntu OS
Ksolves Suggested Apps
Ksolves Odoo Services
Odoo Implementation
Odoo Community Apps
Odoo Support & Maintenance
Odoo Customization
Odoo Integration Services
Odoo Developer Outsourcing
sales@ksolves.com
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedEmpty Lables and Export
Sometimes module functions don't work, like exporting xls or pdf.
Also, the account lables in the reports are not displayed, instead this field [object Object] or this {'en_US': 'Sales Account', 'ar_001': 'Sales'} 500001 is printed or displayed
I have contacted support and they were responsive but they weren't able to fix the issue.
Re: Empty Lables and Export
Hello Abdulaziz,
Thanks for reaching out to us,
We have checked your concern about exporting reports in PDF and Excel and all the reports are getting exported successfully with all the required data.
Regarding the account name labels we have already provided the solution for the same it seems like you have some custom modules that override the "get_name" function. Or in any of your custom modules, this method is not overridden correctly and that is why this issue is arising.
We have also asked you multiple times to connect with us over the call and we again request you to please come up over the call so that we can help you in resolving the issues. So please let us know your availability for the call at odoo.helpdesk@ksolves.in or over the same Helpdesk ticket.
If you have any other concerns or queries, please feel free to reach out to us odoo.helpdesk@ksolves.in.
Thanks,
Team Ksolves!
Works as intended
I wrote the wrong review for this module, but hey, this works great, i wish they add the total for the reports tho, anyhow 5/5
Re: Works as intended
Hello Mahmoud Ibrahim,
Thank you for the 5-star rating & encouraging feedback.
We look forward to growing this to a long-term relationship.
Regards,
Team Ksolves!
Demo access
Hello, can i get access for demo module?
Thank you
Re: Demo access
Hello Ridwan,
Thanks for reaching out to us,
You can go through the link below to access the demo server of the Dynamic Financial Report module.
URL: https://dynamicreport17.kappso.com/web/login
Email: demo
Password: demo
For any other concerns or queries, please feel free to reach out to us at odoo.helpdesk@ksolves.in.
Regards,
Team Ksolves!
Ask for community v16
Hello, i want to ask. I use third party accounting module for odoo 16 and not available for Cash Flow Statement and Executive Summary. If i install this module, can i get that report too with all fiture in this module?
Re: Ask for community v16
Hello Ridwan,
Thanks for reaching out to us,
The Dynamic Financial module provides a crystal clear visualization of the financial performance of a business by generating precise reports such as Executive Summary, Cash Flow Statements, Balance Sheets, Profit and Loss, and much more.
You can easily view every aspect of a report and detect small shortcomings, and understand the financial standing of the business. Our modules work on both the Community and Enterprise editions of Odoo.
If you have any other concerns or queries, please feel free to reach out to us at odoo.helpdesk@ksolves.in.
Regards,
Team Ksolves!
The module is perfect
We appreciate the support team and their effort with us.
Re: The module is perfect
Hello Ahmed,
Thanks for sharing the encouraging feedback.
We look forward to a long-term association & serve you with future assignments up to the mark.
Regards,
Team Ksolves!
Hi,
Can you provide us this module with french translation ?
Re:
Hello Yassine,
Thanks for reaching out to us,
You can use it in French language but for the same you need to update its translation value in the PO file.
So in order to update the Dynamic Financial Report app translation in any other language to French you need to first export the PO file of the Dynamic Financial Report. Edit the Po file and update the translated terms, then import the file again in the Odoo environment, which will generate the translation for all the fields that you have updated in the PO file.
Now you will be able to use Dynamic Financial Report in the French language.
If you have any other concerns or queries please feel free to reach out to us at odoo.helpdesk@ksolves.in.
Thanks,
Team Ksolves!
I feel frustrated because the module has a lot of issues and the lack of speed in solving them
The module does not support RTL (Arabic language) although you say the opposite thing and after purchasing's the module we suffered many issues in arabic language; all the numbers in the reports wrong and they aren't the same like when we use English, a lot of options in the filters don't appear in arabic, some lines in the reports don't appear in arabic so the total of the reports wrong, and reports don't have a title in PDF files or XLXS.
I excepted to find the improvements that I was looking for.
Re: I feel frustrated because the module has a lot of issues and the lack of speed in solving them
Hello Rania,
Thanks for reaching out to us,
Dynamic Financial Report supports RTL and yes there are some bugs and issue in this but we have fixed all those issues which are reported by you.
And regarding the translation of Terms so now we have updated the translation for all the terms. So now you will be able tp translate all the terms of Dynamic Financial report in Araic Language. As you are already connected with us on the Helpticekt so we are also working on the other issues reported by you and soon we will provide you the solution for them and update you on the same Helpticket.
If you have any other concerns or queries, please feel free to reach out to us odoo.helpdesk@ksolves.in.
Thanks,
Team Ksolves!
Does what it says
Idk why odoo removed the ability to modify the invoices sequence & prefix, but this module solved it and brought it back.
Re: Does what it says
Hello Mahmoud Ibrahim,
Thanks for sharing the encouraging feedback.
We look forward to a long-term association & serve you with future assignments up to the mark.
Regards,
Team Ksolves!
We appreciate the support team and their effort with us. The module is perfect and the development continues.
Re:
Hello Rania,
Thanks for sharing the encouraging feedback.
We look forward to a long-term association & serve you with future assignments up to the mark.
Regards,
Team Ksolves!
V11
Hello,
I am interested in this module for Odoo V11.
Can you do it?
Re: V11
Hello Asad,
Thanks for reaching out to us,
Currently Dynamic Financial Report is available from version 12 to version 16. As you are interested for Odoo version 11.
So we request you to please feel free to reach out to us at odoo.helpdesk@ksolves.in, will discuss it in details and help you to achieve the same in version 11.
Thanks,
Team Ksolves!
Does it support RTL/Arabic?
Re: Does it support RTL/Arabic?
Hello Abdulaziz,
Thanks for reaching out to us,
Yes, Dynamic Financial Report supports RTL.
If you have any other concerns or queries please feel free to reach out to us at odoo.helpdesk@ksolves.in.
Thanks,
Team Ksolves!