Hi
SELECT M.DocNum AS 'AP Inv. #', M.DocDate as 'Date', (SELECT Sum(TaxSum) FROM INV4 where statype=-90 and DocEntry=M.DocEntry) as 'ED (Rs.)',
(SELECT Sum(TaxSum) FROM INV4 where DocEntry=M.DocEntry) as 'Tax Total(Rs.)',
M.DocTotal as 'Invoice Total (Rs.)'
FROM OINV M Inner JOIN INV1 L on L.DocEntry=M.DocEntry AND L.Excisable=u2019Yu2019
Inner JOIN INV4 T on T.DocEntry=L.DocEntry
WHERE M.DocDate BETWEEN '[%0]' AND '[%1]'
GROUP BY
M.DocNum,M.DocDate,M.DocEntry, M.DocTotal ORDER BY
M.DocNum,M.DocDate,M.DocEntry
This statement is giving error after i have added this line AND L.Excisable=u2019Yu2019
What is wrong with tis statement
Thanks