Vendor Table Name Vs. Companyname

[Mike MiazgaPremium Member]

I have an issue with my vendor table sync in that the ‘name’ field and the ‘companyname’ field are different, and it seems it’s cutting off part of the ‘name’ field, or leaving the ‘companyname’ field null. See the picture uploaded. I need the full name in the name field, I don’t see different fields in quickbooks in which to have one or the other so I can’t figure out why this is happening. help please!

Attachments:

You must be logged in to view attached files.

[Yudel RosalesKeymaster]

Which version of OpenSync and QuickBooks are you using?

[DavidParticipant]

Hi Yudel,

We are having the same issue where long names are getting cut off at 11 characters. We are using version 3.0.25 of OpenSync.

We did not previously have this issue when using version 2 so we know it is not a limitation from Reckon Accounts.

[DavidParticipant]

Hi Yudel,

Are you able to advise regarding the above. We really need a solution to this.

Thank you.

[Mike MiazgaPremium Member]

I came up with a SQL statement to replace the column I need with the longer of the two columns. I don’t know what changed or why this is happening, but running this statement after the data sync fixes the issue for me. It only replaces name if companyname is longer, otherwise no change.

update vendor
set [name] = [companyname]
Where datalength([name]) < datalength([companyname])

[Yudel RosalesKeymaster]

Thanks for your recommendation Mike on this issue. But I really don’t know why is cutting the name because the field has 41 chars assigned.

[Mike MiazgaPremium Member]

I understand. My solution is not a fix to the problem, but a work around and additional step to resolve the original issue.

[Author]

Posts