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
Posted Orders ’Grand Total’ Differs From ’Sales Receipts Summary’ Total
Viewed 2729 times since Wed, Jun 11, 2008
"Cannot Locate Vehicle" - ShopCAT Button Inside Mgmt
Viewed 2413 times since Wed, Jun 11, 2008
Access denied to OD5transfer.xml
Viewed 2405 times since Wed, Aug 8, 2012
Import Data Into Shop Mgmt Database
Viewed 5443 times since Wed, Jun 25, 2008
Od5browser.exe - .NET framework initialization error: Unable to find a version of the runtime to run this application
Viewed 3154 times since Thu, Aug 9, 2012
How to: Enable a Catalog and Link a Vendor in Manager
Viewed 4056 times since Fri, Sep 11, 2015
Figuring Shop Overhead
Viewed 9376 times since Wed, Jun 6, 2012
An Internet operation failed, Code 12007
Viewed 802 times since Fri, Aug 3, 2012
MyBowser1 has encountered a problem error
Viewed 932 times since Wed, Aug 8, 2012
Cust Followup Calling Report
Viewed 2697 times since Fri, Jul 17, 2009