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.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Use the fields in this block to select a template code, frequency code, and balance sheet organization for the process.
Template Code
Option
This displays One to indicate that you can enter only one template code.
Start
Enter, or click 
to select, the template code to use. The template codes that you established on the Manage Cash Forecast Templates screen display as the selection options. The template code can be used in conjunction with different frequency codes.
Template Description
This field displays the template code description that you established for the template code on the Manage Cash Forecast Templates screen.
Frequency Code
Option
This displays One to indicate that you can enter only one frequency code.
Start
From the drop-down list, select a frequency code. Valid options are:
-
None
-
Daily
-
Weekly
-
Monthly
-
Quarterly
The frequency code can be used in conjunction with different template codes, which allows you to select from the drop-down list, rather than use .
Balance Sheet Organization
Use the fields in this row to choose the balance sheet organization selection parameters for the process.
Option
From the drop-down list, select a type of range for the balance sheet organizations to use for the preliminary cash forecast. Valid options are:
-
All — Select this option to populate cash forecasts for all existing organizations with accounting activity for the screen selections. The Start and End fields are disabled for this option.
-
One — Select this option to include only one balance sheet organization in the process. Enter the balance sheet organization in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of balance sheet organizations on the report. Enter the beginning balance sheet organization in the Start field and enter the ending currency in the End field.
-
From Beginning — Select this option to include a range that starts from the beginning of all available balance sheet organizations and ends with the balance sheet organization that you enter in the End field. The Start field is disabled for this option.
-
From End — Select this option to include a range that starts with the balance sheet organization that you enter in the Start field and ends with the last balance sheet organization in the list of all balance sheet organizations. The End field is disabled for this option.
Start
If you selected One, Range, or To End in the Option field, enter, or click to select, the starting balance sheet organization to include for the preliminary cash forecast. If you selected All or From Beginning in the Option field, the Start field is unavailable.
End
If you selected Range or To End in the Option field, enter, or click to select, the ending balance sheet organization to include for the preliminary cash forecast. If you select All, One, or To End in the Currency field, the End field is unavailable.
Cash Forecast Ranges
Use the fields in this group box to enter default column headings and ending dates for the six columns of the preliminary cash forecast.
Heading
For each column 1 through column 6, enter the default column heading for the printed cash forecast.
A cash forecast displays a maximum of six columns.
Start
This field displays automatically in combination with the frequency code and the first ending date.
End
For each column 1 through column 6, enter the first end date that is associated with the frequency code. This allows the application to calculate the data to be included in the columns.
Options
Use the check boxes in this group box to indicate whether or not to include purchase order commitments and/or clear adjustments that are associated with this forecast.
Include Commitments
Select this check box to include commitments created by purchase order entry. As a result, purchases do not have a material cash impact before vouchers are created.
Clear Adjustments
Select this check box to clear all adjustments that are associated with this forecast. To reuse this cash forecast, the adjustments that are entered on the Manage Preliminary Cash Forecasts screen must be cleared by selecting this check box.