To locate committed stock is for which customer

[Former Member]

Please help teach me how to know committed stock is for which customer or which open SO?

[former_member312729]

Hi Kimberley

Try the below query

SELECT T0.[ItemCode], T2.Quantity, T1.[DocNum], T1.[CardCode], T1.[CardName] FROM OITM T0 inner join Rdr1 T2 on T0.ItemCode = T2.ItemCode INNER JOIN ORDR T1 ON T2.[DocEntry] = T1.[DocEntry] WHERE T0.[ItemCode] =[%0] and T1.[DocStatus] Not In ('C') and and T1.[CardName] =[%1]

Regards:

Balaji.S

[kothandaraman_nagarajan]

Hi,

1. Find particular item from Item master data

2. Right click and then choose 'Inventory status'

3. Double click the row to see committed qty for sales order.

Regards,

Nagarajan