Error:
on-hand quantity exists or there are open deliver transaction for this item, please process before changing the attributes
Solution:
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:-
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
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.
our company wants to delete all the old items and upload with new codes & description.
ReplyDeleteis 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.
select *
ReplyDeletefrom 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;
fame problem face with me
ReplyDelete