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.

3 comments:

  1. our company wants to delete all the old items and upload with new codes & description.
    is it possible to delete all items by query or api or inactive them all but unfortunately i'm facing the same error bcoz many items are in transaction in POs & onhand.

    ReplyDelete
  2. select *
    from mtl_onhand_quantities_detail
    where inventory_item_id = &item_id
    and organization_id = &org_id;

    select *
    from mtl_material_transactions_temp
    where inventory_item_id = &item_id
    and organization_id = &org_id;

    select *
    from mtl_supply ms
    where item_id = &item_id
    AND (from_organization_id = &org_id OR to_organization_id = &org_id);

    select *
    from mtl_demand
    where inventory_item_id = &item_id
    and organization_id = &org_id;

    select *
    from mtl_txn_request_lines
    where inventory_item_id = &item_id
    and organization_id = &org_id
    and line_status = 7;

    ReplyDelete
  3. fame problem face with me

    ReplyDelete