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

Contents of the Rebuild Labor History Screen

Use these fields and options to configure the Rebuild Labor History screen.

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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on 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.

Note: 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.
Field Description
Option

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

  • All
  • One
  • Range
  • From Beginning
  • To End
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.

Field Description
Option

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

  • All
  • One
  • Range
  • From Beginning
  • To End
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.

Field Description
Option

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

  • All
  • One
  • Range
  • From Beginning
  • To End
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

Field Description
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

Field Description
Option

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

  • All
  • One
  • Range
  • From Beginning
  • To End
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.

Field Description
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." 

  2. 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."

Note: 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:

  • Rows exist in Z_PJPUPLAB_GL_ERR.
  • Rows exist in GL_POST_SUM with a S_JNL_CD = IWO and there are no rows within the selected project/account/org range where S_JNL_CD is %JE, RRV, or REV.

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

Field Description
Include

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

  • Employees
  • Vendors/Vendor Employees
  • Both
Note: 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.