Inventory Control provides several screens to help you physically count inventory items. For an overview of the complete stocktaking process, see Counting and Reconciling Inventory Quantities.
You must generate worksheets in order to enter physical counts later in Inventory Control and create adjustments. You can also print these worksheets to help with the physical counts.
Note: If you generate an inventory worksheet for a location that already has a worksheet, the program warns you and lets you choose whether to replace it.
Warning! To ensure quantities and costs on worksheets are current, do not post transactions (receipts, shipments, transfers, or adjustments) or run Day End Processing between the time you generate inventory worksheets and the time you post the inventory reconciliation.
Before you start
- Run Day End Processing to include the transactions posted 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 order 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 screens are open on your computer.
- If you need to use the average cost to calculate adjustments for standard cost items, make sure that the UseActualCostForPI option is set to Yes in the IC.INI file before generating a physical inventory worksheet. (For more information, see Using Average (Actual) Cost for Physical Inventory Adjustments.)
To generate inventory worksheets:
-
Inventory Control > I/C Physical Inventory > Generate Inventory Worksheet.
- In the I/C Generate Inventory Worksheet screen, you can limit the locations and/or account sets included in the worksheet by specifying ranges in the table.
- For Sort By, select the sort order for the worksheet, which can be by item number, category, item segment, picking sequence, or an optional
field value. If
you select Item Segment, also select one of the defined segment names for Segment.
If you want to limit the report to a range of values for the sort field, enter the range for From and To.
Tip: If you want to create a worksheet for a warehouse area, sort by picking sequence (bin number) and then select the range for that warehouse area.
- You can enter an optional comment to be printed on the worksheet.
- Select which items you want to include on the worksheet:
- All Items from Inventory List. Lists all the items in your inventory that are in the Sort By range.
- Items from Location Only. Lists only the items in the Sort By range that are assigned to the locations you selected for the worksheets (in step 2).
- In Use Items Only. Lists only the items in the Sort By range that are assigned to and have been used in one or more transactions at the locations you selected for the worksheets (in step 2).
- Select the Default Quantity On Hand option to automatically display the current quantity on hand in the Quantity Counted column in the I/C Physical Inventory Quantities screen and the I/C Inventory Counts screen.
Note: This does not control the printing of the Quantity On Hand column on the inventory worksheet; that column is included when you select the Quantity option on the I/C Inventory Worksheet report screen when printing the worksheets.
- Click Generate.
After generating inventory worksheets
- You can print the inventory worksheets to use for writing down the physical inventory counts.
- Perform the physical count of inventory items.
- Use the I/C Physical Inventory Quantities screen or the I/C Inventory Counts screen to enter physical inventory counts into Inventory Control.