Skip to Content
0
Former Member
May 08, 2010 at 04:52 AM

Query

33 Views

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