hi friends,
SELECT T0.[DocNum],T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity],
Sum(T1.Quantity)- Sum(T1.OpenQty ) [Received Qty], T1.[OpenQty] FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[CardCode] =[%0]
kindly correct above query what i mention bold