T0.docentry is invalid because of Group By

Ramco Ramco

1y710SQL

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'

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar1y ago

Accepted answer

Hello Ramco,

Please use the below query to make it work as expected..

SELECT 
    SUM(T0."DpmAmnt") - 
    COALESCE((SELECT SUM(A0."DrawnSum") FROM ACH9 A0 WHERE A0."BaseDocNum" = T0."DocEntry"), 0) AS "NetAmount"
FROM 
    ODPR T0
WHERE 
    T0."CardCode" = 'S04563';