Treasury and Cash Flow Management
by Giacomo Grasso - giacomo.grasso.82@gmail.com https://github.com/jackjack82$ 143.53
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
Lines of code | 1570 |
Technical Name |
treasury_forecast |
License | OPL-1 |
Website | https://github.com/jackjack82 |
Versions | 10.0 11.0 12.0 13.0 15.0 14.0 |
Treasury Forecast and Cash Flow Management
Get a clear view of your cash situation and plan your next moves!
INSTALLATION NOTE: in order to have the chart view please install the module web_widget_bokeh_chart that is available here https://github.com/OCA/web/ . Install the Python bokeh library running "pip3 install bokeh==1.1.0".
This module introduces treasury planning functionalities into Odoo.
User will create a forecasting window for a defined period of time. Once created the user will have in one single window all the cash flow data and will be able to arrange this data to better organize his cash flow.
A detailed cash flow is also introduces a daily cash flow based bank moves, move lines, planned payment and draft invoices.
A video tutorial is available at this link: Video Demo
For additional information write to giacomo.grasso.82@gmail.com. Please note that:
- You can be added directly to the Github repo,
- You can download any debug or improvement,
- You will access to all new features,
- You can download any new version fo the module,
- You can contribute and suggest improvements.
Images: above a chart representation of the cash flow, with or without forecasted moves.
Below an example of the table report with daily details, and a page for the cash flow management.Features
This module allows you to:
- Plan your treasury with your planned cash moves
- Add draft invoices and any other account moves to your cash planning
- Print table with daily total balance,
- Print daily balance with all operations,
- Export in Excel,
- Chart view of the daily balances
- chart settings, with zoom and possibility of saving as image.
This module perfectly works also on Enterprise version.
Get in touch with us!
This module has been developed by Giacomo Grasso (giacomo.grasso.82@gmail.com) and Gabriele Baldessari (gabriele.baldessari@gmail.com).
Get in touch with us for any request of improvements or to contribute!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 penalizedPerfect
I love this module :-)
Amazing and powerful app
Very useful app to forecast your cash flow over time!
Good support and good module
I want to thank the author for his quick support for my clarification.
demostration
do you have video as demo?
Graph Error
Thanks Giacomo Grasso, payable and receivable working great now graph show error: File "/opt/odoo50/odoo-server/odoo/http.py", line 519, in response_wrap response = f(*args, **kw) File "/opt/odoo50/odoo-server/addons/web/controllers/main.py", line 966, in call_button action = self._call_kw(model, method, args, {}) File "/opt/odoo50/odoo-server/addons/web/controllers/main.py", line 954, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo50/odoo-server/odoo/api.py", line 759, in call_kw return _call_kw_multi(method, model, args, kwargs) File "/opt/odoo50/odoo-server/odoo/api.py", line 746, in _call_kw_multi result = method(recs, *args, **kwargs) File "/opt/odoo50/custom/addons/treasury_forecast/models/treasury_bank_forecast.py", line 267, in compute_bank_balances journal_header, all_balances, report_lines, init_col, col_numb) File "/opt/odoo50/custom/addons/treasury_forecast/models/treasury_bank_forecast.py", line 463, in _compute_bank_chart dates.append(datetime.strptime(l[0], '%Y-%m-%d')) TypeError: strptime() argument 1 must be str, not datetime.date Pls Help
Payable , receiveable and graph not shown
when create vendor bill and customer invoice, did now shon in payable and receiveable graph also did shown please help
Re: Payable , receiveable and graph not shown
stefanus, make sure that on the invoices you have the "treasury date" set if they are draft. this is a detailed video of the module, please check it: https://www.youtube.com/watch?v=zZs3PZ9lQOY
Graphics
When try generate graphics i get back the message below. The chart can not be visible for one of the following reasons: You did not flag 'Show chart' parameter, You flagged the 'Detailed balance' parameter, the chart is a daily chart and details can not be shown, There are operations only in one day, please check the table and extend the date range. Could help me?
Re: Graphics
Dear Denis, write me directly at giacomo.grasso.82@gmail.com . we can set a HG call. giacomo
Demo Access
The access to http://212.35.194.29:8069/web/login using database treasury_demo using credentials admin and admin not working. I need access demo before buy . Could help me?
Re: Demo Access
Dear Denis, username: "demo" and password: "demo" giacomo
I couldn't access to the test environement
I tried to access the demo environement using the link: http://212.35.194.29:8069/web/database/selector and select the database is treasury_demo, but the credentiels provided user "admin" and password "admin" doesn't allow me to login, would you pls check. Thanks, Mourad
Re: I couldn't access to the test environement
Dear Mourad, username: "demo" and password: "demo" giacomo
We need a demo, and upgrade to Odoo13
Hello, We need a demo before we buy, please. And we need it on Odoo13 enterprise. Regards,
Re: We need a demo, and upgrade to Odoo13
Dear Sir, the demo is on Odoo 11. Username: "demo" and password: "demo" The module will be soon available on version 13. giacomo
Demo Access
Hello Is there a demo access to check to check compatibility and features? we would like to review prior to purchase Thank you
Re: Demo Access
Dear Sir, there is a demo at this link, http://212.35.194.29:8069/web/database/selector , database is treasury_demo, you can login with user "admin" and password "admin". It is an old demo on Odoo 11, but all features shall be there. Regards, Giacomo
I get error when click compute
Here is error capture : Traceback (most recent call last): File "/odoo/odoo-server/odoo/http.py", line 653, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/odoo/odoo-server/odoo/http.py", line 312, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/odoo/odoo-server/odoo/tools/pycompat.py", line 87, in reraise raise value File "/odoo/odoo-server/odoo/http.py", line 695, in dispatch result = self._call_function(**self.params) File "/odoo/odoo-server/odoo/http.py", line 344, in _call_function return checked_call(self.db, *args, **kwargs) File "/odoo/odoo-server/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/odoo/odoo-server/odoo/http.py", line 337, in checked_call result = self.endpoint(*a, **kw) File "/odoo/odoo-server/odoo/http.py", line 939, in __call__ return self.method(*args, **kw) File "/odoo/odoo-server/odoo/http.py", line 517, in response_wrap response = f(*args, **kw) File "/odoo/odoo-server/addons/web/controllers/main.py", line 938, in call_button action = self._call_kw(model, method, args, {}) File "/odoo/odoo-server/addons/web/controllers/main.py", line 926, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/odoo/odoo-server/odoo/api.py", line 699, in call_kw return call_kw_multi(method, model, args, kwargs) File "/odoo/odoo-server/odoo/api.py", line 690, in call_kw_multi result = method(recs, *args, **kwargs) File "/odoo/custom/addons/treasury_forecast/models/treasury_bank_forecast.py", line 267, in compute_bank_balances journal_header, all_balances, report_lines, init_col, col_numb) File "/odoo/custom/addons/treasury_forecast/models/treasury_bank_forecast.py", line 519, in _compute_bank_chart return chart.html.data AttributeError: 'Figure' object has no attribute 'html' Please Help
Re: I get error when click compute
Dear Sir, that error is due to a wrong version of the bokeh library. Which version of Odoo are you using? For Odoo 10 and 11 you should use "pip install bokeh==0.12.7 " while for Odoo 12 you should use "pip3 install bokeh==1.1.0". Regards, Giacomo
installation question
Please I would like to indicate the procedure to install, install the module and tell me that it has an external dependency of the Bokeh module, please could you send me the link to download it and comment on how to install it? And if there is any other dependency? Slds
Re: installation question
Dear Sir, you need to install the module web_widget_bokeh_chart that you find in this repository. https://github.com/OCA/web. In the readme it tells you to install the "bokeh" python library as follows: "pip3 install bokeh==1.1.0" Giacomo
please a demo before buying the application
please a demo before buying the application
Re: please a demo before buying the application
Dear Sir, i do not have a demo. Please find here a detailed video (40m) on how the module works. Please note that SO and PO management is not included in the video but available in the module. https://www.youtube.com/watch?v=zZs3PZ9lQOY&feature=youtu.be Regards, Giacomo