WIP Query

Exploring

This program lets you view extensive information relating to jobs held on file.

Things you can do in this program if you are using the Requirements Planning module include:

  • Query jobs on your live data

  • Query snapshot files created by the Requirements Calculation program

View details of jobs in the MRP snapshot files by running the WIP Query program from the SYSPRO Main Menu using Ctrl + R and entering WIPPEN SNAP={JobNumber}

For example:

  • To view job number 154 in the snapshot file, you would enter WIPPEN SNAP=154.
  • To view the same job in the live files, you would enter WIPPEN LIVE=154.

This program is accessed from the Program List of the SYSPRO menu:

  • Program List > Work in Progress

If you are using the Requirements Planning module and successfully ran the Requirements Calculation program, this program can also be accessed from the following program:

  • Job Review

    From the Query Snapshot Job option from the Query function.

Within SYSPRO a job is equivalent to a works order. Against each job you record what material is required and what operations/instructions must be performed to complete/convert the raw materials into the finished product.

Starting

You restrict operator access to activities within a program using the Operator Maintenance program.

Controls whether an operator can view the following operations in the WIP Query program:

  • Run rate
  • Set-up rate
  • Start-up rate
  • Teardown rate

The operator can still view the Fixed and Variable overheads.

You can restrict operator access to programs by assigning them to groups and applying access control against the group (configured using the Operator Groups program).

You can restrict operator access to functions within a program using passwords (configured using the Password Definition program).

When defined, the password must be entered before you can access the function.

This password restricts access to deleting a job using the following programs:

  • Job Review
  • Browse on Jobs
  • WIP Query

A job cannot be deleted using the Job Entry program, as you cannot delete the job you are currently maintaining.

This is a transactional based password, which means the password is requested for each job you try to delete.

The following configuration options in SYSPRO may affect processing within this program or feature, including whether certain fields and options are accessible.

The Setup Options program lets you configure how SYSPRO behaves across all modules. These settings can affect processing within this program.

Setup Options > Configuration > Manufacturing > Bill of Materials

  • Deplete oldest rev/rel first (Component)

Setup Options > Configuration > Distribution > Inventory

  • Actual costing

Setup Options > Configuration > Manufacturing > Work in Progress

  • Work in Progress inspection required

Setup Options > Preferences > Manufacturing > Work in Progress

  • Capture job amendment journals

  • You can't view jobs, material allocations and purchase order line details for warehouses to which you are denied access.

  • You can't view details of a job if you are denied access to classification of the job.

Using

  • Columns in a listview are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the listview). Select and drag the required column to a position in the listview header.

  • Fields on a pane are sometimes removed by default. You can reinstate them using the Field Selector option from the context-sensitive menu (displayed by right-clicking any field in the pane). Select and drag the required fields onto the pane.

    The captions for fields are also sometimes hidden. You can select the Show Captions option from the context-sensitive menu to see a list of them. Click on the relevant caption to reinstate it to the form.

    If the Show Captions option is grayed out, it means no captions are hidden for that form.

  • Press Ctrl+F1 within a listview or form to view a complete list of functions available.

Referencing

All options may not be available when viewing a job from the snapshot file.

Field Description
File  
Exit

This exits the program.
Query  
Material Allocations Select this to view and maintain material allocations for the currently highlighted job.
Operation Allocations Select this 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).
Archived Jobs Select this 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 enabled the Work in Progress inspection required setup option is enabled and the job you are querying is for a made-in item defined as traceable or inspection required.
Customer

This lets you view customer details.

Select this to use the program to view details of the customer for whom the job was created.

Select this to play multimedia objects associated with the customer for whom the job was created.
Stock Code

This lets you view stock code details.

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.

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.
Job Indicate the job number you want to query.
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.
Notepad Select this to add rich format text to the job using the Admin Notepad Editor (Rich Text).
Graph Select this to use the WIP Job 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.
Field Description
Job

This displays the job number.

The hyperlink on this field is disabled for snapshot jobs.
Description This indicates the description of the job.
Job status

This indicates the current status of the job.

Archived jobs will be suffixed with (Archived) to distinguish between live and archived jobs.
Hierarchical job This indicates that the job is a hierarchical job.

Maintenance job

This indicates whether the job was for planned maintenance activities, i.e. the servicing of assets or machinery.
Has sub jobs

This indicates whether the job has sub jobs.

A link is created in the WipMaster table 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.
WIP branch This indicates the WIP branch for the job.
Current WIP branch

This indicates the WIP branch of the current operation or work center.

This applies when the Work in Progress module is integrated to the General Ledger at WIP branch level, as defined at the Apply integration level at setup option (Setup Options > General Ledger Integration > General Ledger Codes).
Quantity

 
Gross to make

Indicate the gross quantity of the parent part.

This is only available if progressive scrap is defined at operation level.
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 in the WIP Labor Posting pane 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.

Maintenance information

 

Maintenance job type

This indicates whether the maintenance job was a planned service or a breakdown.

Equipment code

This indicates the equipment code for which you want to view the planned maintenance jobs.

