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.

Warning: 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).

Note: 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.
Note: The UI profile you are assigned may have caused some fields to be hidden on your screen. For more information, contact your system administrator.