Vendors with No Company names (Internal)

The Company name is a required field. If a vendor is throwing errors on the front end, it may be caused by a blank company name. Use the script below to find all Vendor’s with this issue

 

select Vendor_Code , 

Company_Name

from AP_Vendor 

Where Company_Name = ''

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.