OpenSync

Home Forums OpenSync Vendor Table Name Vs. Companyname

This topic contains 6 replies, has 3 voices, and was last updated by  Mike Miazga 3 months, 3 weeks ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #65426

    Mike Miazga
    Premium 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.
    #65462

    Yudel Rosales
    Keymaster

    Which version of OpenSync and QuickBooks are you using?

    #65592

    David
    Participant

    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.

    #65601

    David
    Participant

    Hi Yudel,

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

    Thank you.

    #65634

    Mike Miazga
    Premium 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])

    #65637

    Yudel Rosales
    Keymaster

    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.

    #65646

    Mike Miazga
    Premium Member

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

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.