I am using MS ACCESS form to enter a bill. Syncing is working fine with existing vendor. I encountered a problem when syncing new bill and new vendor together. When I run sync, Vendor gets added to vendor list but bill got an error (error msg shows the IDKEY not matched). I figured out the problem, It was quickbooks assigned the new vendor _listid to the vendor after the sync and bill was having old vendor List id (initial). It also changed the STATUS column to ERROR. upon next sync this transaction will not be uploaded because of missing STATUS column is Error instead of ADD.
I tired to choose option for clear STATUS column on success. It leaves the status ADD on bill but wipes out the vendor from bill table record. which is hard to find later.
Please suggest a solution which enable me add both Vendor and Bill without additional steps every time.
Here’s a thought. Rather than having OpenSync processing tables alphabetically (Bill comes before Vendor), why not process all the static tables first (Account, Customer, Employee, Item, Vendor), and THEN process the transactions? That would eliminate this pesky issue.
Could this change be that hard to program?
we will look into that change. Thanks for the recommendation.
You must be logged in to reply to this topic.