Previous	Next		Contents	Index	Navigation	Glossary	Library

Changes Allowed on Cash Forecast Templates and Cash Forecasts
	Change Descriptive Information?	Add Rows and Columns	Delete Rows and Columns	Change Forecast Amounts
New Templates	Yes	Yes	Yes	N/A
Templates Used to Generate Forecasts	Yes	Yes, but also modifies all existing forecasts based on this template.		N/A
Forecasts	Yes	Yes, with an option to modify original template and all existing forecasts based on that template; or to create new template.	No	Yes, modify values directly in fields, or use the Special menu. Forecast summary amounts and GL Cash Position cannot be modified, but are automatically updated to reflect forecast amount changes.

Modifying Templates

   To query an existing cash forecast template to make modifications:

1. Navigate to the Forecast Templates window. The Find Forecast Templates window appears first for you to enter search criteria.

2. (Optional) Enter a partial or full Template Name.

3. (Optional) Select a forecast period type in the Forecast By field.

4. Choose Find. The Forecast Templates window appears. Cash Management displays all cash forecast templates that match your search criteria.

   To modify a cash forecast template:

1. Query an existing cash forecast template (see above).

2. If no cash forecasts exist based on a template, you can modify any of the information for the cash forecast template.

3. Add or delete columns or rows. See Creating Cash Forecast Templates.

4. Save your work.

Attention: Adding columns and rows generates forecast amounts of zero for the new cells.

See Also

To add a column to an existing cash forecast

To modify a row on an existing cash forecast

Modifying Forecasts

   To query an existing cash forecast to make modifications:

1. Navigate to the Cash Forecasts window. The Find Cash Forecasts window appears first for you to enter search criteria.

2. (Optional) Enter a partial or full Template Name, or a partial or full Forecast Name. Enter a forecast period type in the Forecast By field. If you enter a forecast period type, you can then select From and To values for a Start Period or Start Date.

3. Choose Find to find all cash forecasts that match your search criteria. The Cash Forecasts window appears, with a row showing each forecast and its Forecast Name, Template Name, Start Date, Forecast By, and Description.

Note: Within the Cash Forecasts window, you can show, hide, and move fields, and make them wider, narrower, or change their prompt. You can save your changes as folders for yourself or others to use. Refer to the Oracle Applications User's Guide for more information on modifying and saving folders.

Note: Choose the Requery button to find all existing cash forecasts without using any search criteria. (Choose the Find button on the tool bar to bring up the Find Cash Forecasts window again.)

   To modify header level information on an existing cash forecast:

1. Query an existing cash forecast (see above).

2. Choose Open to view cash forecast definition information. The Cash Forecast window appears.

3. You can change the name and description of the cash forecast. All other cash forecast definition information at this level is restricted from update.

4. If you are proceeding to the Cash Forecast Amounts window, choose how you want to view the amounts by selecting a Factoring format:

• Units. Displays amounts as calculated.

• Thousands. Displays forecast amounts as multiples of a thousand (1,000 = 1.00).

• Millions. Displays forecast amounts as multiples of a million (1,000,000 = 1.00).

• Billions. Displays forecast amounts as multiples of a billion (1,000,000,000 = 1.00).

5. If you are proceeding to the Cash Forecast Amounts window, you may choose to check the Display Forecast Summary check box to show the Cash Inflow, Cash Outflow, Net Cash summary, and GL Cash Position fields in the Cash Forecast Amounts window. (Keeping these fields hidden helps speed navigation performance for very large forecasts.)

6. Save your work.

See Also

   To modify forecast amounts on an existing cash forecast:

1. Complete the task to query an existing cash forecast (see above).

2. Choose the Review button to update or view cash forecast data. The Cash Forecast Amounts window appears.

Note: Within the Cash Forecast Amounts window, you have limited folder capabilities; you can show, hide, and move fields, and make them wider, narrower, or change their prompt. You cannot, however, save folder information. Refer to the Oracle Applications User's Guide for more information on modifying folders.

3. Make any changes to the forecast cell amounts. You can override any forecast amounts from the cash forecast, except the forecast summary amounts. The forecast summary amounts automatically reflect forecast amount changes.

The GL Position starting balance is the sum of all the GL Cash Position rows' account balances. Cash Management adds the net cash flow amount for the first forecast period to the beginning balance to show as the first period's GL Position. From the second forecast period, Cash Management calculates the current period's GL Position amount from the net cash flow amount by adding the previous period's GL Position.

4. You can make amount or percentage changes to column ranges in a cash forecast. Choose Update Amount from the Special Menu. The Update Amount window appears.

5. Save your work.

6. Close the windows when you are finished updating the forecast amounts, or proceed to the following tasks.

   To add a column (forecast period) to an existing cash forecast:

1. Complete the task to query an existing cash forecast and to modify forecast amounts on an existing forecast (see above).

2. Choose the Add Column button. The Add Column window appears.

3. Enter a unique Column Number and GL Periods/Days From and To values.

Values must be integers between 1 and 999. The Column Number indicates the sequence of the columns in the forecast.

4. Check the Create New Forecast Template check box if you do not want the new column to be added to all existing forecasts that are based on the original template for the forecast. Checking this box creates a new template with the same rows and columns as this forecast, including the column you are adding.

Attention: When you add a column or row to an existing forecast, you have the option to modify all forecasts using the template, including the template itself; or to create a new template with the additional column or row.

5. If you checked the check box in the previous step, enter a Template Name for a new template.

6. Choose Add to save the column and the new or modified template.

Note: If you have created a new forecast template, further changes that you make from this point are made on the new template. You can make further changes to the new template now, or query it later.

   To modify a row on an existing cash forecast:

1. Complete the task to query an existing cash forecast and to modify forecast amounts on an existing forecast (above).

2. Choose the Add Row button. The Add Row window appears.

3. Enter a Row Number. Values must be integers between 1 and 999. The Row Number indicates the sequence of the rows in the forecast.

4. Choose a Source of either User-defined Inflow or User-defined Outflow. This creates a new row, filled with zeros, in the forecast for you to manually enter a definition and forecast amounts.

Note: If you want to add standard sources that are not yet a part of your template, use the Forecast Templates window. See Modifying Templates.

5. Check the Create New Forecast Template check box if you do not want your new row to be added to all forecasts using the original template for your forecast. Checking this box creates a new template with the same rows and columns as this forecast, plus the row you are adding.

Attention: When you add a column or row to an existing forecast, you have the option to modify all forecasts using the template, including the template itself; or to create a new template with the additional column or row.

6. If you checked the check box in the previous step, enter a Template Name for a new template.

7. Choose Add to save the row and the new or modified template.

Note: If you have created a new forecast template, further changes that you make from this point are made on the new template. You can make further changes to the new template now, or query it later.

See Also