Fields and controls
Comment
Displays any comments entered for the worksheet when the worksheet was generated.
Location
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.
Location Description
Displays the description of the selected location.
Optional Fields (worksheet)
If optional fields are set up for adjustments and adjustment details, you can enter information in the optional fields by clicking 
and selecting Add/Edit to open the Optional Fields screen.
This optional field information will be included in any adjustments that are generated when you post the inventory reconciliation. The optional field information in adjustment transactions can be included in the adjustment posting journal, when you review adjustments in Inventory Control, and when you drill down to adjustments from G/L transactions.
Note: Optional field information can pass to the General Ledger only if the optional fields are also assigned to the general ledger accounts.
Starting Item Number
If you want the table on the screen to start with another item, enter the first item number to display, or click (the Finder button) and select the item.
Status (worksheet)
Displays "Not Posted" if all items on the worksheet have either the "Ready to post" or "On hold" status.
Displays "Errors on Posting" if the program assigned any item on the worksheet a status from the following list:
- Item does not exist.
- Non-stock item.
- Item not allowed at location.
- Insufficient quantity.
- Item not active.
Table
Displays the items on the worksheet for the location that you selected at the top of the screen. Depending on the selections when the worksheet was generated, the worksheet may not include all items at that location.
Adjustment Unit Cost Per Costing Unit
Displays the adjusted unit cost to be used to calculate the cost variance.
Initially, this amount is the same as the amount shown in the Estimate Unit Cost Per Costing Unit column.
If there is a quantity variance (difference between the physical quantity counted and the quantity on hand), you can change the adjustment cost.
Note: To check whether you changed the adjustment unit cost (and if so, by what amount), compare this amount on the worksheet with the amount on this screen.
Cost Variance
Displays the amount to be used to update the item's inventory value when you post the reconciliation.
This amount is calculated by multiplying the Quantity Variance by the Adjustment Unit Cost Per Costing Unit. If the cost variance is negative (the quantity counted is less than the quantity on hand), then the cost variance will also be negative. If the quantity variance is zero (the quantity counted equals the quantity on hand), the cost variance will also be zero.
For example, if an item's adjustment unit cost is $5.00 and the quantity counted is 2 more than the quantity on hand, the cost variance is $10.00 (which is 2 times $5.00).
Estimated Unit Cost Per Costing Unit
Displays the item's cost per stocking unit, which depends on the costing method:
- The average cost (for items using the moving average, FIFO, LIFO, or user-specified costing method).
- The standard cost (for items using the standard costing method).
- The most recent cost (for items using the most recent cost costing method).
Item Number
Displays the item number of each item on the worksheet, starting with the Starting Item Number (if you selected one near the top of the screen).
Item Description
Displays the description of the item associated with the item number.
Optional Fields (item)
This column displays:
- No when this item does not include optional field information.
- Yes when there is optional field information for an item.
If optional fields are set up for adjustments and adjustment details, you can add or change optional fields by clicking in this column and then clicking (the Finder button) to open the Optional Fields screen.
Note: Optional field information can pass to the General Ledger only if the optional fields are also assigned to the general ledger accounts.
Picking Sequence
Displays the picking-sequence code for the item, if any.
Quantity Counted
Enter the number of units that were counted for the item. 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.
Initially, this column either:
- Displays the quantity of the item tracked by Inventory Control, if Default Quantity on Hand was selected when the inventory worksheet was generated.
- Is blank, if Default Quantity on Hand was not selected when the inventory worksheet was generated.
Quantity on Hand
Displays the quantity of the item (in stocking units) tracked by Inventory Control.
Quantity Variance
Displays the difference between the physical quantity
counted and the quantity on hand (as tracked by Inventory Control), which is calculated as follows:
Quantity Counted - Quantity on Hand
The variance is negative when the physical quantity count is less than the quantity
on hand.
This column displays zero if the quantity counted equals the quantity on hand.
Status (item)
Displays the posting status of the item, which can be either:
- Ready to Post
- On Hold if you do not want to post.
You can change the posting status of any item by clicking in this column and selecting the status that you want.
Note: When you post reconciliations, the program changes the status of any items it cannot post.
Stocking Unit of Measure
Displays the stocking unit of measure for the item. This is the unit used for the Quantity Counted and Quantity on Hand.
Overview
Use the I/C Physical Inventory Quantities screen to enter inventory counts after performing a physical count of your inventory. In addition, you can:
- 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.
Tip: Use the I/C Inventory Counts screen if you only need to enter inventory counts.
For an overview of the complete stocktaking process, see Counting and Reconciling Inventory Quantities.
You can delete a worksheet (use the Delete button), but you cannot delete individual lines.
- Edit inventory worksheets (if needed) in preparation for posting reconciliations.
- Assign serial and/or lot numbers if applicable.
Optional fields are available for the I/C Physical Inventory Quantities screen if you add optional fields for adjustments and adjustment details in the Optional Fields screen in Inventory Control. The fields appear on the adjustments generated when you post the inventory reconciliation.