Work in Progress > WIP Query

WIP Query

You use this program to view extensive information relating to jobs held on file.

If you are using the Requirements Planning module, then you can use the WIP Query program to query jobs on your live data and to query jobs on the snapshot files created by the Requirements Calculation program.

If you are new to this query, then the following information will help you achieve the best results:

  • The information shown is always up to date (i.e. the query will reflect the latest information for jobs that have been captured or maintained).
  • If you know the job code, then you can enter it directly and press the Tab or Enter key to view the information.

    If you do not know the job code, then you can use the browse function to locate the job.

  • You can personalize this query in a number of ways. These include:

    • setting preferences that affect what information is displayed. These settings can be retained for future use
    • configuring property sheets (e.g. the section headed Job Details). This includes being able to sequence items by dragging them up or down, to show important items first
    • configuring the Material Transactions, Purchase Orders, Operation Transactions, Tracking, Work Center Summary and WIP Booked listviews. This includes being able to sequence columns by dragging them left or right, sorting columns and changing column widths
    • configuring the layout of the panes on the screen, including hiding or displaying panes

Toolbar and menu

If you are using the Requirements Planning module and you successfully ran the Requirements Calculation program, then you can access the WIP Query program and view a Snapshot Job Query by selecting the Query Snapshot Job option from the Query function of the Job Review program.

[Note]

If you are viewing a job from the snapshot files and you are running SYSPRO in a SQL environment, then not all options are available. See Note.

Field Description
Options  
Preferences Select this to configure options that will determine the level of detail you want to view within the query.
Query  
Material Allocations Select this to use the Material Allocations program to view and maintain material allocations for the currently highlighted job.
Operation Allocations Select this to use the Labor Allocations program to view and maintain operation allocations for the currently highlighted job.
Hierarchy Select this to view and maintain hierarchical details for the currently highlighted job.
Multi Level Query Select this to use the WIP Multi Level Job Query program to view all the master jobs and sub jobs within a job structure. This option is only enabled for multi level jobs (i.e. jobs with sub jobs attached).
Archived Jobs Select this to use the Browse Archived WIP Jobs program to view details of archived jobs.
WIP Inspection Select this to view information relating to WIP inspection references using the WIP Inspection Maintenance program.

This option is only available if you selected the setup option: Work in Progress inspection required (WIP Setup - General 1 tab) and the job you are querying is for a made-in item defined as traceable or inspection required (Stock Code Maintenance - Tracking tab).

Customer
Field Description
Query Select this to use the program to view details of the customer for whom the job was created.
Play Select this to play multimedia objects associated with the customer for whom the job was created.
Stock Code
Field Description
Query Select this to use the Inventory Query program to query details for the finished item required to be made. This option is only enabled for stocked items.
Play Select this to play multimedia objects associated with the stock item.
Notes  
Notes Select this to assign free-format notations to the currently highlighted job (see WIP Job Notes).
Job Indicate the job number you want to query.

You will be unable to view details of a job if you have been denied access to the job classification of the job (see Operator Maintenance - Security tab).

Play Select this to view any multimedia objects that has been assigned to the job.
Edit Select this to maintain multimedia objects for the job (see Multimedia ).
Notepad Select this to add rich format text to the job (see Notepad Editor).
Graph Select this to use the WIP Job Allocation Graph program to view a graphical representation of operations allocated to the job.
Refresh Job Select this to reload and display the latest information for the selected job.

Preferences

This is displayed when you select the Preferences option from the Options menu.

[Note]

If you are viewing a job from the snapshot files and you are running SYSPRO in a SQL environment, then not all options are available. See Note.

Field Description
View live jobs in browser Select this to indicate whether you want to view live jobs in a browser window.

By default, only archived jobs can be viewed in a browser window.

Include purchase orders with zero quantities Select this to include purchase order lines with zero quantities in the query (i.e. completed purchase order lines).
Save Preferences Select this to save your selections against your operator code.
Close Select this to save your selections for the current run of the program only.

