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]