Type over the displayed cost if you need to change it. Note that you can change the displayed cost only if the quantity counted you enter differs from the item's quantity on hand.
The Adjustment Unit Cost field and the Estimated Unit Cost field contain the same cost when you generate worksheets. You can compare the costs displayed in these two fields to check whether you changed the adjustment unit cost and, if so, by what amount.
For items using the moving average, FIFO, LIFO, or user-specified costing method, the program displays the item's average cost per stocking unit. For items using the standard or the most recent cost costing method, the program displays the item's standard cost or most recent cost per stocking unit, respectively.
Displays any comments that you entered in the Comment field in the Generate Inventory Worksheet screen when you created the worksheet.
Displays the result of multiplying the quantity variance by the adjustment unit cost. The cost variance is the amount by which the program updates the item's inventory value when you post the reconciliation.
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 program multiplies 2 by $5.00 and displays $10.00 in the Cost Variance field. (Note that cost variances are negative amounts when the quantity counted is less than the quantity on hand.)
If the quantity variance is zero (the quantity counted equals the quantity on hand in the Inventory Control system), the program displays zero in the Cost Variance field.
For items using the moving average, FIFO, LIFO, or user-specified costing method, the program displays the item's average cost per stocking unit. For items using the standard or the most recent cost costing method, the program shows the item's standard cost or most recent cost per stocking unit, respectively.
Shows the item numbers and descriptions in the range you selected when you generated the worksheet, and for the location that you selected at the top of the screen.
Type the code for the location or select it from the Finder.
If you added optional fields to adjustments and adjustment details, you can enter optional field information that will be included in any adjustments that are generated when you post the inventory reconciliation.
Optional fields in adjustment transactions provide information on the adjustment posting journal and when you review adjustments in I/C or drill down to adjustments from G/L transactions.
Shows each item's picking-sequence code, if any.
Enter the number of units you counted for the item. Press F9 to display a screen with all of the units of measure defined for the item (so you can enter the number of crates, boxes, etc.).
If you selected Default Quantity On Hand when you generated the physical inventory worksheet, the Quantity Counted column will list the quantity calculated by Inventory Control.
If you did not select Default Quantity On Hand when you generated the physical inventory worksheet, the Quantity Counted column will show zero quantities until you enter a count.
Displays the item quantities (in stocking units) maintained by the program.
Shows the result of subtracting the quantity on hand from the quantity counted. (Note that quantity variances are negative when the quantity on hand in Inventory Control is greater than the physical count.)
If the quantity counted equals the quantity on hand, the program displays zero in the Quantity Variance field.
Enter the first item number to use or select it from the Finder.
Displays the message "Not Posted" if all items on the worksheet have either the status "Ready to post" or the status "On hold."
Displays the message "Errors on Posting" if the program assigned any items 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.
You can change the posting status of any item. Assign the status "Ready to post" to items you want to post and assign the status "On hold" to items you do not want to post.
To change an item's posting status:
- Tab to the item's Status column in the table, then click the arrow symbol beside the Status heading (or press the Spacebar in the Status column for the item) to open the status list.
- Double-click a status to select it from the status list, or use the Up Arrow or Down Arrow key to highlight a status then press the Enter key.
Note: When you post reconciliations, the program changes the status of any items it cannot post.
Displays the stocking unit of measure for each item.
Overview
Use the I/C Physical Inventory Quantities screen to:
- Enter inventory counts after taking inventory.
- Edit inventory worksheets (if needed) in preparation for posting reconciliations.
- Assign serial and/or lot numbers if applicable.
You can enter counted quantities (which are all zero on newly generated worksheets) and adjustment unit costs, and change posting status. Press F9 to enter quantities in different units of measure.
You can delete a worksheet (use the Delete button), but you cannot delete individual lines.
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.
Note: Use the I/C Inventory Counts screen for a simpler version on which you enter only inventory quantities.
Importing and Exporting Data
You can use the Import and Export commands under the File menu to import and export data from/to Inventory Control. The procedure is slightly different from the way most Sage 300 screens import and export data. Instead of one file, the import/export process involves two files:
- A file that contains the worksheet and optional fields data.
- A file that contains all other data.
When exporting, make sure you use two different file names when prompted to do so. When importing, make sure you select the file with the worksheet and optional fields data first, then the second file.