We recently had a request about being able to forecast how the cash will enter and leave the company accounts. So for each cash account (company has several bank accounts and also accept money in cash from customers) the company want’s to know (in a date in the future):
- The current amount in cash
- The amount to be received
- The amount to be paid
- The expected amount in the date ( current + received - paid)
All this information is quite valuabe to be able to move the cash amount between banks and avoid running out of cash on some bank accounts.
Another requirement is to be able to plan the movement between some bank accounts and see this amount updated on the forecast.
Our idea was to add a Many2One on move lines of receivable, payable and cash accounts to determine on which cash account the amount will be transfered to. This will allow to create a view that computes all the previous created amounts based on a query on the lines table. It should be also possible to manually create draft moves with to plan the movement between bank accounts.