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'