I am using MS ACCESS form to enter a bill. Syncing is working fine with existing vendor. I encountered a problem when syncing bill and 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.