query correction

[Former Member]

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

[Rafaee_Mustafa · Accepted solution]

Hi Ramesh,

try this.

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]'
group by T0.[DocNum],T0.[DocDate],  T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity],T1.[OpenQty]

[former_member203816]

Hi Ramesh,

You can also use below query.

SELECT T0.[DocNum],T0.[DocDate],  T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity],

T1.Quantity- T1.OpenQty [Received Qty], T1.[OpenQty]  FROM OPOR T0  INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry

Thanks,

Tushar