A glitch in the system may cause the amount used on a credit to be higher than the amount allocated in the first place. This can cause problems on the customer’s balance due. The script below finds those credits
select a.customer_number, b.credit_number,
b.Amount, Used_Amount
from ar_customer a, AR_Credit b
where a.customer_id=b.customer_id
and a.customer_id<>1
and b.Used_Amount > Amount
order by b.credit_number
