I update the table with the following SQL
set Status = 'UPDATE', TermsRef_FullName = 'Net 15', TermsRef_ListID = '80000020-1530827165'
where ListID = '80000004-1389117324'
A record exists in the terms table that matches the information. I don’t get any errors in the error_table, but no changes are made.
The only thing unusual is a series of logs in ‘qbsdklog.txt’ that look like this:
Description: unexpected tag ‘AltContact’.
I just updated OpenSync to the latest version and I recreated a new SQL database. The problem remains.
Can you check on the Trace Update. You can do it by going on the main windows of OpenSync then File->Option. That will generate an xml file after you run that query. Can you email it to me please?
Sorry I haven’t replied to this in so long. I would like to email this to you but I can’t find your email address. I’d rather not post this file publicly since it contains client information.
I would like to send this file to you but I still don’t have a private way to accomplish this. Please advise.
I emailed you.
QuickBooks API doesn’t support ADD, UPDATE or DELETE term table
Thank you for your response. Just to be clear, I’m not trying to update the Terms Table but the Vendor table. I now see that the documentation implies that the terms can in the Vendor table can only be set when the Vendor is added.
That’s unfortunate. 🙁
You must be logged in to reply to this topic.