Call General Report Manager (GRM) tool or main menu - tools - General Report Manager...
There are 2 options available:
There are a lot of reports provided by users or developers on github
with b as (
select ACCOUNTID, STATUS
, (case when TRANSCODE = 'Deposit' then TRANSAMOUNT else -TRANSAMOUNT end) as TRANSAMOUNT
select TOACCOUNTID, STATUS, TOTRANSAMOUNT ,TRANSDATE
where TRANSCODE = 'Transfer'
total(TRANSAMOUNT) + a.INITIALBAL as Balance
from ACCOUNTLIST as a, b
where a.STATUS = 'Open'
and b.ACCOUNTID = a.ACCOUNTID
and b.STATUS <> 'V'
and b.TRANSDATE <= '&single_date'
group by a.ACCOUNTNAME order by a.ACCOUNTNAME asc;