Job Watcher 2.0 – Current Version 20190911-2

Job Watcher 2.0 is a full featured, one-stop-shop dashboard for work orders. Finally, a work order dashboard that allows seamless, Lightning fast, configurable, resolution responsive access to all of your Work Orders – in a SINGLE SCREEN! No longer hunt for the data you need.

Speed and Fluent Access of Data, with a user friendly screen was the main goal in development, and will continue to be the goal in future updates/improvements.

Serialization – Upon closing/refreshing the screen – all column layout, grouping, filtering, hide/show, sizes will all be retained for the logged in user – and automatically assigned when the user reopens the application. Details grid does not serialize as it is generated from the Operations grid with each use.

Close Jobs & Operations – Seamlessly Close Jobs, or even operations with just one click.

Drill Down – Hyperlinks to Work Orders, Supply and Demand, Sales Orders, and more.

Editable Fields – Several editable fields that can be changed right in the grid.

Visualizing Reversed/Deleted Detail Records – From the details grid, all records that have been reversed/deleted will show with the strike through – giving a clear visual aid.

Sequential, Limitless, Traceable Notes – Sequential notes with NO CHARACTER LIMITS. Easily track who, and when the notes were created.

External CORE Program Functions – Launch any of the below programs, right from the same screen – with just one click.

  • WIP to FG
  • Reverse WIP to FG
  • WIP to WIP
  • Reverse WIP to WIP
  • Issue Material
  • Reverse Issue Material
  • Print Barcoded Work Order
  • Modify Work Order
  • Create Work Order
  • Hold Work Order
  • PO Receipts

Resolution Responsive Screen Design – Entire application is re-sizable, and responsive to your screen size.

Fast, Easy Export to Excel – 2 Click Export to Excel, and Automatically Open.

Fully Adopts, and Embraces GAB.Net Functionality

  • Filtering
  • Grouping
  • Sorting
  • Full Grid Searching

***Red Columns with an * are Editable when in Read/Write Mode***

  • Status (“Open” or “Closed”)
  • Work Order
  • Link (Document Control)
  • Part
  • Loc (Location)
  • Description
  • Extra Description (Inventory)
  • PL (Product Line)
  • * Pri (Priority)
  • Customer
  • Customer Name
  • City
  • State
  • Ship To
  • * Customer PO
  • Customer Part
  • * Qty Ordered
  • * Qty Customer
  • Qty Completed
  • Qty Remaining
  • Order Date
  • Start Date
  • * Due Date
  • Closed Date
  • Started (indicates if anything has been done including labor, material, or overhead)
  • Labor Started (indicates if any labor value has been assigned)
  • Current WIP (indicates if the job is currently in progress in a GUI – someone is punched in.)
  • Days Late
  • Sales (Not Shown in Read Only)
  • Material Cost (Not Shown in Read Only)
  • Labor Cost (Not Shown in Read Only)
  • Overhead Cost (Not Shown in Read Only)
  • Outside Cost (Not Shown in Read Only)
  • Other Cost (Not Shown in Read Only)
  • Freight Cost (Not Shown in Read Only)
  • Total Cost (Not Shown in Read Only)
  • Cost Transferred (Not Shown in Read Only)
  • * Comments 1
  • * Comments 2
  • * Comments 3
  • * Sort Code
  • * Sort Code 2
  • * Job Header User Fields 1-10. These fields will honor the titles configured in company options.
  • Inventory Sort
  • Parent WO (Parent Work Order)
  • Sales Order
  • Line (Sales Order Line)
  • Project
  • Phase
  • * Lock (Job Locked)
  • Note Count
  • * Notes
  • * Schedule (Backward Schedule Job)
  • * Close (Close Work Order)
  • Hold WO (check box)
  • Shipped Date
  • Shipped Qty

***Red Columns with an * are Editable when in Read/Write Mode***

  • Seq (Sequence)
  • LMO (Labor/Material/Outside)
  • Part/WC (Part/Workcenter/Outside Code)
  • Op Code (Operation)
  • Description
  • Est Qty
  • Act Qty
  • Scrap Qty
  • Quantity On Hand
  • Setup Hrs
  • Runtime
  • Est Hrs/Mat’l (Estimated Hours/Material Qty)
  • Act Hrs/Mat’l (Actual Hours/Material Qty)
  • UM (Unit of Measure)
  • Est Cost (Not Shown in Read Only)
  • Act Cost (Not Shown in Read Only)
  • Start Date
  • Due Date
  • Close Date
  • Sort Code
  • * Project Group
  • * Closed
  • * Notes

