For one of the inventory item xyz, it shows that we have qty of 97 committed. We are not supposed to have any open production orders for that particular item.
I ran the following query to check for any open production orders:
SELECT T0.[DocNum], T0.[ItemCode], T1.[ItemCode], T0.[Status], T0.[PostDate] FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[ItemCode] = xyz' AND T1.[IssuedQty] = T1.[PlannedQty]
There's only 4 open production orders and none of them contains 'xyz'. Therefore, what other ways can I pinpoint the open order that contains that item so we can further adjust the correct qty?
I tried 'drag & relate' also but it didn't help.