Call General Report Manager (GRM) tool or use main menu Tools → General Report Manager… .
There are 2 options available.
For MMEX version 1.4.0 there is a possibility to transfer dates into a report's SQL script. There are six options available: &single_date, &begin_date, &end_date, &budget_years, &fin_year_day, &fin_year_month. In case if a SQL contains one of the parameter above it will be replaced with a date from a calendar widget or a value from the MMEX settings. For example, this SQL script returns all accounts balances for the specified date:
with b as (
select ACCOUNTID, STATUS
, (case when TRANSCODE = 'Deposit' then TRANSAMOUNT else -TRANSAMOUNT end) as TRANSAMOUNT
, TRANSDATE
from CHECKINGACCOUNT
union all
select TOACCOUNTID, STATUS, TOTRANSAMOUNT ,TRANSDATE
from CHECKINGACCOUNT
where TRANSCODE = 'Transfer'
)
select a.ACCOUNTNAME,
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;
There are a lot of reports provided by users or developers on GitHub
If you have created any helpful report it may be exported into ZIP file.