***Red Columns with an * are Editable when in Read/Write Mode***

  • Part/WC (Part/Workcenter)
  • Description
  • Charge Date
  • Actual Date
  • Seq Key
  • Emp #
  • Emp Name
  • Hours/Pieces
  • UM (Unit of Measure)
  • Scrap Qty
  • Good Qty
  • FG Qty (Qty Transfered to Finished Goods)
  • Mult
  • Edit (Edited WO Detail)
  • Start (Start Time)
  • End (End Time)
  • Shift
  • Dept
  • Group
  • * Closed
  • * Notes
  • * Edit

Custom Options can be added by inserting the records into the OYB_OPTIONS table, using the FREE Options Manager for Own Your BI Projects.
***OYB_OPTIONS.OPT_APP Always “JW2″***

Granular Security – This option allows for access to the functions (WIP to FG, Issue Material, Etc) to be based on the user’s menu access. The standard Job Watcher 2.0 Application is all or nothing – based on whether or not the user is in the JWRW Security Group.

  • Option Name= “GRANULAR_FUNCTIONS”
  • Option Value= “Y”

Locked Sort Code(s) – This option allows for disabling the edit of the Work Order Header Sort Code, and Sort Code 2 fields. This is primarily useful, when these fields are controlled by business process, to store a critical field.

  • Option Name= “LOCK_SORTCODE”
  • Option Value= “Y”

Disallow Notes Delete – This option allows for disabling the ability to delete notes from Job Watcher.

  • Option Name= “NO_DELETE_NOTES”
  • Option Value= “Y”

Resize Factor Override – This option relates to the Collapse/Expand Button (“<<<<<>>>>>”). The standard Job Watcher 2.0 Application, when using this button, will adjust the Job Watcher Grids based on a 33% (of entire window) factor. This option allows that 33% factor to be overridden company wide.

  • Option Name= “RESIZE_FACTOR_OVERRIDE”
  • Option Value= “.5” (Decimal Percentage Value)

Show First WC – This option shows an additional field “First WC” in the Job Header grid, displaying the workcenter from the first labor operation on the selected work order.

  • Option Name= “SHOW_FIRST_WC”
  • Option Value = “Y”

Show Part Pic – This option allows for previewing a picture of a part, when clicking in the Jobs Grid. Required Hotfix version 20170719.2 or later. Pictures need to be saved in a single directory. The file name should be the part number (including Rev) without any spaces. The supported file types are .jpg and .png.

  • Option Name= “SHOW_PART_PIC”
  • Option Value= Fully Qualified UNC path, without ending , to the pictures path

Edit Work Order Detail – This option enables an “Edit” button in the details grid, allowing the user to click, and open up the Edit Work Order Detail program, with the selected Employee/Date. Read/Write is required, even with the option enabled.

  • Option Name= “EDIT_WO_DETAIL”
  • Option Value= “Y”

Edit Sales Order Permissions – This option uses the Sales Order Hyperlink in the Jobs grid to edit the Sales Order Permissions.

  • Option Name=”EDIT_SO”
  • Option Value=”Y”

Print PDF – This option adds a column button “Print” to the Jobs Grid. When clicked, it will imitate right clicking on a PDF of the part and clicking print in the context menu. PDF’s must be stored as the part number.pdf with all the spaces removed, and the part must include the rev.

  • Option Name=”PRINT_PDF”
  • Option Value=Path to the PDF directory

Disable Export Button – This option disables the export button on the main screen bottom left.

  • Option Name=”DISABLE_EXPORT”
  • Option Value=”Y”

Show First Material Part Number – This option shows the first material part number from the Job in the Header Grid. This includes a hyperlink to Supply and Demand when double clicked.

  • Option Name=”SHOW_FIRST_MATERIAL”
  • Option Value=”Y”

