Physical Inventory Count Review

This screen appears after you read in data from the PC via the Import/Export Physical Inventory Count routine. Use this screen to

view imported inventory data,

generate a report based on the displayed data, or

update the physical inventory with the count data not indicated as an error.

Options Use this field to restrict the display in the grid. You have the following options:

All Records - display all imported data
Update Only - display updated data only
Errors Only - displays lines flagged with errors only

The following columns display in the grid:

Label Number - the data imported from the label number field.
Product - the product key (SKU) associated with the label number.
Storage Locn - the storage location in which the piece was counted or any notation the import process returns.
Update Qty - the count quantity associated with the label number used to populate the physical inventory.
Error Qty - the count quantity associated with the label number with which an error is associated. This quantity does not populate the physical inventory.
Error Message - the error for the line (if any).

To update the physical inventory counts with the imported data, click on Save. If errors are found, a warning message appears with the option to continue with the update or cancel the update. Note that the process does not add lines with errors to the physical inventory count.

Clear button - re-initializes the screen.

Delete button - inactive on this screen.

Exit button - returns you to the Import/Export data process.

The process reports the following conditions as errors and prevents the individual count from being processed:

Label number isn’t 12 digits (1 - label type, 2-7 label cross reference, 8-12 label counter)

Label type incorrect (first digit of label number must start with 7 or 9)

Label cross reference doesn’t exist (2-7 of label number doesn’t match an existing product cross reference number)

Label references product in another location (special order, serial tracked, and as-is labels match specific products in the system and must be counted at the store/warehouse in which they reside.)

Storage location missing (Location tracked locations must pass valid storage location)

Storage location not on file (Location tracked locations must pass in a valid storage location)

Storage location not valid for location ~ (Location tracked locations must pass in valid storage location)

Quantity must be numeric (Number of pieces counted must be passed into process)

Quantity must be an integer (Number must be between 1 – 9999)

Invalid Quantity for product type ~ (Only bulk products accept a quantity greater than 1)