Thursday, October 16, 2014

Unable to change the Stockable attributes in inventory Item error: on-hand quantity exists or there are open deliver transaction

Error:
on-hand quantity exists or there are open deliver transaction for this item, please process before changing the attributes



Solution:

If your are in the position to change the “Inventory item” to “service Item” we have to the uncheck the following check box to change as “Service Item”

                            Inventory item
                            Stockable
                           Transactable


Since, we can’t able to uncheck it easily, we need to ensure on-hand quantity NULL & if any interorg shipment linked with it.

1) For on hand, please do misc issue.
2) For mtl_supply, please go to supply/demand screen..find out all the POs or Reqs or Interorg shipments linked, then receive and deliver them.

Make sure:-

SELECT COUNT(1) FROM MTL_ONHAND_QUANTITIES_DETAIL WHERE INVENTORY_ITEM_ID = &item_id
AND ORGANIZATION_ID = &organization_id;
==> count = 0

SELECT COUNT(1) FROM MTL_SUPPLY WHERE ITEM_ID = &item_id
AND TO_ORGANIZATION_ID = &organization_id;
==> count = 0

Then the item attribute Stockable should be able to unchecked.