Create Preliminary Cash Forecasts

Use this screen to select a template created on the Manage Cash Forecast Templates screen as a parameter from which to create the cash forecast report.

The cash forecast that is generated is based on the lines that are linked to the accounts (in which data was entered by means of various Costpoint screens).

There are two steps to the Create Preliminary Cash Forecasts process.

The first step determines the actual beginning balance:

• Costpoint begins by selecting the last accounting period end balance before the cash forecast start date.
• Rows are selected for all accounts that match the accounts linked to the cash forecast lines and the organizations that match the screen selections.
• The amounts are summarized by balance sheet organization.
• Costpoint adds in any amounts that were not posted in or before the last fiscal year/period in which the appropriate date falls between the last accounting period end date and the cash forecast starting date.

The second step calculates the forecasted amounts included in the Cash Forecast based on the selected cash forecast range parameters. The application retrieves the posted data from the tables.

For example, in Accounts Payable, the application looks for vouchers that were entered and posted. When vouchers are entered, Costpoint retrieves data from the VCHR HDR and LN tables. When vouchers are posted, the data comes from the VCHR HDR_HS and LN_HS tables.

During this process, the application runs the necessary queries to pull the forecasted amounts into the report in accordance with the accounts that were linked to the forecast lines in the template, and how the date-specific columns were set up on this screen.

For more information, see the Cash Forecasting Overview.

Use this screen after you have created the cash forecast template.