If a vendor is throwing errors on the front end, it may be caused by a missing or invalid city. Use the script below to find Vendors with this issue
select distinct a.Vendor_Code ,
a.GE_Table1_id as "GE_Table1_ID (City)"
from AP_Vendor a, GE_Table1 b
Where a.GE_Table1_id not in (select Table1_ID from GE_Table1)
and a.Vendor_Id > 1
Order by a.Vendor_Code
