International SQL-Ledger Network Association

This is an old revision of the document!

---

1.) Login as admin

2.) Select 'System–Maintainace–Monitor'

3.) Enter SQL-Query:

  
  SELECT reference, transdate, description, notes FROM gl WHERE transdate BETWEEN '2016-01-01' and '2016-12-31'
  AND id IN (SELECT DISTINCT trans_id FROM acc_trans WHERE chart_id IN (SELECT id FROM chart WHERE link LIKE
  '%tax%'));