Blog

SAP B1 Report – Production Order Status for Related Sales Orders

By Ryan Howe

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.

Ryan Howe

Ryan Howe

Partner, Clients First Business Solutions New Jersey

Ryan Howe is a Certified Public Accountant turned SAP Business One consultant. Leading the SAP Business One practice at Clients First, Ryan has over 23 years’ experience in the financial management and ERP industry, specializing in business analysis, relationship building, and business process optimization. When he’s not helping customers leverage SAP Business One to meet their short and long-term needs, you can find him at any Michigan State sporting event with his family – go Spartans!