UPDATE INCURRED COST FOR ETC

Use this screen to update the ETC incurred hours and amounts with ITD costs from the project ledgers. Direct cost amounts come from the Project Summary table (PROJ_SUM) for the current year and Project Status Report Prior Year Summary table (PSR_PY_SUM) for prior years. Indirect cost amounts come from the Project Burden Summary table (PROJ_BURD_SUM) for the current year and the Project Status Report Prior Year Burden Summary table (PSR_PY_BURD_SUM) for prior years. Hours are summarized by PLC or GLC from the Labor History table (LAB_HS) for the current year and the Prior Year Project Labor History (PY_PROJ_LAB_HS) for the prior years.

Run this utility after posting journals, calculating rates, and computing burden.

Run this utility before you execute the Compute Estimate to Complete screen. Do this even for projects that have no incurred costs but do have ETC information. The Update Incurred Cost for ETC screen creates a row for each project in the ETC_UPD_DT table, which is required by the Create Estimate To Complete Report Tables process.

For more information about Costpoint's Estimate-to-Complete (ETC) feature, see the "Estimate to Complete" topic.

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

Projects

Use the fields in this group box to limit the project for which this update is performed.

Option

Select the appropriate range option for the projects you want to update. Valid options are:

Start

Enter, or click to select, the starting value for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending value for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Accounting Period

Select the ending subperiod of the update. Costs is summed ITD up to and including the ending subperiod selected.

Option

This field always displays One.

Fiscal Year

Select the fiscal year for the ending subperiod to be included in the update.

Period

Select the period for the ending subperiod to be included in the update.

Subpd

Select the ending subperiod to be included in the update.

Ending Date

This field displays the subperiod ending date.

Options

Update

Use the options in this group box to select various options for the update.

Incurred Costs

Select this check box to update ETC amounts with incurred costs. If you select this check box, you can update at either target or actual rates; select the appropriate option.

Actual Rates

Select this option to update incurred costs for ETC with actual rates for this budget.

Target Rates

Select this option to update incurred costs for ETC with target rates for this budget.

Incurred Hours

Select this check box to update ETC hours with incurred hours. If you select this check box, you can update by PLC or GLC; select the appropriate option.

PLC Hours

Select this option to update incurred costs for ETC using PLC hours for this budget.

GLC Hours

Select this option to update incurred costs for ETC using GLC hours for this budget.

Date

Use this group box to enter the revision date. This date can assist you when you are assessing the age of the data on the Manage Estimate to Complete Amounts screen.

Revision Date

Costpoint date defaults into this field and can be modified. The date entered (the incurred date) is used in the ETC tables that show updated incurred costs and hours and appears in the Incurred field in any screens where the Date Updated group box is displayed.

Process

Click to start the update process.