Ramco Ramco

Ramco Ramco

  • 431
  • 3.5k
  • 562.6k

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' 

 


Answers (1)