Entering Physical Inventory Quantities

Learn more

After counting inventory, you enter physical inventory quantities on one of the following screens:

I/C Inventory Counts screen. Use this screen if you only need to enter inventory counts. (This screen is a simpler version of the I/C Physical Inventory Quantities screen)
I/C Physical Inventory Quantities screen. Use this screen to:
- Enter inventory counts.
- Compare the quantities on hand (as tracked by Inventory Control) to the physical counts.
- Enter adjustment unit costs.
- Change the posting status of individual items.

For an overview of the complete stocktaking process, see Counting and Reconciling Inventory Quantities.

To enter physical inventory quantities:

Open either of these screens:
- I/C Inventory Counts screen (select Inventory Control > I/C Physical Inventory > Inventory Counts)
- I/C Physical Inventory Quantities screen (select Inventory Control > I/C Physical Inventory > Physical Inventory Quantities)
Select the location whose inventory count you want to enter. You can type the location code, or click (the Finder button) and select the location.
(Optional) If you want the table on the screen to start with another item, enter the starting item number, or click (the Finder button) and select the starting item.
(Optional) If optional fields are set up for adjustments and adjustment details, you can click and select Add/Edit to open a screen to edit optional fields that apply to the whole worksheet.
For each item in the table:
1. Enter or edit the number of units that were counted in the Quantity Counted column.
  
  If the item has more than one unit of measure, click (the Edit button) to open the Quantities screen, so you can enter the quantity for each unit of measure defined for the item, such as the number of crates or boxes. On the Quantities screen for serialized/lotted items, assign serial/lot numbers.
  Note: If Default Quantity On Hand was selected when the inventory worksheet was generated, the current quantities on hand are inserted for each item in the Quantity Counted column, but you can change the figures.
2. (Optional) If optional fields are set up for adjustments and adjustment details, you can add or change optional fields by clicking in the Optional Fields column and then clicking (the Finder button) to open the Optional Fields screen.
3. (I/C Physical Inventory Quantities screen only) If there is a quantity variance (difference between the physical quantity counted and the quantity on hand), you can change the adjustment cost in the Adjustment Unit Cost Per Costing Unit column.
4. (I/C Physical Inventory Quantities screen only) If you want to change the posting status of the item, click in the Status column and select either Ready to Post or On Hold.