Cash Forecasting in R12

How to configure cash forecasting

When planning the short or long term funding requirements of a business, it is more important to forecast the likely cash requirements. It is a planning tool that helps to anticipate the flow of cash in and out of our business. Cash Flow forecasts help us to build a model of the way in which cash moves within an organization or project. This cash forecasting can be framed for few weeks or months based on the client’s requirement.

Define forecast templates with specifications and we can modify the template whenever we need or business forecast changes.

Let us create forecast template for 30 days

Go to Cash Management responsibility and click cash forecasting

Click forecast templates

Click create template

Name the template and select the forecast by days / GL period and select exclude or include for overdue transactions. In this article I have used days and exclude overdue transactions.

Click next

Add source type row for Supplier invoice / Supplier payments / Customer invoice/ Customer receipts. There are lot more to include, which are listed in the screen shot below

This article will have only 4 source types as mentioned above for learning purpose. Reader can add any source type as client needs. Whatever the source type we select should have future dated transactions to appear in forecast results.

Select supplier invoice and click go

We have various filters to limit the cash forecasting by OU / Ledger / Pay group / Supplier type etc

Similarly continue for rest of the three types and allocate row number 20 / 30 /40.

Click next and configure the column details as follows

Click finish.

Now run the cash forecasting configured and check the results

Query the template and click go

Click run forecast. This is the way we submit the request to process cash forecast.

After request completed successfully check the process status – sign should be

Check the results.