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