Review the following details about Cost of Work In Progress (CWIP) enquiry.
Access to CWIP Enquiry
To access Cost of Work In Progress (CWIP) Enquiry from the Jobpac Menu System select .
In addition to direct access from the menu system the CWIP Enquiry can be access from links embedded in relevant Jobpac screens for example Job Enquiry, Business Forecasting and Project Managers Worksheet. The option will be found either on the Actions menu or on a transaction level menu activated by the right mouse button.
Selecting the CWIP Enquiry from a Cost Centre based Enquiry screen as shown above will call the same CWIP enquiry screen with filters being set to the same Cost Centre that the user was working with.
CWIP Enquiry Screen
The Cost of Work In Progress (CWIP) Enquiry screen has an array of advanced filters, sort options and tabs to provide alternate views of the transactions displayed.
- Period – From period is blank and To period defaults to the current BFM Period.
- Delivery Dockets – Displayed in DS format. This stands for Docket Summary. This is the summary of all delivery dockets for a Purchase Order Item. Use the Actions option to display Docket Details, which lists each delivery docket.
- Only un-invoiced delivery dockets appear in the enquiry, as they contribute to incurred cost.
- The system can be configured to hide rate and amount for
timesheet transactions in CWIP enquiry. This is to hide possible sensitive employee
information displayed in the CWIP enquiry – rate and amount. All other information
will still display, and it only applies to timesheet transactions.
CWIPEQ Position 2 If set to ‘Y’, rate and amount will not display. Optionally only one amount per cost centre per month for timesheet transactions can be displayed in CWIP enquiry. This is displayed as a TSS record.
CWIPEQ Position 3 Show summary cost.
Actions Options for CWIP Enquiry
| Menu Option | Function |
|---|---|
| Docket Details | Toggle the display of delivery docket transactions between detail delivery dockets or a summary of delivery dockets relating to a purchase order Line Item. |
| Next Tab | Cycles through the display of the TABS – Description, Order, Invoices, Cost Centre Description. |
| Sort |
Cycles through the alternate sort sequences available:
|
| Clear Filters | Will clear all values from the advanced filters. |
| Hide Description |
Available only on the Description and Order Tabs.
|
| Download | Will download the filtered transactions with information from all tabs. |
Using the Date Filters
Users must be aware of the "limitations" and the potential adverse results with using the date filters outside the following acceptable uses.
Date filters can be used in the following circumstances:
- To filter a range of Actual Transactions by selecting CWIP type ACT.
- To filter the volume of incurred costs within a Job for a Purchase Order Line Item that have not been used since a specified date.
Using the Type Filter
Select the right arrow below the Type filter to display the Type filter selection window. Select one or many transaction types from the list by double-clicking or use the Select All / Select None options.

Generated Transaction Types
The CWIP Enquiry includes four transaction types generated by the program that do not exist as actual transactions in the database:
- Summary Transactions
- DS (Docket Summary)
- SWS (Subcontractor Work Docket Summary)
- Adjustment Transactions
- DA (Docket Adjustment)
- SWA (Subcontractor Work Docket Adjustment)
The Docket Summary records display as a “DS” Type record. They are a consolidation of all un-invoiced Delivery Dockets or docket portion for a Purchase Order item. The incurred cost for this record represents the sum total of incurred cost for that Purchase Order item. The date of the transaction will be that of the latest delivery docket for that purchase order item.
The Subcontractor Docket Summary records display as a “SWS” Type record. They are a consolidation of all unauthorised Subcontractor Work Dockets for a Subcontract line item. The date of the transaction will be that of the latest Subcontractor Work Docket in Jobpac.
In Jobpac it is possible to assign costs directly to PO items or SC items and reduce this rather than match them to dockets. When this happens the system automatically reduces the incurred cost to compensate. In this case the incurred cost will not be equal to the sum of the unmatched Delivery Dockets. The adjustment required to make the sum of the Delivery Dockets equal to the incurred cost at PO item level is represented by a “DA” type record. Here is an example.
The following Purchase order item has been enter as for 1 hour of labour at $40.00.
Delivery dockets have been recorded against this item for 39.5 hours.
An invoice has been processed directly against the purchase order for 4.0 hours total value $160.00. This invoice was not matched to the delivery docket.
The Purchase Order Item is matched to the Delivery dockets and also to the invoice but there is no link between the Invoice and the delivery dockets.

For the example Purchase Order Item shown in the diagram above the costing impact on the Job of each of these transactions is outline in the table below.
| Job Costing | |||||||
|---|---|---|---|---|---|---|---|
| Qty | Unit | Rate | Value | Committed | Incurred | Actual | |
| Purchase Order Item | 1 | Hour | 40.00 | 40.00 | 40.00 | ||
| Delivery Docket | 39.5 | Hour | 40.00 | 1,580.00 | 1,580.00 | ||
| Invoice | 4 | Hour | 40.00 | 160.00 | 160.00 | ||
Incurred Cost from un-invoiced Deliveries = $1,580
However the true value of Incurred Cost calculated at the PO Item level is:
(Total
Delivered Quantity – Total Invoiced Quantity) * PO
Ratei.e.
(39.5 - 4) * $40 = $1420 The CWIP Enquiry presents Incurred Cost as a build up from dockets and an adjustment record is calculated and presented to represent this difference between the Incurred cost calculated from dockets and the incurred cost (recognized) from the PO Item.
This has a type of DA (Docket Adjustment) = -$160
The Subcontract Work Docket Adjustment transaction is created for exactly the same reason as the DA.
Transaction Detail Drill Down Menu
| Transaction Menu | Function |
|---|---|
| Transaction Details | Displays enquiry options depending on the transaction type. |
| Period Movement | Displays the Incurred movement screen for DA, DD, DS, and Sub Contract Work Docket Types. |
| Show Information Text | Displays text entered with General Ledger Journals. |
The Transaction Details display is transaction type dependent. Where an Enquiry option is not logically linked to the selected transaction the option will be greyed.
BFM Transaction Types
The following transaction types are BFM generated:
- ACC: Accruals
- CTR: Cost Transfers
- Materials on Site
- UVT: Unrealised value of Temporary Works
If the Transaction Details submenu option is selected for one of these types you will be linked directly to the BFM screen corresponding the transaction type.