Query – Production order status for sales order line items

Dear all,

Please use below to query to find production order status for sales order lines. From this, you can know,

1. Production order status —-> Planned, Released, and closed

2. Production orders not created for sales orders

3. Production order planned quantity Vs. completed quantity

Query:

SELECT

T1.[DocNum] AS ‘Prod Order’,

T0.[DocNum] AS ‘Sales Order’,

T0.[NumAtCard] AS ‘Cust PO’,

T0.[CardCode]’CustCode’,

T0.[CardName]’CustName’,

T1.[ItemCode],

T1.[Status]’ProdStatus’,

T1.[PlannedQty] as ‘Planned Qty’,

T1.[CmpltQty]’CompQty’,

T1.[DueDate]

FROM

ORDR T0 left JOIN OWOR T1 ON T0.CardCode = T1.CardCode AND T0.DocNum = T1.OriginNum

WHERE

T0.[DocStatus] = ‘O’

Order by  T0.[DocNum]

Hope helpful.

Thanks & Regards,

Nagarajan