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!
Which version of OpenSync and QuickBooks are you using?
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.
Are you able to advise regarding the above. We really need a solution to this.
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.
set [name] = [companyname]
Where datalength([name]) < datalength([companyname])
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.
I understand. My solution is not a fix to the problem, but a work around and additional step to resolve the original issue.
You must be logged in to reply to this topic.