projekt kivitendo

  # check tax bookings. all taxkey <> 0 should have tax bookings in acc_trans

  my $query = qq| select trans_id, chart.accno,transdate from acc_trans left join chart on (chart.id = acc_trans.chart_id)

                    (select trans_id from acc_trans where chart_link ilike '%tax%' and trans_id IN

                    (SELECT trans_id from acc_trans where taxkey NOT IN (SELECT taxkey from tax where rate=0)))

                    AND transdate >= ? AND transdate <= ?|;