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
Search By First Name
Viewed 10224 times since Wed, Jun 6, 2012
Record Lock
Viewed 3052 times since Fri, Jun 20, 2014
Handling Changes to MI Part Core Tax on Manager SE Estimate/R.O./Invoice
Viewed 1172 times since Tue, Mar 28, 2017
Verifying the Manager Update Has Been Run
Viewed 1629 times since Mon, Jan 6, 2014
Mgr Report Date Ranges Won’t Stick
Viewed 1209 times since Wed, Aug 8, 2012
How To Add New Referral Type
Viewed 8888 times since Thu, Sep 1, 2011
Disable USB Port To Prevent Copying Of Your Database
Viewed 2371 times since Thu, Jun 12, 2008
Clearing A Late Fee With F5 Batch
Viewed 4030 times since Wed, Jun 6, 2012
Swap Personalized Plate To Customer’s Diff Car
Viewed 2654 times since Wed, Oct 8, 2008
Personalize Your Letters & Postcards
Viewed 2410 times since Fri, Oct 30, 2009