Customer not linked to Estimate after OpenSync runs

[michael4Participant]

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.

[Yudel RosalesKeymaster]

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

[michael4Participant]

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

[Yudel RosalesKeymaster]

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

[Tom CrawfordKeymaster]

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.

[Pavel BrunPremium Member]

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

[Yudel RosalesKeymaster]

yes, it is

[Author]

Posts