Using Predictive Planning for Cash Forecasting

You can use Predictive Planning to forecast cash based on the historical data for the line item using time-series forecasting techniques.

To use Predictive Planning to forecast cash:

  1. From the Home page, click Daily Cash Forecast or Periodic Cash Forecast.
  2. Click the Predicted vertical tab.
  3. Select the appropriate members from the POV.
  4. Select a line item, and then from the Actions menu, select Predictive Planning.

    The prediction runs, and a results area opens below the form with a chart and detailed information about the prediction.

  5. To get more information about the data in the chart and the predicted values:

    • Use the tooltips for each data series in the chart to get more information about the values.

    • Use the Info Boxes to see details about each data series on the chart.

    • Review the risk gauge in the Info Box, which indicates the probability of a scenario occurring above or below the prediction.

    • Click Details icon (Details) to get more information about the prediction data or the historical data.

    • Use the tooltips to get insight about the detail information.

  6. You can customize the chart (click Settings in the Chart area), or change the prediction options, including the date ranges, chart view settings, and prediction options (click Settings in the Info Box area).
  7. In the chart area, you can select a different line item to see predicted values for.
  8. You can copy predicted values and paste them into a scenario on the form. In the Info Boxes area, click Paste, then select options from the Paste Prediction box, and then click Apply. Then, save the form.

    You can see all of the updated cash outflow forecasts in the Rolling Forecast form. See Performing Daily and Periodic Cash Forecasting.

For more information about using Predictive Planning, see Improving Forecasting Accuracy with Predictive Planning in Working with Planning.

Predictive Planning selects the best prediction method to use, selecting the method that gives the most accurate results based on the data available. For more information about the statistical forecasting methods, see Predictive Planning Forecasting and Statistical Descriptions in Working with Planning.

Note:

For Interactive Predictive Planning, Receivable Invoices, Overdue Invoices, Payable Invoices, Payable Overdue Invoices will not provide any results as there is no historical data in these lines. However you can use AutoPredict, because it allows you to reference a different line item for predicting.

Predictive Planning is not relevant for Receivables Overdue or Payables Overdue Invoices as they have no historical actual data.