Hi All,
I need to make a QPLD for GRPO. I have made a query but its getting list of all the GRPO's made in the system when i check i tried the query in SQL.
SELECT T0.[CardCode]'Cust Code', T0.[CardName]'Cust. Name' , T0.[DocNum]'Doc Number', T0.[DocDate] ,
T1.[ItemCode], T1.[Dscription]'Description', T1.[Quantity], T1.[Price], T2.[BuyUnitMsr],
T2.[SalUnitMsr],T1.[LineTotal] FROM OPDN T0 INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode
Can this query be used for QPLD??
Thanks in advance,
Joseph