OpenSync

Home Forums OpenSync Customer not linked to Estimate after OpenSync runs

Tagged: 

This topic contains 6 replies, has 4 voices, and was last updated by  Yudel Rosales 4 years, 9 months ago.

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

    michael4
    Participant

    I’m creating my customer and estimate in MySQL and then running OpenSync to update QB with the relevant information. My update fails and gives me the following error message: List entry not found: [Customer Info].

    I think my estimate and customer are out of sync somehow, any help would be appreciated, thanks.

    #16804

    Yudel Rosales
    Keymaster

    Which version of OpenSync are you running?
    Also, Can you post your log files right after running the task please?

    #16816

    michael4
    Participant

    2.0.81.

    WorkTracker – Init
    WorkTracker – Starting task: sync
    BackWorker – ExecuteBackground Begin
    BackWorker – MakeQbConnection Opened
    BackWorker – FullSynch
    BackWorker – Update table Customer
    BackWorker – Update table Estimate
    BackWorker – Update table Sales Order
    BackWorker – OpenSync does not support updating this table: Entity
    BackWorker – Refresh table Customer
    BackWorker – Refresh table Estimate
    BackWorker – Refresh table Sales Order
    WorkTracker – Update detected 39 errors. Check error table for details
    BackWorker – CloseQbConnection: Close Connection
    BackWorker – ExecuteBackground Complete
    OpenSync:Runner – ErrorExit: Update detected 39 errors. Check error table for details.

    Note: The errors in the error table look like the ones I mentioned in my original post

    #16838

    Yudel Rosales
    Keymaster

    Can you post your log files right after running the task please?

    #16879

    Tom Crawford
    Keymaster

    If you are trying to add the customer and estimate at the same time then you need to specify the CustomerRef_FullName in the estimate table and not the CustomerRef_ListID as that will change once the customer is added to QB. If the customer already exists in QB then make sure either the CustomerRef_ListID or CustomerRef_FullName match what is in the customer table.

    #16907

    Pavel Brun
    Premium Member

    This is good to know….CustomerRef_FullName would be the same as “FullName”?

    #16944

    Yudel Rosales
    Keymaster

    yes, it is

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

The forum ‘OpenSync’ is closed to new topics and replies.