my $query = qq|(SELECT invnumber,datepaid from ar where datepaid is NOT NULL AND paid = 0
AND id not IN (select trans_id from acc_trans WHERE chart_link like '%paid%' AND acc_trans.trans_id = ar.id)
AND datepaid >= ? AND datepaid <= ?)
my $query = qq|(SELECT invnumber,datepaid from ar where datepaid is NOT NULL AND paid = 0
AND id not IN (select trans_id from acc_trans WHERE chart_link like '%paid%' AND acc_trans.trans_id = ar.id)
AND datepaid >= ? AND datepaid <= ?)