Job Details

Column Description
Has sub jobs

This indicates whether the job has sub jobs.

A link is created in the WIP Job Master table/file from all sub jobs to the master job and from each sub job to its immediate parent job, irrespective of whether the master job is an hierarchical job.

This link can be placed on the form using the Field Selector and selecting the Hierarchy Job field from the WIP Job Master fields.

Quantity
  • Net to make

    This is the original job quantity including any scrap. This is never reduced by the manufactured quantity.

  • Manufactured

    This is the quantity already manufactured against the job.

  • Scrapped

    This is the scrap quantity posted during the actual manufacture of the job (i.e. it is the quantity entered at the Total quantity scrapped field on the WIP Labor Posting Values screen of the Labor Posting program).

    The scrap quantity entered during inspection using the WIP Inspection Maintenance program does not update the job header. This allows for differentiation between scrap that is in process and scrap that is in inspection.

Notes

Job notes

The first three lines associated with the notes associated with the job are displayed. You can view/edit these notes by selecting the first line of the notes.

Additional Information

Column Description
Original expected cost

These are the original expected costs calculated when the job is created and are not changed when you maintain labor and material costs using the Material Allocations and Labor Allocations programs.

Expected job costs are not automatically updated when a job quantity is changed using the Job Entry program. This is deliberate as you may choose to retain these costs for comparison purposed. To update the current expected costs (or original costs) you need to run the Expected Job Cost Recalculation program.

  • Material (total)

    Calculated as the Material (unit) cost multiplied by the parent quantity to manufacture.

  • Labor (total)

    Calculated as the Labor (unit) cost multiplied by the parent quantity to manufacture.

  • Job total

    Calculated as Material (total) plus Labor (total).

Current expected costs

These are the current job costs calculated by the Expected Job Cost Recalculation program.

  • Material (total)

    Calculated as the Material (unit) cost multiplied by the parent quantity to manufacture.

  • Labor (total)

    Calculated as the Labor (unit) cost multiplied by the parent quantity to manufacture.

  • Job total

    Calculated as Material (total) plus Labor (total).

Under normal circumstances, the Current expected cost will be the same as the Original expected cost. However, if the cost of an item has changed since the job was created or allocations were added or over issued, then the Current and Expected costs will differ.

Sales order

This indicates the sales order attached to the job.

