Yudel, we have determined that a change in the QB database on the BillableStatus field of the TxnExpenseLineDetail table simply does not trigger an update in the OpenSync SQL table. We have found that if we subsequently modify the Memo – by adding a character on the end – then OpenSync will update the record will update in SQL. After it updates the value for BillableStatus matches the value in the QB database. For instance, we had a record which was showing in SQL BillableStatus = Billable, which had been applied to an invoice, therefore should have had value HasBeenBilled. We modified its memo by adding a character. After the next OpenSync refresh, the new memo appeared in SQL, along with the BillableStatus change to HasBeenBilled.