Print Custom Report ID – This option allows printing of a custom report id when clicking the “Print WO” function button (not the print button). Parameters passed to the report will be “Job” and “Suffix” and must match within the Crystal Report.

  • Option Name=”CUSTOM_PRINT”
  • Option Value=Report ID

View PDF – This option is identical to the “PRINT_PDF” option, except the PRINT_PDF option prints directly to the printer. This option will open the PDF for viewing.

  • Option Name=”VIEW_PDF”
  • Option Value= Path to Directory of the PDFs (PDFs must be saved as the part number, less any spaces.)

Hide Reversed Detail – This option suppresses the Job Detail records that have been reversed – rather than showing them as a strike-through.

  • Option Name=”HIDE_REVERSED_DETAIL”
  • Option Value=”Y”

Allow modification of Part/WC/Outside Op – This option will allow the modification of the Part/WC/Outside Op in the Operations Grid when the user is in Read/Write mode. When changed the user will be prompted if they want to re-backward schedule the Job.

  • Option Name=”CHANGE_PARTWC”
  • Option Value=”Y”

BOM Completion – This option will show the percentage of completion through a BOM Work Order series bases on Suffixes Closed / Total Suffixes

  • Option Name=”BOM_COMPLETION”
  • Option Value=”Y”

WO Completion – This option will show the percentage of completion of a Work Order based on Operations Closed / Total Operations (not including Misc/Rework)

  • Option Name=”WO_COMPLETION”
  • Option Value=”Y”

Total Scrap Column – This option will show the total scrap from Operations of a Work Order.

  • Option Name=”SHOW_TOTAL_SCRAP”
  • Option Value=”Y”

Fix Description Left – Added Custom Option for making the description column fixed to the left.

  • Option Name= ‘FIX_DESC_LEFT’
  • Option Value = ‘Y’

First Open WC – Added Show First Open WC Option

  • Option Name= ‘SHOW_FIRST_OPEN_WC’
  • Option Value= ‘Y’

Last Closed WC – Added Last Closed WC Option

  • Option Name= ‘SHOW_LAST_CLOSED_WC’
  • Option Value= ‘Y’

Total Material Issued – Added Total Material Issued Option – Totals all materials issued (total quantity) on the entire job, regardless of sequences (ideal for companies with a single material line per job.)

  • Option Name= ‘TOTAL_MATERIAL_ISSUED’
  • Option Value= ‘Y’

Currency Format – Added option for Currency custom format mask

  • Option Name= ‘CURRENCY_FORMAT’
  • Option Value= FORMAT MASK

Integer Format – Added option for Integer custom format mask

  • Option Name= ‘INTEGER_FORMAT’
  • Option Value= FORMAT MASK

Decimal Format – Added option for Decimal custom format mask

  • Option Name = ‘DECIMAL_FORMAT’
  • Option Value= FORMAT MASK

Quantity Format – Added option for Quantity custom format mask

  • Option Name= ‘QUANTITY_FORMAT’
  • Option Value= FORMAT MASK

Parts through Primary Operation – Added Parts Through Primary Option

  • Option Name= “PARTS_THROUGH_PRIMARY”
  • Option Value= OP CODE OF PRIMARY OP CODE

Disable Close Jobs – Removes the “Close” button in the Jobs grid.

  • Option Name= “DISABLE_CLOSE_JOBS”
  • Option Value= “Y”

Total Hours Column Option This option allows you to add a column to the main Jobs grid, showing the total labor hours required by the job.

  • Option Name: SHOW_TOTAL_HOURS
  • Option Value: Y

Hours by Department Option This option allows you to add a column to the main Jobs grid, showing a total of hours, for a specific department. The cool feature with this option – is you can create MULTIPLE of the same option – one for each department you want to add a column for.

  • Option Name: HOURS_BY_DEPT
  • Option Value: Department ID you want to total.

Shortage option This option adds a column to the main grid that shows the shortage in inventory. The shortage is calculated as on hand, minus all of the current requirements in the system. It does NOT consider open orders where the net is being increased (open POs/Jobs to receive).

  • Option Name: SHORTAGE
  • Option Value: Y

Show MRP Quantities This option will add the Inventroy Quantity fields (On Hand, On Order PO, On Order WO, Required, etc) to the main grid.

  • Option Name = “SHOW_MRP_QTYS”
  • Option Value = “Y”

