Skip to main content

Subcontract Labor Reconciliation

Written by Denisa Arjoca
Updated over 2 weeks ago

The Subcontract Labor Reconciliation function in Job Status allows Labor and Equipment charges to be added within the function.

This section describes in detail how Job Status allows for the addition of these charges.


Configuration

The two JC parameters listed below accommodate the Subcontract Labor Reconciliation 11.06 changes.

Parameter

Description

JC/CDRTSAP

Subcontract Labor Reconciliation: masked list of users to ignore timesheet approval process

JC/CDRTSAC

List of Timesheet Activities available for entry on Subcontract Labor Reconciliation


Subcontract Labor Reconciliation

Add Labor Tab

The Add Labor tab (see Add Labor Tab) in the JC Subcontract Labor Reconciliation function allows quick entry data for creating and posting JC Timesheets. It also lets you perform maintenance of JC Timesheet data to be posted and reconciled later.

Add Labor Tab

Labor records can be created only with Timesheet Activities listed on the JC/CDRTSAC parameter. In addition, they can only be created for Employees who are linked to a Supplier on the Reconciliation Invoice record.

Once a record has been saved, you can use either of these actions:

  • Create Timesheets - to create and post JC Timesheets that can be reconciled later on the Labor Details tab; or

  • Create and Reconcile Timesheets - to create, post, and reconcile JC Timesheets to the current Reconciliation Invoice record.

A record can be updated/deleted before applying the Create Timesheets or Create and Reconcile Timesheets action.

Create Timesheets

The Create Timesheets action is found at the bottom of the Add Labor tab (see Create Timesheets Action) after you save a transaction. However, it is only available for users listed on the JC/CDRTSAP parameter (that is, the masked list of users who can approve and post JC Timesheets from the Subcontract Reconciliation screen).

Create Timesheets Action

When this action is run, it does the following:

  • Creates JC Timesheets based on selected labor records

  • Applies necessary checks

  • Creates a separate JC Timesheet Batch

  • Adds newly created timesheets to the Batch and then posts the Batch

Once the action is successfully applied, a new posted Timesheet is available on the Labor Details tab for further reconciliation.

Create and Reconcile Timesheets

Newly created and posted JC Timesheets are reconciled with the current Reconciliation Invoice by using the Create and Reconcile Timesheets action. This action can be processed after you save the transaction on the Add Labor tab. It is available for users listed on the JC/CDRTSAP parameter (that is, the masked list of users who can approve and post JC Timesheets from the Subcontract Reconciliation screen).

When this action is run, it does the following:

  • Creates JC Timesheets based on selected labor records

  • Revalidates details

  • Creates a separate JC Timesheet Batch and includes newly created timesheets in the Batch

  • Posts the Batch and reconciles all newly created and posted Timesheets with the current Reconciliation Invoice

Once successfully applied, a new posted Timesheet is available on the Labor Details tab as reconciled with this invoice.

Unreconciled Labor Tab

An Unreconciled Labor tab (see Unreconciled Labor Tab) on the Subcontract Labor Reconciliation function displays only unreconciled records. Some of the additional columns included on this screen are:

  • Crew Code.

  • Foreman Name.

  • CDR Reference.

All actions/calculations/checks of the original Labor Details tab are available on this tab.

Unreconciled Labor Tab

Add Equipment Tab

The Add Equipment tab (see Add Equipment Tab) is found on Subcontract Labor Reconciliation. It allows for quick entry data for creating and posting EQ Charges. It also lets you perform maintenance of EQ Charges data to be posted and reconciled later.

Add Equipment Tab

Once a record has been saved, you can use either of these actions:

  • Create Equipment Charges - to create and post EQ Charges that can later be reconciled on the Equipment Detail tab; or

  • Create and Reconcile EQ Charges - to create, post, and reconcile EQ Charges to the current Reconciliation Invoice record.

Equipment records are created only for Assets with a Supplier code on the Reconciliation Invoice record.

A record can be updated/deleted before applying the Create Equipment Charges or Create and Reconcile EQ Charges action.

Create Equipment Charges

The Create Equipment Charges action is found at the bottom of the Add Equipment tab (see Create Equipment Charges) after you save a transaction. It can be processed after you save a transaction on the Add Equipment tab.

Create Equipment Charges

When this action is run, it does the following:

  • Creates EQ Charges based on selected equipment records

  • Applies necessary checks

  • Creates a separate EQ Charge Batch

  • Includes newly created EQ Charges for this Batch and posts the Batch

The value of this option on the Extras tab of the SL Statements Print forms is analyzed; if checked, invoices with zero balances are printed.

Once successfully applied, new posted EQ Charges are available on the Equipment Details tab as reconciled with this invoice.

Create and Reconcile EQ Charges

Newly created and posted EQ Charges are reconciled with the current Reconciliation Invoice by using the Create and Reconcile EQ Charges action. This action can be processed after you save the transaction on the Add Equipment tab.

When this action is run, it does the following:

  • Creates EQ Charges for this Batch and posts the Batch

  • Reconciles all newly created and posted EQ Charges with the current Reconciliation Invoice

Once successfully applied, new posted EQ Charges are available on the Equipment Details tab as reconciled with this invoice.

Unreconciled Equipment

The Unreconciled Equipment tab (see Unreconciled Equipment Tab) on Subcontract Labor Reconciliation displays only unreconciled records. Some of the additional columns included on this screen are:

  • Crew Code

  • Foreman Name

  • CDR Reference

All actions/calculations/checks of the original Equipment Details tab are available on this tab.

Unreconciled Equipment Tab


JC CDR Approval

The CDR Approval process lets you save a link to the original CDR record on JC Timesheets and EQ Charges.

Did this answer your question?