This error message can occur if you enter a leading space into the vendor code/company name.
It is easy to spot there’s a leading space since if you search for the vendor generically enough, the first letter does not line up with the other items returned by the search.
The resolution is with SQL since the vendor information cannot be edited from the front end.
First, query ap_vendor to get the vendor_id:
Select * from ap_vendor where vendor_code like ‘%name%’
It is important to use a like query here. Otherwise, you will get no results due to the leading space.
Once you have the vendor_id, you can update the ap_vendor table with the following:
Update ap_vendor
set vendor_code = ‘name’, company_name = ‘name
Where vendor_id = ‘insert id here’
