Skip to Content
0
Former Member
Feb 04, 2011 at 05:13 PM

Q43: How to get Doc Num, Qty, Doc Num Qty going across the page not down

42 Views

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