Ramco Ramco

Ramco Ramco

  • 418
  • 3.4k
  • 543.7k

T0.docentry is invalid because of Group By

Dec 21 2024 5:26 AM

Hi

 IN below code i am getting error T0.docentry is invalid because of Group By

SELECT Sum(T0."DpmAmnt")  - (Select Sum(A0."DrawnSum") from ACH9 A0 where A0."BaseDocNum" = T0."DocEntry") As "NetAmount"
FROM ODPR T0 WHERE T0."CardCode"  = 'S04563'