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:
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:
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.
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 |
|
||||||
Stock Code |
|
||||||
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. |
This is displayed when you select the Preferences option from the Options menu.
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. |
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 |
|
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. |
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.
|
||||||
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. 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:
|
||||||
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.
|
||||||
Tracking |
Displays lot and serial tracking information.
|
||||||
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. |
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:
|
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 |
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.
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 |
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). |
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:
Zoom (see Labor Allocations)
Labor postings (see Detailed Labor Postings for Operation)
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. |
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.
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. |
This displays details of any custom form data that has been assigned to the job (Custom Form Data Entry).
You cannot view Jobs, Material allocations and Purchase order line details for Warehouses to which you are denied access (Security Activities).
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.
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.
Right-click any form field.
You can also click the triangle menu icon that appears in the title area of a pane.
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.
Select the Close icon in the right-hand corner of the application help pane.
Confirm that you want to delete the pane.