ByD's standard Liquidity Forecast Report displays realized cash inflows and outflows, as well as forecasted payments and collections expected in the short and medium term. These forecasts mainly come from outstanding customer and supplier invoices, employee expenses pending to be reimbursed and tax returns to be paid; but it does NOT reflect Sales and Purchasing forecasts.
As a result of this, I often find customers who tell me they don't see the complete picture in SAP Business ByDesign and therefore end up tracking Cash Flow outside the system, through an Excel spreadsheet.
SAP BYD also offers the ability to manually create Forecast Planning Items for flows unknown by the ERP, such as for example:
- withholding tax,
- other taxes,
- financial investment interests,
- and so on.
After gathering feedback from our client portfolio, and taking advantage of Web Services and SAP Cloud Applications Studio, we have developed this Add-On solution (already available in SAP Store) that automatically creates Forecast Planning Items derived from:
Invoice Schedules of Sales Orders and Contracts.
Delivery Schedules of Purchase Orders.
This major enhacement significantly improves the accuracy of the liquidity financial indicator and enables the Management to make better investment and financing decisions.
Some of the app features are listed below:
1. Reads sales and purchasing documents
Periodically reads Sales Orders, Sales Contracts and Purchase Orders, searching for open Customer Invoice Schedule Milestones and open Supplier Delivery Schedule Items.
2. Handles payment terms
Automatically creates Forecast Planning Items for Customer Invoice Schedule Milestones and Supplier Delivery Schedule Items, considering its payment terms.
3. Allows configuration by company
Allows programming the frequency of the reading and writing jobs.
Facilitates the configuration by company of the default payment terms, house bank and language.
How does it work?
Go through this short video demo for an overview of the Add-On solution.
Other available solutions: