Skip to Content
0
Former Member
Mar 05, 2009 at 06:45 AM

Qpld for GRPO

9 Views

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