Previous  Next          Contents  Index  Navigation  Glossary  Library

Generating Cash Forecasts from Templates

Creating cash forecast templates allows you to preserve specifications for future use. You can run the calculations, or generate, cash forecasts as needed or regularly. You enter criteria like start date and exchange rate when you submit a forecast to generate exactly the forecast you need.

When you submit a cash forecast for calculation, Cash Management collects the necessary source data and summarizes the information as cash forecast amounts, based on the forecast period specifications. The forecast data is then available for update, inquiry or reporting purposes, or for export to any spreadsheet application.

Cash Management determines projected cash activity dates based on your specifications. For example, if the source type is AP Invoices, the expected cash activity date is based on either the discount date or the due date depending on your selection in the template. Refer to the Cash Forecasting Source Transaction Dates table.

When you generate a cash forecast you have the option of selecting one or more sources to be processed, by requesting the row number. You can submit separate processes to generate partial forecasts where Cash Management selects transactions from one source type at a time.

If you have created a forecast template that includes a user-defined source type, Cash Management creates a blank row for that source type when you generate a cash forecast. You can then enter amounts manually in the forecast amount cells using the Cash Forecasts window, or using a spreadsheet application on an exported cash forecast.

You might generate a new cash forecast because you have created a new template, or because you want to recalculate a forecast with different criteria.

You can generate forecasts in the following ways:

Forecasting Open Interface and Distributed Database Integration

The Forecasting Open Interface allows you to utilize external sources of data as cash inflow and outflow data for the Cash Forecasting feature, providing you an enterprise-wide cash forecasting solution on a distributed database environment.

You can generate a cash forecast and the Forecasting Open Interface automatically retrieves information available from the external forecast sources you have defined.

See Also

Generating a Cash Forecast with Amounts Calculated Automatically

Creating a Manually Entered Cash Forecast

Exporting Cash Forecasts to Microsoft Excel Spreadsheets

Viewing Cash Forecasts

Cash Forecasting Reports

Forecasting Open Interface

Prerequisites for All Methods of Generating Cash Forecasts

Generating a Cash Forecast with Amounts Calculated Automatically

   To create a cash forecast using the Submit Forecast window:

   To create a cash forecast using the Submit Request window:

Suggestion: Consider using report sets if you routinely generate a given set of cash forecasts.


         Previous  Next          Contents  Index  Navigation  Glossary  Library