REBUILD LABOR HISTORY

It is extremely important that no one is using Costpoint or accessing the database while this program is being executed. We highly recommend that you disable logins before running this program and make a database backup.

If you believe that Labor History is incorrect because of a process failure or because of user modifications, you can use this utility to rebuild it using source records from Timesheet History, Journal Entries, Vouchers, and Inter-Company Work Orders (IWOs). The utility first checks to ensure that the General Ledger and source tables are reconciled.  (Since there are no history tables for IWOs, Costpoint builds LAB_HS (Maintain Labor Summary) for this process from the General Ledger, and therefore it is not included in the reconciliation report.) You must print the reconciliation report before you can print the exception reports and rebuild Labor History. The exception report prints before the Rebuild Labor History process is executed so that you can see the differences that overwrite Labor History. 

Since LAB_HS is the source table for labor revenue on T&M contracts and billable value on labor, any modifications made to LAB_HS (Maintain Labor Summary) affect revenue, billing, and goal calculations. Because of this, this utility allows you to be very specific when you select rows to be fixed. 

You must run the Load Labor Rates screen for any subperiod for which the toolkit is executed and rows are modified. In addition, any rows that are rebuilt no longer have allowable hours existing in LAB_HS (Maintain Labor Summary).  Consequently, if revenue is not computed in the periods that were modified or subsequent periods (after rates are loaded for all modified periods), the revenue worksheet does not agree with the revenue on the Project Status Report (PSR).

When selecting Projects/Accounts/Orgs, the utility considers all projects/accounts/orgs selected at that level and below.  Since projects can be NULL in LAB_HS (Maintain Labor Summary), the application considers all account/orgs selected and projects within that range, if any exist. If the Select Projects Range Option is All and there are records within the Account/Org range that do not have projects, those records are included in the comparison along with records that do include projects. If you select any Range Option other than All, Costpoint does not consider records within the account/org selection where there are no projects.

Since this utility rebuilds Labor History using source tables that include Journal Entry History, Voucher History, and Timesheet History, you can rebuild history only for subperiods in which the source tables exist. You must print the Reconciliation of GL to Source Tables report before you can print the exception report and rebuild Labor History.

There are no source tables for IWOs from which to rebuild labor history. Therefore, the IWO transactions in labor history are rebuilt from the General Ledger. Because of this, the IWOs are not considered in the Reconciliation of GL to Source Tables report.

You may need to run the Load Labor Rates process for any subperiod for which the toolkit is executed and rows are modified. 

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 these fields to select the projects you want to include in this process.

You can process the report for only one period at a time.  However, you can selectively run the report for projects, accounts, and organizations, or you can make it all inclusive. If you select one project, account, or organization, the comparison is made at and below the specified level. Since projects can be NULL in LAB_HS, the system considers all accounts/organizations selected and projects within that range, if any exist. If you select All as the Projects Option and there are records within the account/org range that do not have projects, Costpoint includes those records in the comparison along with ALL projects.  If you select a Projects Option other than All, Costpoint does not consider records within the account/org selection that have no projects.

Option

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

Start

Enter, or click to select, the starting project 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 project to include. If you select All, One, or To End in the Option field, this field is inactive.

Accounts

Use these fields to select the accounts you want to include in this process.

Option

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

Start

Enter, or click to select, the starting account 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 account to include. If you select All, One, or To End in the Option field, this field is inactive.

Organizations

Use these fields to select the organizations you want to include in this process.

Option

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

Start

Enter, or click to select, the starting organization 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 organization to include. If you select All, One, or To End in the Option field, this field is inactive.

Accounting Period

Fiscal Year/Period

Option

This field always displays One.

Start Fiscal Year

Enter, or click to select, the starting fiscal year.

Star Period

Enter, or click to select, the starting period.

Subperiod

Option

Use the drop-down list to select the range of subperiods for which you want to rebuild labor history. Valid options are:

Start Subperiod

Use the drop-down list to select the starting subperiod.

End Subperiod

Use the drop-down list to select the ending subperiod.

Options

Select Process

You must first select the Reconcile GL to Source Tables option and print the reconciliation reports. If differences are found, the Rebuild Labor History option is still available. You can select it and print the exception report and rebuild labor history.

Reconcile GL to Source Tables

Select this option to reconcile the GL to the source tables. Click to print the reports.

Two groups of reconciliations can be performed from the source tables to the GL for the selected fiscal year/period/subperiod/projects/accounts/orgs: 

  1. If you select Employees or Both in the Include field, Costpoint compares the Timesheet History and Journal Entries that include rows in JE_TRN_LAB_EMPL_HS to the GL. Temp tables are built to hold summary amounts from the GL and also from Timesheet History and Journal Entries. 

Two reconciliation reports are printed. The first is a comparison of the Timesheet History (LD) to Labor Distribution postings to the GL (GLD). The report is titled "Timesheet History to GL Reconciliation." The second report is the Journal Entry History to GL Reconciliation Report. This is a comparison of the Journal Entry History (AJE) to Journal Entry postings to the GL (GJE). This report is titled "Journal Entry History to GL Reconciliation." 

  1. If you select Vendors/Vendor Employees or Both in the Include field, Costpoint performs a reconciliation of the Voucher History, including only vouchers amounts where data exists in VCHR_LAB_VEND_HS and Journal Entries that include rows in JE_TRN_LAB_VEND _HS.  These amounts are compared to the GL.  

Two reports are printed. The first is a comparison of the Voucher History (APV) to Voucher postings to the GL (GPV). The report is titled "Voucher History to GL Reconciliation." The second report to print is the Journal History to GL Reconciliation Report. This is a comparison of the Journal Entry History (AJE) to Journal Entry postings to the GL (GJE). This report is titled "Journal Entry History to GL Reconciliation."

There are no source tables for Inter-Company Work Orders (IWOs) from which to rebuild labor history. Therefore, the IWO transactions in labor history are rebuilt from the General Ledger. Because of this, the IWOs are not included in the Reconciliation of GL to Source Tables report..

Rebuild Labor History

This option is available only if:

Click this option to rebuild labor history.

If you selected Employees or Both in the Include field, data is pulled from TS_HDR_HS/TS_LN_HS and JE_HDR_HS/JE_TRN_HS/JE_TRN_LAB_EMPL_HS tables and inserted into a temp table. This data is summed and compared to LAB_HS to generate a report with the differences. In addition, if there are rows in GL_POST_SUM with the S_JNL_CD = IWO for the selected project/account/org, the system compares GL_POST_SUM/GL_DETL to LAB_HS and insert rows in to the temp table.

If you selected Vendor/Vendor Employees or Both in the Include field, data is pulled from JE_HDR_HS/JE_TRN_HS/JE_TRN_LAB_VEND_HS tables and VCHR_HDR_HS/ VCHR_LN_HS/VCHR_LAB_VEND_HS/VCHR_LN_ACCT_HS tables and inserted into a temp table. This data is summed and compared to LAB_HS to generate a report with the differences. In addition, if there are rows in GL_POST_SUM with the S_JNL_CD = IWO for the selected project/account/org, the system compares GL_POST_SUM/GL_DETL to LAB_HS and inserts rows in to the temp table.

Include

Include

Use this drop-down list to select whether to include employees or vendors/vendor employees in the processing. Valid options are:

After you have clicked or , you cannot modify your selection until the process is complete or cancelled.

Rebuild Labor History

After printing the exception report, click to rebuild labor history.