Dear All,
I would like to know if it is possible to report each and every separate purchase order doc num and qty per Item Code across the page in columns as opposed to a 'downward' list such as this report would produce?
SELECT T0.[ItemCode], T0.[Dscription], T1.[DocNum], T0.[OpenQty]
FROM POR1 T0 INNER JOIN OPOR T1 ON T0.DocEntry = T1.DocEntry
WHERE T1.[DocStatus] = 'O'
Example output required
Item No P/o#1Qty P/O#2 Qty P/O#3 Qty
1234 23 2 24 2 25 3
Any solutions gratefully received.
Robin