Generate Inventory Worksheets for Stocktaking
Overview
Inventory Control provides 6 forms to help you physically count inventory items. See Count and Reconcile Inventory Quantities for a complete list of the steps in the stocktaking process.
You must generate worksheets in order to enter physical counts later in Inventory Control and generate adjustments. You can also print generated worksheets to help with the physical counts.
Note: If you generate an inventory worksheet for a location that already has a worksheet, the program replaces the old worksheet with a new one. The program warns you if there are existing worksheets for locations and lets you choose whether to replace them.
To ensure quantities and costs on worksheets are current, do not post transactions (receipts, shipments, transfers, adjustments, assemblies, or internal usage), and then run Day End Processing between the time you generate inventory worksheets and the time you the post the inventory reconciliation.
Before
you start
-
Run Day End Processing to update the company's Inventory Control data if you have posted transactions since the last time you ran Day End Processing. (You should run Day End Processing even if you cost items during posting.)
-
Decide on the inventory locations, account sets, and items that you want to count.
-
Decide on the sorting order in which to list items on the physical inventory worksheets.
-
Make sure no other users are working with the Inventory Control database and no other Inventory Control forms are open on your computer.
To generate inventory worksheets:
-
Open Inventory Control > I/C Physical Inventory > Generate Inventory Worksheet.
Click here for help on Generate Inventory Worksheet fields.
-
Specify the range of locations and account sets for which you require the worksheet.
-
Specify the order in which you want to list items on the worksheet.
This is also the method by which you will select the items that you want to list. For example, you can choose a range of item categories or item numbers, or you can select a warehouse area by choosing a range of picking sequences (bin numbers).
-
Type an optional comment to be printed on the worksheet.
-
Specify which items you want to include on the worksheet.
-
Items from Location Only, to select only the items in the Sort By range that are assigned to the locations for which you are generating worksheets.
-
In Use Items Only, to select only the items in the Sort By range that are assigned to and have been used in one or more transactions at the locations for which you are generating worksheets.
-
All Items from Inventory List, to select all the items in your inventory that are in the Sort By range.
Note: Items are included regardless of whether they are currently allowed to be used in Inventory Control transactions.
-
Select the Default Quantity On Hand choice if you want Inventory Control to automatically display the current quantity on hand in the Counted Quantity column in the Physical Inventory Quantities form or the Inventory Counts form when you enter counts in Inventory Control.
You can later print the current quantity on hand on Inventory Worksheets whether or not you chose the Default Quantity On Hand choice when you generate the inventory worksheet.
-
Click Generate, and then click OK from the message that appears.
After
generating physical inventory worksheets
-
Optionally, print inventory worksheets on which to write the physical inventory counts (using the Inventory Worksheet report form).
-
Count inventory items.
-
Use the Physical Inventory Quantities form or the Inventory Counts form to enter physical inventory counts for inventory worksheets.