Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Rebuild Labor History

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

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

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.