v 10.0 v 11.0 v 12.0 Third Party 93
Required Apps Invoicing (account)
Lines of code 1569
Technical Name treasury_forecast
LicenseOPL-1
Websitehttps://github.com/jackjack82
Also available in version v 10.0 v 11.0 v 13.0
You bought this module and need support? Click here!
Required Apps Invoicing (account)
Lines of code 1569
Technical Name treasury_forecast
LicenseOPL-1
Websitehttps://github.com/jackjack82
Also available in version v 10.0 v 11.0 v 13.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:

  1. Plan your treasury with your planned cash moves
  2. Add draft invoices and any other account moves to your cash planning
  3. Print table with daily total balance,
  4. Print daily balance with all operations,
  5. Export in Excel,
  6. Chart view of the daily balances
  7. 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

  • 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 or have a question related to your purchase, please use the support page.
Amazing and powerful app
by
Camilo
on 8/9/19, 4:39 PM

Very useful app to forecast your cash flow over time!


Good support and good module
by
Mostafa Abd El Fattah
on 4/9/19, 11:06 AM

I want to thank the author for his quick support for my clarification.


demostration
by
Felipe Carvajal
on 7/25/20, 11:27 PM

do you have video as demo?


Graph Error
by
Stefanus Eko Yulianto
on 2/11/20, 3:55 PM

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
by
Stefanus Eko Yulianto
on 2/7/20, 2:38 AM

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
by
Giacomo Grasso
on 2/7/20, 3:30 AM Author

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
by
Denis Barbosa Beliajevas
on 1/22/20, 2:38 PM

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
by
Giacomo Grasso
on 1/23/20, 3:13 AM Author

Dear Denis, write me directly at giacomo.grasso.82@gmail.com . we can set a HG call. giacomo


Demo Access
by
Denis Barbosa Beliajevas
on 1/22/20, 8:31 AM

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
by
Giacomo Grasso
on 1/22/20, 11:41 AM Author

Dear Denis, username: "demo" and password: "demo" giacomo


I couldn't access to the test environement
by
Mourad Meziou
on 12/27/19, 10:13 AM

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
by
Giacomo Grasso
on 1/22/20, 11:41 AM Author

Dear Mourad, username: "demo" and password: "demo" giacomo


We need a demo, and upgrade to Odoo13
by
Talal Albahra
on 12/2/19, 11:08 PM

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
by
Giacomo Grasso
on 1/22/20, 11:42 AM Author

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
by
asoutter@sasmar.com
on 10/30/19, 7:08 AM

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
by
Giacomo Grasso
on 10/30/19, 9:11 AM Author

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
by
Stefanus Eko Yulianto
on 10/21/19, 5:18 PM

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
by
Giacomo Grasso
on 10/23/19, 2:24 AM Author

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
by
Sebastián Gajardo
on 7/23/19, 2:16 PM Confirmed Purchase

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
by
Giacomo Grasso
on 8/7/19, 2:48 AM Author

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
by
Sebastián Gajardo
on 7/21/19, 12:40 PM Confirmed Purchase

please a demo before buying the application

Re: please a demo before buying the application
by
Giacomo Grasso
on 7/22/19, 2:07 AM Author

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