Here is the scenerio.
An invoice is created in MySQL, then synced with update, then it appears one of our accountants modifies this invoice manually within Quickbooks (the program), then another update happens thru open synm for the same invoice, then we see an error in the opensync log that the record has been modified already, anf then we see in the Quickbooks log that it has been deleted by the system.
So in summary it appears that if we manually modify a invoice after it was put in Quickbooks by opensync it gegts deleted for some reason.
This is a great concern for us.
Could you also email your response to firstname.lastname@example.org just in vase we do not get an alert to your response?
each time that you update a record on QuickBooks you should refresh your database in order to update the “EditSequence” value. This is how it works. If the EditSequence number in the database is lower that the one in QuickBooks, OpenSync won’t update QuickBooks because we consider QuickBooks as a master database. if you want to avoid that, you can set the EditSequence value to null, we don’t recommend it because you can lose info. We never delete record from QuickBooks at least you set the status column to DELETE. If the record is getting delete from QuickBooks, most likely someone is deleting. you can check that on QuickBooks. Open the company file and go to Reports->Accountant & taxes->Audit Trail. let me know how you make it out.
You must be logged in to reply to this topic.