User Tools

Site Tools


find_gl_on_taxaccouns

Differences

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

Link to this comparison view

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