Skip to Content
0
Former Member
Dec 15, 2010 at 07:34 PM

Inventory committed Item

285 Views

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.