Project Budget Forecast

Form ID: (PM209600)

You can use this form to create and modify project budget forecasts that can be compared with the actual project costs and incomes for each financial period. You can add a project budget forecast manually or upload the forecast from an Excel file.

This form is available if the Budget Forecast feature is enabled on the Enable/Disable Features (CS100000) form.

Form Toolbar

The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.


Command	Description
Generate Periods	Adds financial periods of the master calendar for all the project budget lines listed in the table according to the selection criteria specified in the Selection area. For more information on how the system determines the range of periods to be added, see Project Budget Forecasts: Generation of Periods.
Copy Revision	Opens the Copy Revision dialog box, where you can create a copy of the forecast revision and specify the ID of the new revision.
Generate Forecast	Opens the Distribute dialog box, where you can specify the settings for distribution of the quantities and amounts of project budget lines among period lines.
Print Project Budget Forecast	Opens the Project Budget Forecast by Month (PJ629600) report for the current forecast revision.

Table 1. Copy Revision Dialog BoxYou use this dialog box to create a copy of the selected revision of the project budget forecast.
Element	Description
New Revision	The identifier of the new revision of the project budget forecast. The length of the identifier, which can consist of only alphanumeric characters and spaces, can be 10 or fewer characters.
This dialog box has the following button.
OK	Creates a new revision of the project budget forecast as a copy of the selected revision, and closes the dialog box.
Cancel	Cancels the creation of a copy of the selected project budget forecast, and closes the dialog box.

Table 2. Distribute Dialog BoxYou use this dialog box to distribute the quantities and amounts of the listed project budget lines (which are those to which the system applied the selection criteria you specified in the Summary area) among period lines. The distribution function rounds equally distributed values using the built-in logarithmic rounding algorithm.
Element	Description
Value section: In this section, you select one of the following option buttons.
Distribute Total	An option button that indicates (if selected, which is its default value) that the system should distribute the values of the project budget line among all its period lines equally. Any values that have already been specified for the period lines will be overridden. By default, this option button is selected.
Add Delta	An option button that indicates (if selected) that the system should add the delta, which is the difference between the values of the project budget line and the total values of its period lines, to all the period lines in proportion to the values that have already been specified for the period lines.
Columns section: In this section, you select the following check boxes, all of which relate to how the system will distribute the values in particular columns.
Original Budgeted Quantity	A check box that indicates (if selected) that the system should distribute the values in the Original Budgeted Quantity column. By default, this check box is selected.
Original Budgeted Amount	A check box that indicates (if selected) that the system should distribute the values in the Original Budgeted Amount column.
Revised Budgeted Quantity	A check box that indicates (if selected) that the system should distribute the values in the Revised Budgeted Quantity column. By default, this check box is selected.
Revised Budgeted Amount	A check box that indicates (if selected) that the system should distribute the values in the Revised Budgeted Amount column. By default, this check box is selected.
Rows section: In this section, you select one of the following option buttons.
All Budget Lines	An option button that indicates (if selected) that the system should distribute the values of all the project budget lines listed in the table. By default, this option button is selected.
Selected Budget Line	An option button that indicates (if selected) that the system should distribute the values of only the project budget line that is selected in the table. (You select the line by clicking it before you run the forecast generation.)
Value section: In this section, you select one of the following option buttons.
Buttons: This dialog box has the following button.
OK	Distributes the quantities and amounts of project budget lines among the period lines by using the settings you have specified in the dialog box, and closes the dialog box.
Cancel	Cancels the distribution and closes the dialog box.

Selection Area

You can use the elements in this area to add a new revision of the project budget forecast or select an existing revision of the project budget forecast and view its details. You can also use the elements in the area to filter the project budget lines of the selected forecast revision that are listed in the table. For instance, you can display only budget lines associated with a specific project task, account group, type of the account group, inventory item, or cost code—or any combination of these criteria.


Element	Description
Project	The identifier of the project. If you are entering a new revision of the project budget forecast or attempting to view an existing one, select the appropriate project identifier.
Revision	The revision identifier of the project budget forecast. If you are creating a new revision, enter an alphanumeric identifier, which must be unique within the project. To view an existing revision, select the revision identifier after you select the project identifier. The length of the identifier, which can consist of only alphanumeric characters and spaces, can be 10 or fewer characters.
Description	The description of the revision of the project budget forecast.
Project Task	The task of the selected project. If you select a task, the system displays in the table only the project budget lines for this task.
Type	The type of account groups for which project budget lines should be displayed in the table. You select one of the following options: All: To view account groups of all types Asset: To view account groups of the Asset type Liability: To view account groups of the Liability type Income: To view account groups of the Income type Expense: To view account groups of the Expense type Off-Balance: To view account groups of the Off-Balance type By default, the All type is selected.
Account Group	The account group for which you want to view project budget lines in the table. You can select an account group or leave the box blank to view project budget lines for all account groups of the selected type.
Inventory ID	The inventory item for which you want to view project budget lines in the table; select an item to view only project budget lines for this item.
Cost Code	The cost code for which you want to view project budget lines in the table. You can select a cost code or leave this box blank. This box appears on the form only if the Cost Code feature is enabled on the Enable/Disable Features (CS100000) form.
Project Currency	The project currency of the selected project. The amounts in the table are shown in this currency. This box appears on the form only if the Multicurrency Projects feature is enabled on the Enable/Disable Features form.

Table

This table lists the following types of project budget forecast lines:

Budget lines of the selected project, which are read-only.
Period lines, which are forecast lines broken down by the applicable financial periods, that have been added for the project budget lines. For these lines, you can modify the Original Budgeted Quantity, Original Budgeted Amount, Revised Budgeted Quantity, and Revised Budgeted Amount.
Total lines, which are the total of the period lines and which are read-only.
Delta lines, which are read-only and are the difference between the value of the project budget line and the total of the period lines.

