Field descriptions: Work in progress inquiry

This page describes the fields for the Work in progress inquiry page. The fields in each section are listed in alphabetical order.

Criteria block

Field Description
As of date Search for orders in progress on or after a specific date. The current date is the default date. You can select an earlier date or a later date.
From work order
To work order

The work order reference.

Enter or select the same work order reference for the From work order and To work order fields to view a summary of costs for a single work order.

Enter or select the work order references to view a summary of costs for a range of work orders.

Leave blank to view a summary of costs for all work orders.
Last run date The last time the inquiry was initiated.
Site The production site name.
Status The inquiry run status: In progress or Completed.
User The user running the inquiry.

Results grid

Field Description
Work in progress total

The cumulative total of the tracked production costs, the material costs and process costs, for the work orders in the Results grid at the selected As of date. It remains as the calculated total if you filter the list of work orders.
Field Description

Actual machine cost

Actual labour cost

Actual tool cost

The work order actual cost total for the individual resource type.

This is the total of the actual setup time cost for the resource type plus the total of the actual run time cost for the resource type.
Actual material cost

The sum of the tracked consumed component costs. This figure is from the work order component Actual cost fields.
Actual process cost

The sum of the tracked operation costs. This figure is from the work order operation Actual cost fields.

This is the total of the Actual machine cost plus the Actual labour cost plus the Actual tool cost.

You can view the total work order Actual Process cost in the work order Planned versus actual block.
Closing variance

The difference between the actual and planned work order production costs total on the work in progress inquiry date. The variance can be a positive or a negative amount and is displayed to 2 decimal places. For this figure to display, the work order needs to be closed.
Item

The work order released item name.

The released item is defined as a bill of material.
Item ID

The released item code.

Machine cost variance %

Labour cost variance %

Tool cost variance %

 The difference between the actual and planned work order resource cost totals for the resource type, as a percentage. The percentage is displayed to 2 decimal places.

Machine cost variance

Labour cost variance

Tool cost variance

The difference between the actual and planned work order resource cost totals for the individual resource type.

The variance is the Actual machine/labour/tool cost minus the Planned machine/labour/tool cost.
Material cost variance

The difference between the actual and planned work order component costs.

The variance is the Actual material cost minus the Planned material cost.
Material cost variance %

The difference between the actual and planned work order component costs, as a percentage. The percentage is displayed to 2 decimal places.

Planned machine cost

Planned labour cost

Planned tool cost

The work order planned cost total for the individual resource type.

This is the total of the expected setup time cost for the resource type plus the total of the expected run time cost for the resource type.
Planned material cost

The sum of the planned component costs. This figure is from the work order component Planned cost fields.
Planned process cost

The sum of the planned operation costs. This figure is from the work order operation Planned cost fields.

This is the total of the Planned machine cost plus the Planned labour cost plus the Planned tool cost.

You can view the total work order Planned Process cost in the work order Planned versus actual block.
Process cost variance

The difference between the actual and planned total work order operation costs.

The variance is the Actual process cost minus the Planned process cost.
Process cost variance % The difference between the actual and planned work order operation cost totals, as a percentage. The percentage is displayed to 2 decimal places.
Status

The current work order status or progress of the work order.

Pending: The work order is awaiting tracking.

In progress: One or more components, operations or released items are tracked for the work order. If the work order has been created directly from the bill of material, you might need to progress the related tracking documents that are not yet posted. You can view the list of related tracking documents and their posted status on the Trackings tab.

Completed: The work order is complete. All components, operations and released items are tracked in full. You can still edit the work order.

Closed: The work order is complete. Production has ceased and the work order is closed.
Total actual cost

The current tracked production costs total.

This is the total of the Actual material cost plus the Actual process cost.

You can view the work order Total Cost in the work order Planned versus actual block.
Total cost variance

The difference between the actual and planned work order production costs total.

The variance is the Total planned cost minus the Total actual cost.
Total cost variance % The difference between the actual and planned work order production costs total, as a percentage. The percentage is displayed to 2 decimal places.
Total planned cost

The planned production costs total.

This is the total of the Planned material cost plus the Planned process cost.

You can view the work order Total Cost in the work order Planned versus actual block.
Work in progress total

The total of the tracked production costs, the material costs and process costs, for the work order.
Work order

The work order reference and link to open the work order.