This optional maintenance screen lets you review or enter manual edits and additions to the system-generated cash forecast prior to printing.
This option is especially useful when creating a long-term forecast. You can use this screen to add data elements to the report which were not derived from the Costpoint data entry screens.
Any changes or category modifications to reflect new sources of cash need to be performed in the Cash Forecast Template screen, and accounts need to be linked accordingly.
Since this is not a required screen, you can proceed directly to the Print Cash Forecasts screen. If you need to make adjustments after printing the cash forecast, then return to this screen to enter cash forecast modifications.
You can also use the Export button located on the menu bar to export the template data to Excel by using a CSV-format file. This function enables you to perform additional data manipulation if needed.
You will need to first set up required organization security screens in Costpoint System Administration. You can activate organization security in the Maintain Users and System Settings screens.
For more information about organization security and how to apply it, please refer to System Administration Special Topic SA-5 - Organizational Security - as well as the documentation for the Organizational Security menu in Costpoint System Administration.
You must first run the process from the Create Preliminary Cash Forecasts screen before using this optional screen. If no modifications are needed to the cash forecast, then you can proceed directly to the Print Cash Forecasts screen.
This screen is blank when you access it for the first time. Use the selection criteria in the Query menu option to retrieve an existing cash forecast.
The template code is automatically displayed from your selected cash forecast in this non-editable field.
The frequency code is automatically displayed from your selected cash forecast in this non-editable field.
The organization is automatically displayed from your selected cash forecast in this non-editable field.
The cash forecast line title is automatically displayed in this column. Line titles are derived from the cash forecast template and cannot be edited. All changes to the template are made in the Maintain Cash Forecast Templates screen, and accounts need to be linked accordingly.
In this column the system automatically displays the column 1 amount as a result of the setup in the Create Preliminary Cash Forecasts screen. The system process calculates this amount as derived from the tables based on the Cash Forecast Ranges parameters. The column 1 amount cannot be edited but can be modified by entering an adjustment in the column on the dedicated adjustment column. The system displays up to six column amounts.
Use this column to enter an adjustment, as applicable, which will change the system-derived number established by the Create Preliminary Cash Forecasts application. You can enter up to six adjustment amounts.
Select this option to add supporting notes for details displayed on the Cash Forecast report. Notes are displayed at the end of the report.