Show ABC Code This option will add an “ABC” column which shows the ABC Code from inventory.

  • Option Name = “SHOW_ABC”
  • Option Value = “Y”

Show Total Actual Hours This option will show the Total Actual Hours on the Job.

  • Option Name = “SHOW_TOTAL_ACK_HOURS”
  • Option Value = “Y”

Show 4169 Notes This option will show the Notes field from the Master Schedule Dashboard.

  • Option Name = “SHOW_4169_NOTES”
  • Option Value = “Y”

Fixed broken CallWrapper for Supply and Demand from the operations grid.Fixed broken CallWrapper for Supply and Demand from the operations grid.7/13/2017 – Brian Lefler

  • Added “Started” Column to Jobs Grid. This is an indicator of whether or not any charges have been posted to the Job.
  • Changes to Granular Security – to fix flaw with “Print” function.
  • Combined Sales Order and Line into one column

7/14/2017 – Brian Lefler

  • Modify WO button now launches the WO Maintenance Screen to the specific WO selected. If no work order is selected, – it opens the Modify WO screen for user input.
  • Print WO button now prints the Barcoded WO Extended Report for the specific WO selected (screenless). If no work order is selected, – it opens the Print Barcoded WO Report screen for user input.

7/18/2017 – Brian Lefler

  • Added Columns “City” and “State” to the Header Grid. These are populated from the Customer Master Assigned to the Job.
  • Added Column “First WC” (See Custom Option SHOW_FIRST_WC)
  • Added Columns “Customer Qty”, and “Salesperson” from the Job Header

7/19/2017 – Brian Lefler

  • Added Custom Option for “Show Part Pic” that allows for previewing a thumbnail picture of a part, when hovering the part number column, in the Jobs Grid. Required Hotfix version 20170719.2 or later.

7/21/2017 – Brian Lefler

  • Added the Extra Text from Inventory – to the Job Header grid

7/22/2017 – Brian Lefler

  • Added custom option to allow user to click “Edit” from Details grid, and launch the Edit WO Detail screen for the selected detail Date/Employee.

7/23/2017 – Brian Lefler

  • Fixed issue with Sales Order hyperlink opening the wrong order, or no order.

7/26/2017 – Brian Lefler

  • Added custom option to allow users to edit their Sales Order Permissions using the Sales Order Hyperlink.

7/27/2017 – Brian Lefler

  • Fixed issue where columns were unable to be resized.

8/3/2017 – Brian Lefler

  • Added functionality to fix errors in versions pre-216.2 due to Inventory Extra Description table differences.
  • Added “Print PDF” option. Custom option that adds “Print” button to the Jobs grid.
  • Changed the way the SHOW_PART_PIC custom option works, instead of hovering it now has a button labeled “Pic” to click to view the picture.
  • Added “Hold” checkbox (read/write) that controls the “Work Oder on Hold” in Job Header.
  • Removed the Minimum Width Restrictions so columns can be made smaller.
  • Added date/version to the caption of the program so it can be identified.

8/8/2017 – Brian Lefler

  • Removed max width limitation on the Salesperson column.
  • Removed Serialization of the Details Grid to fix random disappearing of the detail columns.
  • Added functionality to serialize the grid, prior to loading with data to alleviate the delay in some cases of the initial opening of the grid.

8/18/2017 – Brian Lefler

  • Fixed issue where customer’s bill to city and state were used instead of the ship to city and state.

8/30/2017 – Brian Lefler

  • Added standard column ‘zip code’ to the header grid to accompany the ‘ship to’ information.

9/6/2017 – Brian Lefler

  • Fixed broken CallWrapper for Supply and Demand from the operations grid.

9/18/2017 – Brian Lefler

  • Added Shipped Date and Shipped Qty from Invoice History to the Header Grid. This requires that the job was generated directly from the sales order.

9/18/2017 – Brian Lefler

  • Added Custom Option to disable the export button on the main screen in the bottom left.
  • Added Custom Option to show the first material part number from the Job in the header grid. This includes hyperlink to Supply and Demand when double clicked.
  • Added Custom Option to print a custom report id, when clicking the “Print WO” function button (not the print pfd button). Parameters passed to the report will be “Job” and “Suffix” and must match within the Crystal Report.
  • Added Custom Option to View PDF. This is identical to the “PRINT_PDF” option, except the PRINT_PDF option prints directly to the printer. This option will open the PDF for viewing.
  • Added some code cleanup to make modifications easier in the future – and hopefully increase the speed on the load/refresh. This was mostly for internal purposes.

