Part of Another Product

Hi Lindsay,

I have not tried this but perhaps you can update the item.item_status to ‘4’ instead of ‘5’ for this item via SQL.  After this it would be considered a missing/scrapped item which you can then return to inventory with a Miscellaneous Receive.

I would only do this on a copy of your database to confirm it does what you need:

UPDATE item
  SET 
      item_status = '4'
WHERE item_id =
(
    SELECT item_id
    FROM item WITH(NOLOCK)
    WHERE bpart_id = 'PS60-0024'
          AND serial_no = '01626200005A'
)
      AND item_status = '5';

I have not found a way yet to manage this from the UI itself at this time. but am inquiring.

It is possible to receive a missing/scrapped item into inventory with Miscellaneous Receive.

How to move scrapped/missing item from Removed Item to Inventory | IFS Community