QueryReport to list all production orders for Sales Orders

[former_member188586]

Hi to all

Bellow Query Helps to Bring  Production Orders for SO

QueryReport to list all production orders for Sales Orders

SELECT T2.[DocNum] as 'SO No.', T0.[DocNum] as 'Production Order No.', T0.[ItemCode] as 'Product No.',

T0.[PlannedQty]as 'Quantity to Make', T2.[CardName]as 'Customer Name', T0.[DueDate]as 'Ship Date',

T1.[ItemCode],T4.[ItemName] as 'Item to Purchase', T1.[PlannedQty]as 'Quantity',

T4.[IsCommited] as 'Required For Assembly', T4.[OnHand]as 'In Stock', T4.[OnOrder] as ' Total Incoming'

FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry

INNER JOIN ORDR T2 on T2.DocNum = T0.OriginNum

INNER JOIN OITM T4 ON T1.ItemCode = T4.ItemCode

where T0.[Status] <> 'L'

GROUP BY T2.[DocNum], T0.[ItemCode],T0.[PlannedQty],

T0.[DocNum], T2.[CardName], T0.[DueDate], T1.[ItemCode],
T1.[PlannedQty],T4.[ItemName],T4.[IsCommited], T4.[OnHand],T4.[OnOrder]
order by T2.[DocNum]

Thanks&Regards

Andakondaramudu