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
Error Code -2 Is Share Setting
Viewed 2625 times since Wed, Jun 11, 2008
How ManagerPlus Calculates Last Cost / Avg Cost
Viewed 2228 times since Wed, Jun 4, 2008
Shop Management SE Mail Merge
Viewed 10098 times since Tue, Jul 2, 2013
Swap Personalized Plate To Customer’s Diff Car
Viewed 2292 times since Wed, Oct 8, 2008
Od5browser.exe – fatal error clr error
Viewed 975 times since Thu, Aug 9, 2012
How to apply a discount and retain full tax amount
Viewed 9691 times since Wed, Aug 8, 2012
OEM PnL Transfer Link Missing
Viewed 956 times since Wed, Aug 15, 2012
Customer Is Non-Tax But Order Is Taxed?
Viewed 2383 times since Wed, Aug 13, 2008
3051 Error - Utilities With Program Open or Read-Only
Viewed 3419 times since Wed, Jun 11, 2008
Details Of Top 25 Reports In Shop Mgmt
Viewed 5589 times since Fri, Jan 2, 2009