projekt kivitendo

  my $query = qq|

          select sum(ac.amount) as paid_amount, ar.invnumber,ar.paid

          from acc_trans ac left join ar on (ac.trans_id = ar.id)

          AND ac.trans_id in (SELECT trans_id from acc_trans ac where ac.transdate >= ? AND ac.transdate <= ?)

          group by invnumber, paid having sum(ac.amount) <> ar.paid*-1|;