SAP B1 Report – Production Order Status for Related Sales Orders

In SAP Business One, you have the ability to link Product Orders to Sales Orders. Additionally, at release 8.82 of SAP Business One, the Procurement Confirmation Wizard can automatically create Production Orders directly from Sales Orders, or after Sales Orders have been posted. However, this is not a report that list all Production Orders associated to Sales Orders. Here is a report that lists all production orders for open sales orders.

SELECT
T1.[DocNum] AS ‘Work Order’,
T0.[DocNum] AS ‘Sales Order’,
T0.[NumAtCard] AS ‘Cust PO No’,
T0.[CardCode], T0.[CardName],
T1.[ItemCode], T1.[Status],
T1.[PlannedQty],
T1.[CmpltQty],
T1.[RjctQty],
T1.[DueDate]
FROM ORDR T0 INNER JOIN OWOR T1 ON T0.CardCode = T1.CardCode AND T0.DocNum = T1.OriginNum
WHERE T0.[DocStatus] = ‘O’

Simply paste the query above into the query generator from the SAP Business One toolbar and you are good to go.