9/24/2017 – Brian Lefler

  • Changed the newly added “Ship Date” and “Ship Qty” columns to pull from Shipments instead of Invoices, since the Invoiced Jobs don’t show in the Job Watcher (Closed).

9/26/2017 – Brian Lefler

  • Added Custom Option to hide job details that have been reversed rather than showing them with a strike-through.
  • Added Custom Option to allow modification of the Part/WC/Outside Op in the Operations Grid – when the user is in Read/Write mode. When changed the user will be prompted if they want to re-backward schedule the job.

11/23/2017 – Brian Lefler

  • Added “Project Group” column to the Operations Grid. This is read/write-able.

2/25/2018 – Brian Lefler

  • Added “Total Scrap” column to Job Header grid that shows the total quantity of scrap from the operations
  • Changed the resizing of the two grids on the right (operations and detail) to resize the operations grid, instead of the details grid – to allow for easier visibility of the larger routers.

2/25/2018 – Brian Lefler

  • Modified the recently added “BOM_COMPLETION” custom option to calculate completion based on Closed Suffixes / Count of Suffixes
  • Added a new custom option “WO_COMPLETION” that will calculate percentage complete based on Closed Sequences / Count of Sequences.

3/3/2018 – Brian Lefler

  • A new update has been made to Job Watcher 2.0. The “QTY SCRAPPED” column that was added last week has caused a slowness in environments with a large amounts of work orders. For this reason – this column has been removed, and added back as a custom option.

3/29/2018 – Brian Lefler

  • Added “Schedule” column in Header grid that will re-backward schedule the selected work order. This only applies to the JWRW security group.

6/8/2018 – Brian Lefler

  • Fixed security issues where when in read only mode, some columns are still highlighted in yellow, and some buttons are still visible. However, these were NOT editable, they gave the impression they were.
  • Changed buttons at bottom of screen to be hidden if the user doesn’t have access, instead of just locked.
  • Added “Show/Hide” button to show/hide the details and operations grids allowing for the jobs grid to be shown full screen.
  • Added Custom Option for making the description column fixed to the left.
  • Added Show First Open WC Option
  • Added Last Closed WC Option
  • Added Total Material Issued Option – Totals all materials issued (total quantity) on the entire job, regardless of sequences (ideal for companies with a single material line per job.)
  • Added option for Currency custom format mask
  • Added option for Integer custom format mask
  • Added option for Decimal custom format mask
  • Added option for Quantity custom format mask

06/08/2018 – Brian Lefler

  • Added Selected Job Sensitivity to the “WIP to FG” button. This will make the “WIP to FG” button launch specifically to the work order that is selected. I am still working with GSS to get the functionality we need, to be able to make all of the other buttons launch job specific.

06/08/2018 – Brian Lefler

  • Resolved an error some RW users were getting when launching JW after the update this morning.
  • Added Selected Job Sensitivity to the “WIP to FG” button. This will make the “WIP to FG” button launch specifically to the work order that is selected. I am still working with GSS to get the functionality we need, to be able to make all of the other buttons launch job specific.

06/12/2018 – Brian Lefler

  • Added Parts Through Primary Option
  • Fix to Quantity columns showing as dollars, if no custom quantity format was specified

09/08/2018 – Brian Lefler

  • Customer Qty Field Made Editable

09/20/2018 – Brian Lefler

  • Added ability to show closed work orders.
  • Added Closed Date Column
  • Added Status Column (“Open” or “Closed”)

10/10/2018 – Brian Lefler

  • Changed Inventory Extra Text Lookup to speed up dashboard
  • Fixed bug with currency formatting in header grid
  • Added Note Count column
  • Added “On Hand” Column to Job Operations grid, for Materials

11/15/2018 – Brian Lefler

  • Added custom option for disabling the close job feature.

12/28/2018 – Brian Lefler

  • Fixed a bug in the Details grid (bottom right) on sequence 999999 (WIP to FG Transaction) that always showed 0 in the completed quantity, instead of showing the actual quantity that was transferred.

