Changing and Deleting Item/Warehouse Associations

The Inventory module provides warehouse managers with two screens for maintaining item/warehouse combinations. The Item Warehouse Update (IWU) screen is used to modify information about an item/warehouse record originally established on the Item Warehouse Entry (IWE) screen. When changes to an item/warehouse association are made on the Item Warehouse Update (IWU) screen in the Inventory module, the changes are passed to the Purchasing module real-time.

The Item Warehouse Delete (IWD) screen is used to delete item/warehouse records. Using this screen, records are deleted during nightly offline processing. There are several conditions that must exist for an item/warehouse combination to be deleted:
 

1. The following quantities must be zero in the system:

On-order quantity: The amount of the item on order from a vendor or a warehouse. 
On-hand quantity: The amount of active inventory stored at a particular warehouse. 
Nonactive quantity: The unusable quantity of the item at the warehouse. 
Released requirements: The total quantity of the item committed to released orders. Released orders are online requests for items that have been released, or submitted, to that warehouse.

These balances will be explained in greater detail later in this course. 
2. Cycle counts and pick lists involving the item must not exist in the NCAS.
 
Deleting an item/warehouse association converts the inventory item to a nonstock item in the Purchasing module if no other warehouse associations exist for that item and catalog number. NCAS policy requires that once an item has been deleted from the Inventory module, it must also be deleted from the Purchasing module. To delete an item from the Statewide Item File in the Purchasing module, you must contact the Office of the State Controller.
Accounting System Home Page | Information Guide Home Page | OSC Home Page