OpenSync

Home Forums OpenSync We see invoices deleted for no reason from time to time?

This topic contains 1 reply, has 2 voices, and was last updated by  Yudel Rosales 2 years, 7 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #16156

    rob5
    Premium Member

    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 rob@appsoft.us just in vase we do not get an alert to your response?

    Thank You
    Rob

    #16170

    Yudel Rosales
    Keymaster

    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.

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

You must be logged in to reply to this topic.