Hi
Incorrect syntax near ''
SELECT
T0.DOCNUM,
T0.DOCENTRY,
T1.LineNum,
T1.ITEMCODE,
(SELECT R4.TaxSum FROM INV4 R4 WHERE R4.staType IN (''-100'') AND R4.RelateType = 1 AND R4.DocEntry = T0.DocEntry AND R4.LineNum = T1.LineNum) AS CGSTAMNT
FROM
OINV T0 INNER JOIN INV1 T1 ON T0.DOCENTRY=T1.DOCENTRY
Thanks