Skip to Content
0
Former Member
Jan 04, 2008 at 07:10 PM

Copy Items and Qtys from one document to another?

21 Views

I have created the following query and added it as a formatted query to the item no. field in the PO.

SELECT T1.[ItemCode], T1.[Quantity], T0.[DocNum]

FROM OQUT T0 INNER JOIN QUT1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.[DocNum] = $[opor.U_QUOTNO] FOR BROWSE

I want to copy multiple lines of items from a Quotation to a PO. What I get is the first line item copied multiple times.

Secondly, I can no long manually select additional items from the Item No. field where the query is attached.

What do I do?

Thanks.

David Eubanks