Update Inventory Worksheet

This utility can also be added to an Additional Options menu for direct access from the menu tree.

After the physical inventory count has been completed, use this option to update the Sales product quantities.
Although rental products can be counted using the worksheet no inventory count adjustments will actually be processed for Rental products.

It is important to do the physical inventory count on the same date as the worksheet was generated to ensure that the adjustment is the correct count.
The worksheet with the correct adjustment count as of that date, can then be processed later updating the Inventory sub-ledger, regardless of subsequent inventory activity.

Enter the corresponding Page # and the Location matching the report generated Inventory Count Console.
The blank page on the worksheet includes any products with no location record (RSIL).
To access products with no location record, leave the Page# field blank and then enter the appropriate location. The products with no location record are then listed on the screen and can be updated.
Sales or rental detail lines can be deleted from the blank page only.
Product detail lines cannot be deleted from the numbered pages.

Security:
The Location and permission to change it, are controlled for the operator by the Default Location defined in Operators.
The menu option RSNQ01 can be setup on an Additional Options menu in the Application Menu tool, so that operators have direct access to the worksheet without requiring access to the Inventory Count Console.
Further security protection for the worksheet can be setup by assigning Security Roles and a password to the module "RSNQ01" in Module Passwords.
For more information on this security feature refer to System Security Overview.

Resulting Product List:

The resulting product count page displays the Product #, Description, Quantity On Hand at the Location, and the serial number from the Fixed Asset Tag for non-bulk rentals.
The Counted quantity may or may not be defaulted, depending on the response in the Inventory Count Console to the Default Count Qty From On Hand Qty prompt.

Only products that have a matching location record are printed on the 'numbered' pages for that location.
Any products in the select range that do NOT have a location record are listed on the blank page so they can still be accessed and the count updated.

Note: The number of serial numbers for a serialized sales product on the count sheet needs to equal the on hand quantity of that product. If the number of serial numbers for the sales product does not match the on hand quantity for that product, a ***NO SERIAL NUMBER*** line is generated for that product.

SALES PARTS:

Manually Updating Product Count on Worksheet (location not using Count Tags):

If the Counted field is blank on the worksheet, the correct quantity needs to be entered for each product to calculate the correct adjustment.
If the Counted field has been defaulted to the location quantity and changes are required, type in the correct quantity counted so that the Adjustment column displays the corresponding quantity adjustment required.

A window on the Counted field is provided to view any changes to the product count on the worksheet as outlined in Worksheet Adjustments.

Updating Product Count Using Count Tags

The actual quantity count for each product can be captured and entered from multiple Count Tags in Count Tag Entry, but all tags for that product must be submitted to the worksheet at the same time using Update Worksheet with Count Tags.
When multiple Count Tags are submitted for the same product, the last operator and date assigned will be displayed on the worksheet, but details can be viewed in the Worksheet Adjustments window.

After a product on the inventory worksheet has been updated by Count Tags, no further Count Tags can be used for that product, but manual adjustments can then be made in the Counted field on the inventory worksheet.
Manual adjustments can only be made to the Counted field on the inventory worksheet if there are no Count Tags for that product, or if the Count Tags have already updated the worksheet.

Note: Manual adjustments cannot be made to the Counted field on the inventory worksheet if there are outstanding Count Tags for the product waiting to be submitted.

A window on the Counted field is provided to view any changes to the product count on the worksheet as outlined in Worksheet Adjustments, including changes generated from the Count Tag Entry process, and reversing counts generated from Refresh Quantities in Worksheet.

RENTAL EQUIPMENT:

If any Rental Products are missing when the physical count is reconciled, enter the loss or disposal on an invoice in Miscellaneous Invoices, selling the product for zero dollars.
This updates the Fixed Asset Tag, generates a Disposal transaction, and posts the correct inventory value adjustments to the G/L.

This utility does NOT actually update inventory count on rental products.