User Tools

Site Tools


find_gl_on_taxaccouns

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%'));
find_gl_on_taxaccouns.txt · Last modified: 2016/04/11 14:44 by sweitmann