Inventory Scanner

Contents of this Topic: ShowHide

Overview

• The Inventory Scanner screen synonymous with the Microsoft Access Form object or graphical user interface (GUI) is used to update the QOH count of stock not ordered through the SEOM purchase order system, just as the Receive Inventory screen does (accessed through the Receive button on the Inventory screen).

• The distinct advantage of the Inventory Scanner screen is that it receives inventory for multiple SKUs at this one location and supports the use of a barcode scanner.

• The Inventory Scanner screen is accessed by:

Main Menu>Settings>Inventory Functions>Scan Non-PO abbreviation for Purchase Order Items  

If products are obtained from a supplier vendor via the SEOM Purchase Order system, the merchant must use the Receive Inventory button on the Purchase Order screen to properly record those changes in the program.

Description of the Screen

Barcode Field

• type in a barcode or place the cursor here and use a barcode scanner to enter the barcode of a particular product into the list of Scanned Items
• scan the same item multiple times for each unit received or scan it once and manually update the value in the Quant. column of the datasheet with the correct total number of units received   

SKU Field

• type a SKU the abbreviation for Stock Keeping Unit; a unique identifier used to track product inventory in this field if a barcode scanner is not available
• if a barcode scanner is used, the program automatically completes this field when the barcode is scanned  

Scanned SKUs and Scanned Items Fields

• shows the running total of the number of SKUs and number of Items that have been scanned in the current session

Cancel Entire List Button

• use this button to erase all of the data in the datasheet and start over

• this can only be done prior to clicking the Save button; once that button has been clicked the data has been stored in the program

Cancel List Scanned Item Button

• use this button to un-do the last action taken at this screen prior to clicking the Save button

• despite the label of this button, it does impact manually entered or updated records as well as scanned items

• once this button has been clicked, it cannot be re-used until another item has been scanned or added; changing the value of the Quant. field of another item in the list does not count as an eligible action

• be aware that if adding a SKU (having the Quant. of 1) was the last action performed at this screen, it will be removed from the list entirely; if the SKU has a Quant. greater than one (manually keyed in), its Quant. value will be decremented by 1, not by the unit count that was keyed in

• Scanned Items Data Sheet

• when a barcode or SKU is entered in the Barcode or SKU fields respectively, the program displays that item in the Scanned Items datasheet

Barcode Column

• displays the barcode assigned to a given product

SKU Column

• displays the Stock Keeping Unit assigned to a given product

Quant. Column

• displays the number of units scanned for each item in the current session

• this field can be edited manually, unlike the other fields in this grid

• if there are many units of a single product to be received, scan it once and update this column with the total number of units

• the value of this field is added to the existing value in the # On Hand field of the product's inventory record when the [Save] button is clicked

Item Name Column

• displays the value in the Item Name field of the product's inventory record

Save Button

• click this button to store the data currently displayed in this screen into 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).

• the value of the Quant. field is added to the existing value in the # On Hand field of the product's inventory record when the Save button is clicked

Additional Information

Created: 5/11/12

Revised:  6/29/12

Published: 04/13/16