Home » Categories » Multiple Categories

Inventory Worksheets + Update Function

Q: Getting ready to do annual inventory; are there reports to use during the actual inventory process? When finished, is there a faster way to update the item QOH (quantity on hand) than using Inventory search screen and opening one record at a time?

A: Yes, under the Inventory tab there are several worksheets for inventory. Select the one that works best (most likely By Location option).


When the process is complete, click on Inventory, Inv. Functions and select Physical Count.

On this screen, you need only 1) enter the part number, 2) press tab and the existing data will display. 3) Enter the actual quantity found from your worksheet into the New Quantity field and then click 4) Update. Repeat this process until all of your worksheet parts have been processed.

NOTE: If the quantity from your inventory work matches the value in the Current Qty. field, simply skip to inputting the next part number to check.

Inventory transaction window:



0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Comments Comments
Related Articles RSS Feed
3051 Error - Utilities With Program Open or Read-Only
Viewed 3917 times since Wed, Jun 11, 2008
Nexpart and Wiseconnect require line code option
Viewed 2243 times since Wed, Aug 8, 2012
Configure 5.9 Shop Mgmt To Email EST/INV/Revisions
Viewed 5649 times since Fri, Feb 10, 2012
User Guide / Directions / Manual
Viewed 16675 times since Thu, Oct 4, 2012
Estimator Functionality Lost After Updating Manager?
Viewed 3347 times since Fri, May 23, 2008
Manager SE "You do not have an active license" Message
Viewed 3654 times since Wed, Sep 9, 2015
Creating A Manual Purchase Order
Viewed 8627 times since Wed, Jun 6, 2012
How To Search Purchase Orders
Viewed 3109 times since Wed, Jun 6, 2012
How to Remove License Plate SE
Viewed 4369 times since Wed, Jun 6, 2012
Adding Shop Logo to EST/RO/INV 6.x SE
Viewed 26916 times since Tue, May 22, 2012