Post
Ask Question
Ramco Ramco

Ramco Ramco

  • 441
  • 3.4k
  • 523.1k

Error - Incorrect Syntax

Aug 24 2023 4:12 AM

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

 


Answers (3)