Contents of the Redistribute Revenue By Project Screen

Use the fields and options to configure the Redistribute Revenue by Project screen.

Selection Ranges

Project

Field Description
Option

This field always displays One.

Start

Enter, or click to select, a valid project number for which you would like to redistribute revenue. The unlabelled field to the right displays the project name.

Accounting Period

Use these fields to select the periods to be included in the Redistribute Revenue by Project process.

Note: You cannot run this screen for a Closed or Not Available fiscal year/period/subperiod combination. To redistribute revenue by project, you must either select another fiscal year/period/subperiod combination or you must go to the Manage Accounting Periods or Manage Subperiods screen and change the Status of the period/subperiod to Open. The subperiod cannot be open unless the fiscal year and period to which it is tied are also open.

If the period/subperiod is already set to Open but the SJR journal code has a status of Not Available, you will still not be able run this application for that period/subperiod. To redistribute revenue by project for that period/subperiod, go to the Manage Accounting Periods or Manage Subperiods screen and change the Status of the SJR code (Compute Sales Jnl (Revenue)) to Open.

Field Description
Option

This field always displays One.

Fiscal Year

Use this drop-down list to select a fiscal year. You can select any open fiscal year. This is a required field.

Period

Use this drop-down list to select an accounting period. You can select any open accounting period. This is a required field.

Subpd

Use this drop-down list to select an accounting subperiod. You can select any open subperiod as long as you have completed the Compute Revenue screen. This is a required field.

Ending Date

This non-editable field displays the selected subperiod end date.

Options

Redistribute Revenue at

Field Description
Actual Rates

Select this check box to redistribute revenue that was calculated using actual rates. You can redistribute both actual and target revenue.

Target Rates

Select this check box to redistribute revenue that was calculated using target rates. You can redistribute both actual and target revenue.

Override Variance

Use this group box to view your override variances.

Field Description
Actual

This field displays a running total (the total variance) created by your entries in the Override Percent Actual field. This is the difference between the Percent of Actual Cost and the Override Percent Actual fields. This field must be "0" before you can redistribute revenue.

Target

This field displays a running total (the total variance) created by your entries in the Override Percent Target field. This is the difference between the Percent of Target Cost and the Override Percent Target fields. This field must be "0" before you can redistribute revenue.

Project Percentages

Field Description
Project

This column displays the project numbers for each node of the project.

Percent of Actual Cost

This non-editable field displays the Costpoint-calculated percent of actual cost for each level of the project.

Override Percent Actual

Enter the override percent in this field for each level of the Project, to override the percent of actual cost computed for redistributing revenue. As you make modifications in this column, a running balance of your modifications is kept in the Actual field in the Override Variance group box. This field is unavailable if you did not select the Actual Rates check box.

Percent of Target Cost

This non-editable field displays the Costpoint-calculated percent of target cost for each level of the project.

Override Percent Target

To override the percent of target cost computed for redistributing revenue, enter the override percent in this field for each level of the project. As you make modifications in this column, a running balance of your modifications is kept in Target field in the Override Variance group box. This field is inactive if you did not select the Target Rates check box.

Level 1 - 15 Summary Actual

These non-editable fields display the Costpoint-computed summary percent of actual costs represented by that project level and the nodes below it, for the level represented by the project number on a given row.

Level 1 - 15 Summary Target

These non-editable fields display the Costpoint-computed summary percent of target costs represented by that project level and the nodes below it, for the level represented by the project number on a given row.

Redistribute Revenue by Project

Click to finalize the redistribution of revenue by calculating the amount of total project revenue that is to be received by each node on the project tree, and further partitioning that amount among the account/organization combinations for that node. Finally, Costpoint updates PROJ_SUM with a plus or minus for each account/organization/project combination that brings revenue for that combination to the desired number.