how long ago was it deleted?  usually if you delete an order with something still active, it creates integrity errors.  if it was just this week, then usually an integrity check would be done on the weekend (that's how we operate) and that would fix the error if that's the problem.

Or, and just a total maybe... is it actually committed to a different order and you just missed it?

Worse case, if you need to ship it out today and can't want for an integrity check, just IC Adjust another one in and do another one when the integrity check is done.

Hi Mike Cook,

Thank you for your reply.

I am not sure when but it was long ago. The system though did not show any integrity issues - which I am thankful of.

Mike Cook said:

Or, and just a total maybe... is it actually committed to a different order and you just missed it?

Anyway, I did some more digging as to what the issue really is. Our staff, when entering an order, he marked the item as committed and eventually deleted the order without changing the status of the "Qty. Committed" column back to zero and the item has never been shipped as well. The item still shows as committed in our inventory even if the item is no longer available as it was sold to a different customer. The accounting manager might have just added the same item through I/C Adjust.

How do I change the status of this item to non-committed so we can delete or adjust our inventory accordingly?

i want to know the recommended way of fixing this issue in case we encounter the same problem in the future.

a data integrity check/fix should fix it.  it will compare the IC details with the actual OE details and realize that there is nothing actually committed and then it should fix it in IC.