02/07/2019 – Brian Lefler

  • Added “Days Late” column to header grid. This will calculate as the days between the due date, and the closed date. For any open work orders, this column will show 0.

02/19/2019 – Brian Lefler

  • Added Column for “Labor Started”. The existing “Started” flag indicates if anything has been done (like issuing material) regardless if labor has been applied. This flag is specific to any labor being recorded.
  • Added Column for “Current WIP”. This column will show if the job is currently in process on the shop floor (at time of loading/refreshing Job Watcher.).

06/02/2019 – Brian Lefler

  • Add Total Hours Column Option (SHOW_TOTAL_HOURS) This option allows you to add a column to the main Jobs grid, showing the total labor hours required by the job.
  • Added Hours by Department Option. (HOURS_BY_DEPT) This option allows you to add a column to the main Jobs grid, showing a total of hours, for a specific department. The cool feature with this option – is you can create MULTIPLE of the same option – one for each department you want to add a column for.
  • Added Summaries to main grid. All numeric columns in the main grid show a grand total and the bottom of the grid.
  • Custom Options & Closed Jobs. There are some custom options that were not properly accommodating the closed jobs feature. They have been updated.
  • Part Picture rebuild Previously, the “Part Picture” option would add a “Pic” button in the grid that would launch the image in your picture viewer. Now, if the picture option is turned on – each time you click a row in the main grid, the part image will load in the lower right, where the details grid is. Don’t worry about losing the detail view. The moment you click on an operation in the upper right, the picture hides, and the details show. To get the picture to show again – just click a record in the main Jobs grid.
  • Added “Shortage” option. (SHORTAGE). This option adds a column to the main grid that shows the shortage in inventory. The shortage is calculated as on hand, minus all of the current requirements in the system. It does NOT consider open orders where the net is being increased (open POs/Jobs to receive).
  • Added “Save Serializations” feature.The serializations functionality by default – is when Global Shop gridviews remember the user’s selections, filters, sorts, and grouping. This new feature allows for people to save templates, including the administrators being able to save “Master” templates. Users will be able to save templates, and delete templates. The save/delete for normal users ONLY impacts those users. They will be able to load in their user specific templates, or the master templates. Any users in the Security Group “JWTMPMST” (Job Watcher Template Master) will be able to save templates as “Masters” and also delete the Master Templates. This will allow users to pre-configure templates/filters/sorts, and load them in on command – allowing them to maintain a list of many layouts, instead of just the last one they used.

06/18/2019 – Brian Lefler

  • Fixed bug with new serialization save as features, including saving templates with Special characters in the name.
  • Added SHOW_MRP_QTYS option. This option will add the Inventroy Quantity fields (On Hand, On Order PO, On Order WO, Required, etc) to the main grid.
  • Fixed other bugs with most recent update.
  • Template masters can now load templates from ALL users, instead of just being able to delete them.
  • Added a confirmation dialog to the delete template feature.
  • Added SHOW_ABC option. This option will add an “ABC” column which shows the ABC Code from inventory.

06/18/2019 – Brian Lefler

  • Fixed a bug with the new “DISABLE_CLOSE_JOBS” option, where users that did not have RW access would get an error – when this option was enabled.

9/11/2019 – Brian Lefler

  • Added SHOW_TOTAL_ACT_HOURS custom option (same as SHOW_TOTAL_HOURS except actuals, instead of estimated.)
  • Added WO User Fields, including headers from company options. (standard, not an option)
  • Comments fields were sensitive to single and double quotes. Fixed this.
  • Added Total Cost fields for Material, Labor, Overhead, Outside, Other, Freight (only visible when in RW mode.) (standard, not an option

9/11/2019 – Brian Lefler

  • Added custom “SHOW_4169_NOTES” option. This will pull in the “Notes” field from the Master Schedule Dashboard.

1/16/2020 – Brian Lefler

  • Added Document Control Link column for the Job Header.

1/27/2020 – Brian Lefler

  • “Customer PO” field was made editable for RW users.

1/27/2020 – Brian Lefler

  • Fixed a bug where some Read Only users could see job header costs.

***Nothing Here***

Request a Quote

Field is required!
Field is required!
Field is required!
Add Your Comment