Cleaning up inventory items count/quantity

Hello All,

We have few inventory items that we do not sell anymore and also do not have them physically either.

But we still have a on-hand quantity in Oracle for such items and we are trying to clean/fix to make it zero.

Case 1: We had an item that had an on-hand qty of 2 and available qty was 0.We then did a miscellaneous transaction and issued out qty of 2 to bring the on-hand qty to zero but the available qty now is -2. How can we rectify/correct this.

Any help is much appreciated.

Thanks,

--John.