Vendors with Invalid Country (Internal)

If a vendor is throwing errors on the front end, it may be caused by a missing or invalid Country. Use the script below to find Vendors with this issue

 

select Vendor_Code, 

Country_Id

from AP_Vendor 

Where Country_Id = 1

and Vendor_Id > 1

Order by Vendor_Code

Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.