SAP Business One Tip- Drill down on Back Orders based on Sales Order Rows

 

The query below will let you create a query based report that will list all Sales order Rows that have a back order associated and let you drill down into the details as well.  This is fast and simple.  Just copy and paste into your query generator

 

Query Generator – Back Order Sales Drill Down report by Sales Order Row

SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[OpenQty], T0.[CardCode], T0.[CardName]
FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[LineStatus] = ‘O’ ORDER BY T0.[DocDate]

2019-01-16T11:24:28+00:00 February 16th, 2013|SAP Business One|Comments Off on SAP Business One Tip- Drill down on Back Orders based on Sales Order Rows