Error Expection )

Question

Hi

  Getting error Expection ) at below Select

SELECT
    "RowNo",
    "Account",
    "Debit",
    SUM("Debit" - "Credit") OVER (PARTITION BY Account ORDER BY "RowNo") AS Balance
FROM NumberedRows;

WITH NumberedRows AS (
SELECT
ROW_NUMBER() OVER (PARTITION BY Account ORDER BY A."Account") AS "RowNo",
A."Account" AS "Account",(Select "AcctName" from OACT where "AcctCode" = A."Account") AS "G/l Name",
(A."Debit") AS "Debit", (A."Credit") AS "Credit"
From (

SELECT 
T1."Account" As "Account",T1."BPLId",Sum(T1."Debit") As "Debit",Sum(T1."Credit") As "Credit",T1."TransId",T1."TransType",
CASE
WHEN T1."TransType" = '13' THEN (Select max(A0."LocCode") from INV1 A0 where A0."DocEntry" = T1."CreatedBy")
Else  (Select Max("Location") from OWHS where "BPLid" = Max(T1."BPLId")) END AS "Location"


FROM OACT T0
inner Join JDT1 T1 on T0."AcctCode" = T1."Account"
inner join OJDT T2 on T1."TransId" = T2."TransId"
WHERE T2."RefDate" >= '2020/04/01' AND  T2."RefDate" <= '2020/09/30'  
Group By T1."TransId",T1."TransType",T1."Account",T1."BPLId",T1."CreatedBy"
)A

SELECT
    "RowNo",
    "Account",
    "Debit",
    SUM("Debit" - "Credit") OVER (PARTITION BY Account ORDER BY "RowNo") AS Balance
FROM NumberedRows;

Thanks