User Tools

Site Tools


find_gl_on_taxaccouns
no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


find_gl_on_taxaccouns [2016/04/11 14:44] (current) – created sweitmann
Line 1: Line 1:
 +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