query that retrieves the chart of accounts data in SAP Business One and calculates the account balance for each account:

 SELECT 

    T0.AcctCode, 

    T0.AcctName, 

    T0.Levels,

    T1.AcctType, 

    T2.Balance

FROM 

    OACT T0

LEFT JOIN 

    (

    SELECT 

        T1.Account, 

        SUM(T1.Debit - T1.Credit) as Balance

    FROM 

        JDT1 T1 

    INNER JOIN 

        OJDT T2 ON T1.TransId = T2.TransId

    WHERE 

        T2.RefDate <= '[end date]' 

    GROUP BY 

        T1.Account

    ) T2 ON T0.AcctCode = T2.Account

LEFT JOIN 

    OACT T1 ON T0.FatherNum = T1.AcctCode

WHERE 

    T0.FinanseTr = 'Y'

ORDER BY 

    T0.AcctCode