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
Merge Inventory Master Record
Viewed 1408 times since Thu, Jul 26, 2012
Access denied to OD5transfer.xml
Viewed 2585 times since Wed, Aug 8, 2012
Clearing A Late Fee With F5 Batch
Viewed 3902 times since Wed, Jun 6, 2012
Registry error setting up Activant, FirstCall or eStore catalog
Viewed 6164 times since Fri, Mar 27, 2009
Management System - Error Codes List
Viewed 10947 times since Wed, Jun 11, 2008
Late Fee Calculation - Annual Percentage Rate (APR)
Viewed 1552 times since Fri, Sep 2, 2016
Shop Management SE Mail Merge
Viewed 10789 times since Tue, Jul 2, 2013
Creating a Prior Balance For Customer
Viewed 3242 times since Wed, Aug 13, 2008
Verifying the Manager Update Has Been Run
Viewed 1528 times since Mon, Jan 6, 2014
Avast! Anti-Virus Exception
Viewed 2138 times since Tue, Mar 17, 2015