Customization DS1560- External Component Selection App

Customization DS1560

External Component Selection App

Problem Definition:

ACME needs a simple barcoded component picking solution that is outside of GP. The picking of the components does not need to update the MO in GP. Rather, it should save the data to a SQL table so that a user in GP can use that information to issue the MO.

The component being picked needs to pass the following verification:

  1. The component must be an item number on the picklist.
  2. If the component is a nutrient broth, the item number must exactly match the generic description of the parent.

Solution Overview:

The proposed solution will be delivered as an external application that can be added to the desktop of the warehouse workstations. This application will require the workstation to have an ODBC connection setup so it can make a connection to the SQL Database. A SQL User ID will need to be created to be used by this application to connect.

The type of barcode scanner this application is designed for is a keyboard wedge style.

Design Features:

Ingredient Scanner

The person doing the picking will have paperwork that includes barcodes for the MO Number and Components to pick. When picking an MO, the user will use the ingredient Scanner window.

A screenshot of a computer screen Description automatically generated

Field Function
MO Number The focus will default to the MO Number field. If the MO Number field is populated and a new MO needs to be scanned, click the CLEAR button to reset the window. Scan an MO Number Barcode on the paperwork. If the MO cannot be found in GP, or does not have a picklist, the field will flash red and user will not be able to continue to scan. If the MO is valid, the field will be populated and the focus will move to the ingredient field.
Ingredient Scan the Ingredient (item number) from the paperwork. The enhancement will perform the following validations:

  1. Verify the item is on the picklist for the selected MO.
  2. If the component is marked as nutrient broth, the item number must match the Generic Description of the parent item on the MO.

If either of these validations fail, the Scan Status field will turn red and the message will read “Invalid Item.” The focus will return to the Ingredient field to scan again. If the validation passes, the Scan Status field will turn green and the message will read “Item Added.” The focus will return to the Ingredient field to scan again.

In both cases, the last scanned ingredient for the displayed MO in this session will be displayed. If a successful scan needs to be backed out for some reason, the user can click the UNDO button. This will remove the scan from the system.

Recording Scans in GP

After an item is successfully scanned, the data will be pushed to a SQL table within the company database. The table will include two columns- MO Number and Item Number.

ACME will use this information when issuing material to the MO. There is no GP interface in this estimate to view the contents of the table, but the table will be available for ACME to create a Smartlist or use any other reporting products that can pull from SQL tables.

Assumptions/Requirements:

  1. The Warehouse workstation must have an ODBC connection to the SQL Server setup.
  2. Only one GP Company is being accessed from this application.

NOTE: This design can be reimagined with various table columns.

For information on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/