Skip to Content
0
Former Member
Mar 02, 2009 at 10:34 AM

Query for GRPO2

16 Views

Hi all,

As per the suggested query;

Select T0.Docnum as Num,T0.U_Gateno as Gate ,T0.Docdate as Date, T0.CardName as Party,

T0.U_Billno as Bill,

T0.DocDate as Date,T1.Dscription as Item,T1.Quantity as Qnty,T1.unitMsr as Unit,T1.Price as Rate,

T1.Linetotal as Amount, T1.Linevat,(T1.Linevat+T1.LineTotal)as Grand

from OPDN T0 INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry

I'm getting the data that i require. However, i require a row total for "(T1.Linevat+T1.LineTotal)as Grand" as well. How can i create a temp table and insert this value so that i can get only one value? Can anyone please suggest an SQL for the same?

Thanks in advance,

Joseph