If a vendor is throwing errors on the front end, it may be caused by a missing or invalid states. Use the script below to find Vendors with this issue
select distinct a.Vendor_Code ,
a.GE_Table2_id as "GE_Table2_ID (State/Province)"
from AP_Vendor a, GE_Table2 b
Where a.GE_Table2_id not in (select Table2_ID from GE_Table2)
and a.Vendor_Id > 1
Order by a.Vendor_Code
