Inventory Reconciliation Errors

When you post an inventory reconciliation, some items may not be posted. The status of each item that was not posted changes from "Ready to post" to a status that indicates the reason the item was not posted. The table below lists these statuses, along with information about changes you can make that will allow you to post the items.

Check each item's status to decide whether you want to make the changes needed to post the item.

Note: After making the changes described, use the Physical Inventory Quantities screen to change the item’s status back to “Ready to post”.

Item Status Issue Resolution
Insufficient Quantity Reconciling the on-hand and counted quantities entered in the Physical Inventory Quantities screen will reduce the item's on-hand quantity to below zero in Inventory Control. (If the Allow Negative Inventory Levels option is selected, the program does not assign this status.) Do one of the following:
  • Select the Allow Negative Inventory Levels option on the Processing tab of the I/C Options screen.
  • On the Physical Inventory Quantities screen, change the number in the Quantity Counted column so that the sum of the quantity counted and the quantity on hand is zero or greater.
Item Does Not Exist The item record was deleted between the time you generated the worksheet and the time you posted the worksheet. Add the item record back into Inventory Control.
Item Not Active The Inactive option is selected in the item record. Inventory Control allows transactions to be posted only for active items. Clear (uncheck) the Inactive option in the item record in the I/C Items screen.
Item Not Allowed at Location You have not assigned the item to the worksheet's inventory location. (If the Allow Items At All Locations option is turned on, the program does not assign this status.) Do one of the following:
  • Allow the item to be stocked at the worksheet's location.
  • Select the Allow Items At All Locations option on the Processing tab of the I/C Options screen.
Non-stock Item The item is a non-stock item. Inventory Control does not maintain quantities and costs for non-stock items. Select the Stock Item option in the item record on the Item tab of the I/C Items screen.