Job Watcher 2.0 – Current Version 20181010-1

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.

Features Listing
  • 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
Column Listing - Header

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

  • Status (“Open” or “Closed”)
  • Work Order
  • 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
  • Sales (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
  • 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
Column Listing - Operations

***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
Column Listing - Details

***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 Listing

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.
    • Values for Options Table
      • OPT_NAME = “GRANULAR_FUNCTIONS”
      • OPT_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.
    • Values for Options Table
      • OPT_NAME = “LOCK_SORTCODE”
      • OPT_VALUE = “Y”
  • Disallow Notes Delete – This option allows for disabling the ability to delete notes from Job Watcher.
    • Values for Options Table
      • OPT_NAME = “NO_DELETE_NOTES”
      • OPT_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.
    • Values for Options Table
      • OPT_NAME = “RESIZE_FACTOR_OVERRIDE”
      • OPT_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.
    • Values for Options Table
      • OPT_NAME = “SHOW_FIRST_WC”
      • OPT_VALUE  = “Y”
  • Show Part Pic – This option allows for previewing a thumbnail picture of a part, when clicking the ‘Pic’ button, 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.
    • Values for Options Table
      • OPT_NAME = “SHOW_PART_PIC”
      • OPT_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.
    • Values for Options Table
      • OPT_NAME = “EDIT_WO_DETAIL”
      • OPT_VALUE = “Y”
  • Edit Sales Order Permissions – This option uses the Sales Order Hyperlink in the Jobs grid to edit the Sales Order Permissions.
    • Values for Options Table
      • OPT_NAME=”EDIT_SO”
      • OPT_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.
    • Values for Options Table
      • OPT_NAME=”PRINT_PDF”
      • OPT_VALUE=Path to the PDF directory
  • Disable Export Button – This option disables the export button on the main screen bottom left.
    • Values for the Options Table
      • OPT_NAME=”DISABLE_EXPORT”
      • OPT_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.
    • Values for the Options Table
      • OPT_NAME=”SHOW_FIRST_MATERIAL”
      • OPT_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.
    • Values for the Options Table
      • OPT_NAME=”CUSTOM_PRINT”
      • OPT_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.
    • Values for the Options Table
      • OPT_NAME=”VIEW_PDF”
      • OPT_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.
    • Values for the Options Table
      • OPT_NAME=”HIDE_REVERSED_DETAIL”
      • OPT_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.
    • Values for the Options Table
      • OPT_NAME=”CHANGE_PARTWC”
      • OPT_VALUE=”Y”
  • BOM Completion – This option will show the percentage of completion through a BOM Work Order series bases on Suffixes Closed / Total Suffixes
    • Values for the Options Table
      • OPT_NAME=”BOM_COMPLETION”
      • OPT_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)
      • Values for the Options Table
        • OPT_NAME=”WO_COMPLETION”
        • OPT_VALUE=”Y
  • Total Scrap Column – This option will show the total scrap from Operations of a Work Order.
      • Values for the Options Table
        • OPT_NAME=”SHOW_TOTAL_SCRAP”
        • OPT_VALUE=”Y”
  • Fix Description Left – Added Custom Option for making the description column fixed to the left.
    • OPT_NAME = ‘FIX_DESC_LEFT’
    • OPT_VALUE = ‘Y’
  • First Open WC – Added Show First Open WC Option
    1. OPT_NAME = ‘SHOW_FIRST_OPEN_WC’
    2. OPT_VALUE = ‘Y’
  • Last Closed WC – Added Last Closed WC Option
    1. OPT_NAME = ‘SHOW_LAST_CLOSED_WC’
    2. OPT_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.)
    1. OPT_NAME = ‘TOTAL_MATERIAL_ISSUED’
    2. OPT_VALUE = ‘Y’
  • Currency Format – Added option for Currency custom format mask
    1. OPT_NAME = ‘CURRENCY_FORMAT’
    2. OPT_VALUE = FORMAT MASK
  • Integer Format – Added option for Integer custom format mask
    1. OPT_NAME = ‘INTEGER_FORMAT’
    2. OPT_VALUE = FORMAT MASK
  • Decimal Format – Added option for Decimal custom format mask
    1. OPT_NAME = ‘DECIMAL_FORMAT’
    2. OPT_VALUE = FORMAT MASK
  • Quantity Format – Added option for Quantity custom format mask
    1. OPT_NAME = ‘QUANTITY_FORMAT’
    2. OPT_VALUE = FORMAT MASK
  •  Parts through Primary Operation – Added Parts Through Primary Option
    1. OPT_NAME = “PARTS_THROUGH_PRIMARY”
    2. b. OPT_VALUE = OP CODE OF PRIMARY OP CODE
  •  Disable Close Jobs – Removes the “Close” button in the Jobs grid. 
    1. OPT_NAME = “DISABLE_CLOSE_JOBS”
    2. b. OPT_VALUE = “Y”
Updates

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. 

FAQ

***Nothing Here***

Request a Quote

7 + 13 =

8 Comments

  1. Peter Levick

    Requests:

    1. Add Customer City/State
    2. Add “First Workcenter”
    3. Add Salesperson

    Reply
    • Brian Lefler

      Peter,

      Customer City and State, and Salesperson have been added. These fields do NOT require a custom option.

      Reply
    • Brian Lefler

      Peter,

      I have now added the “First Workcenter” column as requested. It does require a custom option “SHOW_FIRST_WC”. Please see the custom options section of this page for more information.

      Thanks!

      Reply
  2. Brian Kramer

    Can you Add Customer Qty from WO Header

    Reply
    • Brian Lefler

      Brian, Customer Qty has been added. This field does NOT require a custom option. I just emailed you the new files.

      Reply
  3. Peter Levick

    Will work order changes made via this Job Watcher program get recorded in the Work Order Change Log so a history can be viewed?

    Reply
  4. Brian Kramer

    The new updates to Job watcher are awesome! being able to view the picture and print a copy of the print are essential for our business! Thanks!

    Reply
  5. Peter Levick

    Brian, I want to let you know how pleased we are with the new Job Watcher dashboard. It is exponentially better than the previous dashboards used throughout our company. Not only is there more data and functionality available on this single screen but it is so much faster than the programs we previously used. This truly is a time saver making it much easier for us to manage our business.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *