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
Configure 5.9 Shop Mgmt To Email EST/INV/Revisions
Viewed 5138 times since Fri, Feb 10, 2012
Mgr Report Date Ranges Won’t Stick
Viewed 1056 times since Wed, Aug 8, 2012
Top 25 Reports Defined
Viewed 2415 times since Thu, Jul 26, 2012
Manager Crashes when using drop down selection on Technician
Viewed 3352 times since Thu, Feb 21, 2013
Od5browser.exe - .NET framework initialization error: Unable to find a version of the runtime to run this application
Viewed 3358 times since Thu, Aug 9, 2012
Printing Error: Odometer In Validation Msg By System
Viewed 3331 times since Wed, Jun 25, 2008
Fix Inaccurate Avg Part Cost
Viewed 2561 times since Thu, Mar 12, 2009
Add a New Service Writer (5.9.x)
Viewed 2561 times since Wed, May 23, 2012
Shop Mgmt Keyboard Shortcuts (5.9.x)
Viewed 7905 times since Wed, May 23, 2012
SE Reports Pack (Samples)
Viewed 6893 times since Fri, Aug 9, 2013