This information is only displayed if the Sales Order has not been purged. If the sales order was cancelled (status '\'), but not purged, then the sales order information is still on file and will be displayed here.

You can select this field to display the following:

  • Sales Order Quick View - this enables you to view summarized information for the sales order.
  • Query - this enables you to use the Sales Order Query program to view detailed information for the sales order.
  • Order Maintenance - this enables you to use the Sales Order Entry program to maintain the sales order.
Unit selling price When a job is created from a sales order, the selling price is taken from the sales order. However, the job's selling price is not updated when the sales order is subsequently maintained and the price is changed.
Reserved lots Select this to use the Reserved Lots for Job program to view information on the lot numbers reserved for the job.
Reserved serials Select this to use the Reserved Serials for Job program to view information on the serial numbers reserved for the job.
Capex

This information is only displayed if the job was created from the Asset Capex Items program for a capex item requisition line.

  • Asset

    This indicates the capex asset code of the requisition line number for which the job was created.

  • Req line no

    This indicates the capex requisition line number for which the job was created.

Tracking

Displays lot and serial tracking information.

Field Description
Lot tracking Select this to use the Track Component Lots and Serials to Parent program to trace which component lot numbers were used to produce a particular parent lot. This option is only enabled if the allocations for the job you are querying are lot traceable and were issued to the job.
Serial tracking Select this to use the Track Component Lots and Serials to Parent program to trace which component serial numbers were used to produce a particular parent lot. This option is only enabled if the allocations for the job you are querying are serialized and were issued to the job.
Co-products

Select this to use the WIP Co-products for Job program to view details of the co-products in the job.

This only applies when the querying a job for a notional part.

Material Transactions

This displays details of transactions posted against the materials allocated to the job.

You can click on a line within the listview to select the Bins option to use the Bin Query for Material Issues program to view material issues from bins to the job or to select the Serials option to use the Serial Query for Material Issues program to view serials issued to the job.

Column Description
Quantity issued

The following applies when a phantom part is set to use a fixed parent quantity:

  • If the top level phantom is fixed and there is a fixed parent quantity then, provided no other level is fixed, the fixed parent quantity is applied against the component.

  • If the component has a fixed parent quantity then provided none of the higher levels are fixed and there is no factorization (i.e. the quantity per calculated from higher levels = 1) then the component's fixed quantity is used.

  • In all other instances the total quantity required is calculated and the fixed parent quantity is set to zero.

Material Transaction Details

The information displayed in this pane relates to the line currently highlighted in the Material Transactions listview.

Column Description
Quantity issued

This indicates the material quantity issued for the component.

If progressive scrap is defined at operation level, then the material quantity issued is calculated as:

Job quantity / (1 - Scrap%) * Qty per of the component attached to the operation

Purchase Orders

This displays all outstanding purchase orders for the current job.

From the Options menu you can indicate whether you want to include purchase order lines with zero quantities.

Operation Transactions

This displays details of all transactions posted against the operations of the job.

Transactions include unplanned work, extra-ordinary work, rework, etc., performed against the job. The transactions are read from the WIPPST file, which reflects what actually happened.

See Activity considerations in Notes and warnings.

Column Description
Machine Displays the machine code entered when posting labor.
Total set-up rate Displays the total hourly set-up rate, calculated as:

set-up rate + fixed overhead rate + variable overhead rate

Total start-up rate Displays the total hourly start-up rate, calculated as:

tart-up rate + fixed overhead rate + variable overhead rate

Total run rate Displays the total hourly run rate, calculated as:

run rate + fixed overhead rate + variable overhead rate

Total teardown rate

Displays the total hourly teardown rate, calculated as:

teardown rate + fixed overhead rate + variable overhead rate

Ops Transaction Details

This information relates to the line currently highlighted in the Operation Transactions listview.

Column Description
Rates No values are displayed in the rate fields if you have are denied access to the activity: WIP Allow view of labor rates (Security Activities).

Tracking

This displays allocated operation details for the current job. This indicates planned work performance.

Tracking information is read from the WIPLAL file, which are the Labor Allocations, so reflects what is setup in the labor allocations.

This is the same information as is reflected in the Job Status report.

You can select the following options by right clicking on a line:

Column Description
Machine

This displays the machine code captured against the labor allocation and not the machine code entered when posting labor.

The machine code entered when posting labor is displayed on the Operation Transactions tab.

Tracking Details

This information relates to the line currently highlighted in the Tracking listview.

Work Center Summary

This displays a summary of the time and value required and issued against each work center used for the job.

WIP Booked

This displays details of the work in progress completed for the job to date.

Column Description
Labor value When using standard costing, this value could be negative, because when a job is receipted from Work in Progress, the system calculates the material cost from the Bill of Materials and then deducts this cost from the standard cost. The balance of the cost is assumed to be labor.

If the material value consumes the whole standard cost, then the remainder of the BOM cost, which is what is allocated to labor, is therefore negative.

Additional reference This displays the Additional reference text entered when using the Job Receipts, WIP Job Closure, Part Billings and Transfer Work in Progress programs.

Custom Form

This displays details of any custom form data that has been assigned to the job (Custom Form Data Entry).

Notes and warnings

Restrictions and limits

  • You cannot view Jobs, Material allocations and Purchase order line details for Warehouses to which you are denied access (Security Activities).

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operator Maintenance program.

Activity Description
WIP Allow view of labor rates

Controls whether an operator can view the operation Run rate, Set-up rate, Start-up rate and Teardown rate in the WIP Query program.

The operator can still view the Fixed and Variable overheads.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.