Enter Barcodes

Contents of this Topic: ShowHide

Overview

• The Enter Barcodes screen synonymous with the Microsoft Access Form object or graphical user interface (GUI) is accessed via Main Menu>Settings>Inventory Functions> Enter Barcodes.

• This screen allows the user to enter barcodes for a group of inventory items at one time, as opposed to editing each individual inventory record.

• An alternate method of assigning barcodes to products without a barcode scanner is to have the program autogenerate barcodes as inventory records are created. To use this feature, set system parameter AutoGenerateBarcodes to TRUE.  This will have no effect on inventory records that have been created prior to this parameter being set to TRUE.

• Barcodes must be unique across all products. If the user attempts to enter the same barcode for more than one inventory record, the program will tell the user that it cannot perform the requested action and indicate the product record to which that barcode is already assigned.

• The grid at the bottom of the screen contains all of the inventory items that have been defined in the program. Use the controls at the top of the screen to locate a group records to be updated, select to "left-click" the mouse on an object, usually a row in a table, in the context of Monsoon OMS documentation the row of a product and scan the barcode of the product.

• The user must complete several steps to configure the barcode scanner prior to attempting to enter barcodes for products. Refer to Configuring a Metrologic Barcode Scanner for more information.

• SEOM has only been rigorously tested with the Metrologic Voyager MS 9520 barcode scanners. Other scanners that emulate keyboard input may work with SEOM, but they have not been certified by Stone Edge Technologies Inc..

Description of the Enter Barcodes Screen

Sort By: Section

• use the radio buttons in this section to sort the inventory records in a sequence that facilitates entering barcodes for a selected group of products

• these controls can be used in conjunction with the fields in the Find: section    

SKU Radio Button

• click this button sort the list of inventory records by SKU the abbreviation for Stock Keeping Unit; a unique identifier used to track product inventory

• can be used in conjunction with the SKUs starting with field in the Find: section of the screen

Item Name Radio Button

• click this button to sort the list of inventory records by Item Name

• can be used in conjunction with the Names starting with field in the Find: section of the screen

Ascending Radio Button

• click this button to have the SKUs list in ascending order

Descending Radio Button

• click this button to have the SKUs list in descending order

Find: Section

• enter a string of data in these fields to jump to the location of the matching records in the list in the datasheet grid to enter barcodes for a selected group of products

• these controls can be used in conjunction with the fields in the Sort by: section    

SKUs starting with Field

• enter a text string as criteria for locating inventory records whose SKU begins with the specified text string

Names starting with Field

• enter a text string as criteria for locating inventory records whose Item Names begin with the specified text string

Datasheet Section (Grid)

• this section of the screen displays a list of all of the inventory records that currently exist in the program

• use the controls in the Sort by: and/or Find: sections to quickly locate the records to be changed

SKU Column

• the current value of the SKU field in each inventory record is displayed in this column

• the data in this column cannot be edited

Item Name Column

• the current value of the Item Name field in each inventory record is displayed in this column

• the data in this column cannot be edited

Barcode Column

• this column will initially be blank for each inventory record until a barcode has been assigned to it; at that time it will display the assigned barcode

How to Enter a Barcode for an Inventory Item via the Enter Barcodes Screen

1. Changes made at this screen take effect immediately. When making mass changes it is advisable to first backup the store data file the MS Access or SQL database that contains the users order information and program preferences. It does not contain Reports, which are housed in the Monsoon OMS program file (MS Access database)..

2. If a barcode scanner has not yet been configured for use with SEOM, complete those steps before continuing with these instructions.

3. Use the Sort by: radio buttons or Find: fields to view the inventory records in the desired sequence.

4. Click anywhere in the row of a product seen in the Datasheet (Grid).

5. Scan the barcode of the product to see it populated in the Barcode column of the Enter Barcodes screen.

6. If the incorrect barcode is inadvertently scanned, simply scan the correct barcode, while the same product record is still selected. The program will prompt the user for confirmation before replacing the existing data in the grid.

7. Click [OK] to continue making the change, or [Cancel] to abandon the change.

8. When finished adding barcodes, use the Accordion or Main button to navigate to another location in the program.

Additional Information

Created: 8/2/11

Revised: 9/5/13

Published: 04/13/16