Update Worksheet with Count Tags

This utility can be used to print the products counted and to populate the Inventory Count Worksheet created in Update Inventory Worksheet with the quantities on the Count Tags that were entered in the Count Tag Entry utility.
It can be accessed by clicking on the UPDATE button in Count Tag Details.

The Inventory Count Worksheet must exist for the location in Update Inventory Worksheet and only products on the worksheet will be updated.
Multiple Count Tags can be created for each product, however all Count Tags for a product must be submitted for a location at the same time to update the Inventory Worksheet using Update Worksheet with Count Tags.
After the Count Tags have updated the worksheet, the Counted field on the worksheet can be adjusted manually if required, but no further Count Tags can be used for that product at that location.

The prompts are:

OPERATOR

The operator defaults to the operator currently signed in, but can be over-typed or re-selected from the drop-down list if required.

PASSWORD

Enter the password for the selected operator.
This is mandatory to verify access.

LOCATION

The default location for the operator is displayed, and can only be modified if the operator has access to other locations as defined in Operators.
Only divisions flagged as inventory locations in Divisions can be selected.

Worksheet Items Updated With Count Tags:

A spreadsheet is generated listing the products that have been successfully updated on the Inventory Count Worksheet from the Count Tags.
The information includes the location, page #, serial #, product #, description, product class, old quantity, count tag quantity, adjustment, date, operator, and cost difference.

Product Errors:

Count Tag quantities cannot be updated for any products that are not on the Inventory Count Worksheet.
Any errors are reported on the Information Log that can be printed or output to Excel for follow up.

POSTING CONFIRMATION

Click YES to update the product count for the location on the Update Inventory Worksheet.
The updated Inventory Count Worksheet can be accessed from the Inventory Count Console by clicking the WORKSHEET button.
The page of the worksheet is listed on the Count Tag spreadsheet.
A window on the updated Inventory Count Worksheet is provided to view the Count Tag tag information as outlined in Worksheet Adjustments.

Click NO to abort the update process.
The Tag Count records will not be deleted, and can be reprocessed later.