Vendor.name truncated to 11 characters on populate

[afarabeeParticipant]

OpenSync v3.0.18
Quickbooks 2018 Enterprise
Windows 10

Populating database from company file truncates around 300 of our 2100 vendors’ names to 11 characters.
Refreshing changes to vendor updates individual vendor names, but they still are missing 1 character at the end. The correct vendor name is in the XML log.

[Yudel RosalesKeymaster]

That shouldn’t happen. It has enough character assigned. Can you send me the log files please? To do so on the main windows click on Help->Send Diagnostics.
Best Regards,

[AndrewParticipant]

I figured it out, OpenSync 3.0.18 creates a default SQL database with vendor.name as varchar(31), but quickbooks allows for vendor names longer than 31 characters. Changing the datatype of that column and repopulating the vendor table corrects all the names.

[PatriciaParticipant]

Andrew – is it the datatype of the the vendor name that you changed or the size of the field?

[Yudel RosalesKeymaster]

Hello Patricia

If you are having the same problem, you can change manually. This issue will be fixed on the next update, but it will only apply for new database. Current databases will have to be fixed manually.

Sorry for the inconveniences.

Best Regards,

[Author]

Posts