The script below can be used to find credit entries with negative amounts or zero dollar amounts
select b.Credit_Number,
a.Vendor_Code, b.Amount
from AP_Vendor a, AP_Credit b
Where b.Vendor_Id = a.Vendor_Id
and b.Amount <= 0.00
and b.Credit_id >1
Order by a.Vendor_Code, b.Credit_Number
