group by trans_id,invnumber,paid having sum(ac.amount) <> ap.paid|;
my $ap_amount_not_ac_amount = selectall_hashref_query($::form, $self->dbh, $query, $self->fromdate, $self->todate);
group by trans_id,invnumber,paid having sum(ac.amount) <> ap.paid|;
my $ap_amount_not_ac_amount = selectall_hashref_query($::form, $self->dbh, $query, $self->fromdate, $self->todate);