Hi, need some assistance in correcting an error when UPDATING the Vendor table to Quickbooks using OpenSync. We now receive this error “object variable or with block variable not set” and nothing is updated. We can ADD new vendors to QuickBooks and it works – just can’t seem to update anymore.
I have populated the Vendor table from Quickbooks to the database and it works. But if I add a STATUS of “Update” to any row on the table and try to “Update Quickbooks” ( no other changes to the data) it fails with this error. Really need this corrected.
We have moved our installation to a new server, and updated both Quickbooks and Opensync to the latest version.
Windows Server 2012 R2 Standard. (we are connecting to a remote session)
Quickbooks 2017 Premier Edition
OpenSync 3.0.12 (checking for update says this is the latest version – but it still offers to download every time I check for the update)
I have attached the log files and a Update trace. But I cannot determine the what is generating the error or how to solve it. Any assistance would be helpful. I have searched the forum for fixes to this error – but the few that I found didn’t resolve the issue. I have rebooted, Rebuild the Quickbooks company file and tried a few other things as well.
are those records in QuickBooks already? If those records were modified in QuickBooks, you need to refresh the vendor table before to update the records in QuickBooks. Also, make sure that you are closing QuickBooks.
The first thing I did was to clear the vendor table and did a populate from Quickbooks task. The data in the vendor table all came from quickbooks. But if simply change the status of one row in the vendor table to “update” then I get the error. Do I need to remove the edit sequence or any other data to make the update work? again I can “add” entries from the vendor table to Quickbooks but I cannot update those entries after I have added them