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