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
Be the first to leave a comment
You must be Logged on to comment or reply to a post.