Maintenance service type

This indicates the type of service that was carried out on the equipment.

Equipment type

This indicates the type of equipment for which the maintenance was done.

Type of service

This indicates the type of service or maintenance that was done, e.g. plant maintenance or other asset maintenance.
Notes  

Job notes

The first three lines of the note associated with the job are displayed.

You can view or edit these notes by selecting the Click to add notes link. Once you have added a note, this link changes to Click to change or add notes.
Field 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 WIP Material Allocations - Browse and WIP Browse on 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 must run the Expected Job Cost Recalculation program.
Material (total)

This indicates the original expected material costs, which is calculated as follows when the job is created:

Material (unit) cost x Parent quantity to manufacture

Labor (total)

This indicates the original expected labor costs, which is calculated as follows when the job is created:

Labor (unit) cost x the parent quantity to manufacture

Job total

This indicates the original expected total job cost, which is calculated as follows when the job is created:

Material (total) + Labor (total)

Current expected costs

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

Under normal circumstances, the Current expected cost will be the same as the Original expected cost.

If, however, 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.
Material (total)

This indicates the current expected material costs, which is calculated as follows when the job is created:

Material (unit) cost x Parent quantity to manufacture

Labor (total)

This indicates the current expected labor costs, which is calculated as follows when the job is created:

Labor (unit) cost x the parent quantity to manufacture

Job total

This indicates the current expected total job cost, which is calculated as follows when the job is created:

Material (total) + Labor (total)

Sales order

This indicates the sales order attached to the job.

This information is only displayed if the sales order hasn't been purged. If the sales order has the status \ Cancelled but isn't purged, 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 lets you view summarized information for the sales order.

  • Query

    This lets you view detailed information for the sales order using the Sales Order Query program.

  • Order Maintenance

    This lets you maintain the sales order using the Sales Order Entry program.
Last sales order

This field only applies if multiple sales orders are linked to the same Hierarchical jobs.

This indicates the last sales order relating to the job and is derived from the WipMaster table (i.e. LstOrderCreated field).
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.
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

This displays lot and serial tracking information.
Lot tracking

Select this 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.

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 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 view details of the co-products in the job.

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

Select this to view details of job amendment journals created for the job.

This only applies when Capture job amendment journals setup option is enabled and the job is not an MRP snapshot job.

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 WIP Job Bin Query program to view material issues from bins to the job or to select the Serials option to use the WIP Job Serial Query program to view serials issued to the job.

Some of the information displayed includes the following:

Field Description
Quantity issued

This indicates the quantity that was issued to the job.

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.
Reference designator Indicate a reference to identify the component in an electrical schematic (circuit diagram) or on a printed circuit board (PCB).

This free format field usually consists of one or two letters followed by a number. Occasionally that number is then followed by a letter indicating that components are grouped or matched with each other.
Assembly place

This indicates any additional sequence or reference for the placement of the component within the assembly.

This free format field is mainly used for importing from CAD (Computer Aided Design) systems.

Item number

This indicates a number, description and/or reference of the item on the assembly drawing.

This free format field is mainly used for importing from CAD (Computer Aided Design), EPC (Electronic Parts Catalogue) or EPL (Engineering Parts List) systems.

Purchase order

This hyperlink lets you select the purchase order in order to cross-reference material transactions with the originating purchase orders.

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

Field 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

Lot

This indicates the lot number for normal kit issues or specific issues of lot traceable allocations.

This is only displayed for lots issued to a job linked to an RMA fix in-house job, if the Actual costing setup option is defined as Lot traceable.

This displays all outstanding purchase orders for the current job.

The Show completed button lets you include purchase order lines with zero quantities, i.e. completed purchase order lines.

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.

Field Description
Machine Displays the machine code entered when posting labor.
Total set-up rate

Displays the total hourly set-up rate that is calculated as:

Set-up rate + fixed overhead rate + variable overhead rate

Total start-up rate

Displays the total hourly start-up rate that is calculated as:

Start-up rate + fixed overhead rate + variable overhead rate

Total run rate

Displays the total hourly run rate that is calculated as:

Run rate + fixed overhead rate + variable overhead rate

Total teardown rate

Displays the total hourly teardown rate that is calculated as:

Teardown rate + fixed overhead rate + variable overhead rate

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

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

Tracking information reflects what is setup in the labor allocations.

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

  • Zoom (using the WIP Browse on Labor Allocations program)
  • Labor postings (using the WIP Browse on Labor Details program)

The same information is also reflected in the Job Status report.

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

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

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

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

Field 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, Job Closure, Part Billings and Transfer Work in Progress programs.

This displays details of material allocations currently allocated to the job.

The same information is displayed in the WIP Material Allocations - Browse program.

This includes the Override rev/rel column which indicates if the Override planned rev/rel in spec issue option has been selected. This is for ECC controlled stock codes when the Deplete oldest rev/rel first (Component) setup option is enabled.

This displays details of the operation allocations for the job.

The same information is displayed in the WIP Browse on Labor Allocations program.

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