Show 

COMPUTE REVENUE

Use this screen to control the process of computing revenue for projects.

All computations performed by this process are controlled by the revenue formula you assigned to the project on the Manage Revenue Information screen. 

For more information on revenue computations, see "Revenue Computations."

You can start this process only after completing the Compute Burden Costs screen and before printing a Project Status Report containing revenue or profit information. Also run it before initiating the Redistribute Revenue screen or the Redistribute Revenue by Project screen.

If you are computing revenue for a new fiscal year, execute the Update Prior Year History screen to update the prior year's data before you compute revenue for the new year. Otherwise, your revenue calculations for the new year may be misstated. The Update Project Prior Year History screen combines the current year project tables (PROJ_SUM and PROJ_BURD_SUM) with the prior year project tables (PSR_PY_SUM and PSR_PY_BURD_SUM). The prior year project tables are the source for prior year cost and revenue amounts in the Compute Revenue process. If you do not update the prior year tables, revenue calculations for the new year may be incorrect. You may also want to check projects that have Fixed Amount Year to Date revenue formulas before running the Compute Revenue program for the first period of a new fiscal year. The program recognizes the amount in the YTD Revenue field of the Manage Revenue Information screen, and this may result in overstated revenue.

Global withholding information is applied only to the Equal to Billings Before Retainage (ETBBR) formula. When you use the ETBBR formula, the application treats the net withholding amount as an additional retainage amount, which is added back to the net billing amount to arrive at the revenue amount.

Costpoint has four new tables that improve the processing performance of the Compute Revenue and Calculate Standard Bills applications. If you are upgrading from Costpoint 5.x, you must run the Synchronize Project Performance Tables utility to add existing project data to the four new tables. You must also run this utility if you upload data using scripts. You may also want to run this utility at month end, before calculating revenue or standard bills, to ensure that the performance tables are in synch. Please see the documentation for the Synchronize Project Performance Tables utility for more information.
The new tables are: Project Hierarchy (PROJ_HIERARCHY), Source Project Mapping (PROJ_SRCE_PROJ), Invoice Level Mapping (PROJ_INVC_PROJ), and Revenue Level Mapping (PROJ_REV_PROJ).

Execute the Update Prior Year History screen only for fiscal years that have been calculated in Costpoint. If you have updated the prior year tables manually from the Manage Prior Year Unit Revenue screen or with scripts for a given fiscal year, do not run the Update Prior Year History screen for that same year. Doing so may cause your prior year project tables to be overwritten with zeroes. Normally, this situation occurs only in your first fiscal year in Costpoint.

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

Accounting Period

Use this group box to select which periods to include in the revenue calculation.

Option

This field always displays One.

Fiscal Year

Enter, or click to select, any open fiscal year. This is a required field.

Period

Enter, or click to select, any open accounting period. This is a required field.

Subpd

If the Restrict Revenue for Closed or N/A Periods check box is selected on the Configure Project Settings screen and you attempt to compute revenue for a Closed or Not Available fiscal year/period/subperiod combination, you receive an error message stating that the period is not open. To compute revenue, you must either select another fiscal year/period/subperiod combination or you must go to the Manage Subperiods screen and change the Status of the subperiod to Open. The subperiod cannot be open unless the fiscal year and period to which it is tied are also open.

Enter, or click to select, an open accounting subperiod. You can compute revenue only one subperiod at time. You can select any open subperiod; however, you must run the Compute Burden Costs screen for the subperiod selected. This is a required field.

Ending Date

This non-editable field displays the subperiod ending date.

Projects

Use this group box to identify which projects to include in the Compute Revenue process. Compute revenue for all projects at least once during the period close process.

Option

Use this drop-down list to select the range of projects to include. Valid options are:

Start

Use the drop-down list to select the starting project number.

End

Use the drop-down list to select the ending project number.

Revenue Formulas

Use this group box to limit which revenue formulas are included in the calculation.

Option

Use this drop-down list to select the range of revenue formulas to include. Valid options are:

Start

Enter, or click to select, the beginning revenue formula for the range to compute. Twenty-six revenue formulas are available via . This field is available only if you selected One, Range, or To End as the Option.

End

Enter, or click to select, the ending revenue formula for the range to compute. Twenty-six revenue formulas are available via . This field is available only if you selected Range or From Beginning as the Option.

Options

Process Options

Use this group box to select various processing options. The Validate Only option examines the revenue setups for direct cost ceilings that are above the revenue level. 

Select

Use this drop-down list to select a processing option. Valid options are:

Process Closed Fiscal Years

Select this check box to allow the Compute Revenue process to compute revenue for fiscal years that are closed.

You cannot post revenue for a fiscal year that is closed. If the computation of revenue results in a change to revenue, you must open the fiscal year and period in order to post the change.

Process

Click to compute revenue for the subperiod and range of projects selected.

Processing Month-End Revenue