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