Hi Abenaki, I'm experiencing the same challenge here, were able to resolve the issue?

Hi Abenaki, I'm experiencing the same challenge here, were able to resolve the issue?

Hi, I had to have the data repaired.

How did you repair your data?

I see this stuff all the time  the vendor code in Sage 300 database problem has an unprintable character or a single quote (which has a special meaning to SQL commands

if you are not technical then something like Musick Fixit software will check for bad characters in the field in all appropriate tables

If you are technical then you can fix with a whole bunch of SQL commands for all tables where you edit VENDORID in record

if technical a little;   to confirm code has an unprintable character then edit vendor master in SQL and find record and on the VENDORID field go into it on the right side of the value and backspace - you will see that you press backspace once and the cursor did not move - this is because you deleted an invisible character like linefeed or whatever - escape out of the field so you do not chg it

but this has to be fixed in every table that has vendorid for the messed up vendor so don't hack around too much