In the table, the system lists only the project budget lines that meet the selection criteria you have specified in the Summary area.

Table 3. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Add Periods	Opens the Add Periods dialog box, where you can specify the range of periods to be added for the budget line you have selected before invoking this command.
Update Project Budget Line	Updates the following quantities and amounts of the corresponding project budget line on the Projects (PM301000) form with the delta values of the selected line of the forecast revision: Original Budgeted Quantity Original Budgeted Amount Revised Budgeted Quantity Revised Budgeted Amount The original values of the project budget can be updated if the project budget is not locked. The revised values of the project budget can be updated if the change order workflow is disabled for the project.
Update Forecast Lines	For the selected project budget line of the forecast revision (that is, the line you selected before invoking this action), adds the financial periods to which actual values or change order values have been posted for the project budget line and that have been missed in the forecast revision.

Table 4. Table Columns
Column	Description
Project Task	The project task that is associated with the budget line. This column is empty for period, total, and delta lines.
Account Group	The account group that is associated with the budget line. This column is empty for period, total, and delta lines.
Inventory ID	The inventory item that is associated with the budget line. This column is empty for period, total, and delta lines.
Cost Code	The cost code that is associated with the budget line. This column is empty for period, total, and delta lines. The column is shown if the Cost Code feature is enabled on the Enable/Disable Features (CS100000) form.
Description	The description of the budget line. This column is empty for period, total, and delta lines.
Planned Start Date	The date when the project task is expected to start. This column is empty for period, total, and delta lines.
Planned End Date	The date when the project task is expected to end. This column is empty for period, total, and delta lines.
Financial Period	The financial period of the master calendar. This column is empty for budget lines.
Original Budgeted Quantity	The original budgeted quantity. Depending on the type of the project budget forecast lines, this column contains the following values: For a budget line, the original quantity of the project budget line. For a line of this type, the column is read-only. For a period line, the forecasted quantity for the financial period. You can enter the quantity in the column manually or update it by clicking Generate Forecast on the form toolbar. For a total line, the total forecasted quantity of the period lines. For a line of this type, the column is read-only. For a delta line, the difference between the original quantity of the project budget line and the total forecasted quantity of the period lines. For a line of this type, the column is read-only.
Original Budgeted Amount	The original budgeted amount. Depending on the type of the project budget forecast lines, this column contains the following values: For a budget line, the original amount of the project budget line. For a line of this type, the column is read-only. For a period line, the forecasted amount for the financial period. You can enter the amount in the column manually or update it by clicking Generate Forecast on the form toolbar. For a total line, the total forecasted amount of the period lines. For a line of this type, the column is read-only. For a delta line, the difference between the original amount of the project budget line and the total forecasted amount of the period lines. For a line of this type, the column is read-only.
Revised Budgeted Quantity	The revised budgeted quantity. Depending on the type of the project budget forecast lines, this column contains the following values: For a budget line, the original quantity of the project budget line. For a line of this type, the column is read-only. For a period line, the forecasted quantity for the financial period. You can enter the quantity in the column manually or update it by clicking Generate Forecast on the form toolbar. For a total line, the total forecasted quantity of the period lines. For a line of this type, the column is read-only. For a delta line, the difference between the original quantity of the project budget line and the total forecasted quantity of the period lines. For a line of this type, the column is read-only.
Revised Budgeted Amount	The revised budgeted amount. Depending on the type of the project budget forecast lines, this column contains the following values: For a budget line, the original amount of the project budget line. For a line of this type, the column is read-only. For a period line, the forecasted amount for the financial period. You can enter the amount in the column manually or update it by clicking Generate Forecast on the form toolbar. For a total line, the total forecasted amount of the period lines. For a line of this type, the column is read-only. For a delta line, the difference between the original amount of the project budget line and the total forecasted amount of the period lines. For a line of this type, the column is read-only.
Potential CO Quantity	The total quantity of the potential changes to the project budget. The column is read-only.
Potential CO Amount	The total amount of the potential changes to the project budget. The column is read-only.
Budgeted CO Quantity	The total quantity of the lines of released change orders that are associated with the project budget line. The column is read-only and empty for period lines.
Budgeted CO Amount	The total amount of the lines of released change orders that are associated with the project budget line. The column is read-only and empty for period lines.
Actual Quantity	The total quantity of the lines of the released accounts receivable invoices that correspond to the project budget line. The column is read-only and empty for period lines.
Actual Amount	The total amount of the lines of the released accounts receivable invoices that correspond to the project budget line. The column is read-only and empty for period lines.
Revised Quantity - Actual Quantity	The difference between the Revised Budgeted Quantity and the Actual Quantity. The column is read-only and empty for period lines.
Revised Amount - Actual Amount	The difference between the Revised Budgeted Amount and the Actual Amount. The column is read-only and empty for period lines.

Table 5. Add Periods Dialog BoxYou use this dialog box to add a range of financial periods for the project budget line you selected before you clicked Add Periods on the table toolbar.
Element	Description
Period From	The starting financial period of the range of periods to be added from the master calendar.
Period To	The ending financial period of the range of periods to be added from the master calendar.
Start Date	The starting date of the period selected in the Period From box. When you select the starting financial period, the system fills in this date automatically; it cannot be changed.
End Date	The ending date of the period selected in the Period To box. When you select the ending financial period, the system fills in this date automatically; it cannot be changed.
This dialog box has the following button.
OK	Adds one period line for each financial period in the range you have specified with quantities and amounts of zero and closes the dialog box.
Cancel	Cancels the creation of period lines and closes the dialog box.