Vendors with No Address Information (Internal)

If a vendor is throwing errors on the front end, it may be caused by a missing address line. Use this script to find Vendors with this error

 

select Vendor_Code, 

Address_1

from AP_Vendor 

Where Address_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.