The Script below finds all credits that have an amount of zero or less. This can cause errors on the front end
select a.customer_number, b.credit_number ,
b.Amount
from ar_customer a, AR_Credit b
where a.customer_id=b.customer_id
and a.customer_id<>1
and b.Amount <=0
order by b.credit_number
