Query – Production order status for sales order line items

Follow RSS feed Like

2 Likes 1,700 View 0 Comments

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