If a vendor is throwing errors on the front end, it may be caused by a missing or invalid Zip Codes. Use the script below to find Vendors with this issue
select distinct a.Vendor_Code,
a.GE_Table3_id as "GE_Table3_ID (Zip/Postal Code)"
from AP_Vendor a, GE_Table3 b
Where a.GE_Table3_id not in (select Table3_ID from GE_Table3)
and a.Vendor_Id > 1
Order by a.Vendor_Code
