I am trying to update the TimeTracking table to correct an error where items were not included in the initial records. I have tried variour queries to no avail. Here is a very simple update statement that fails:

update TimeTracking set ItemServiceRefFullName = '2:Field OPS & PMO Mgr' where EntityRefFullName = 'Stephen Gress'

Here is the log info:

2007-03-23 17:11:56 QODBC Ver:  7.00.00.207 *********************************************************************************************************************
IsAService: False
SQL Statement: update TimeTracking  set ItemServiceRefFullName = '2:Field OPS & PMO Mgr' where EntityRefFullName = 'Stephen Gress'
Error parsing complete XML return string (8)
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "continueOnError" responseData = "includeNone">
        <TimeTrackingModRq requestID = "1">
            <TimeTrackingMod>
                <TxnID>51128-1174308481</TxnID>
                <EditSequence>1174487244</EditSequence>
                <ItemServiceRef>
                    <FullName>2:Field OPS &amp; PMO Mgr</FullName>
                </ItemServiceRef>
            </TimeTrackingMod>
        </TimeTrackingModRq>
    </QBXMLMsgsRq>
</QBXML>

I have also tried inserting the job number in the ItemServiceRefListID table (and a combination of both the name and the ID), but nothing will work. I continually get the "Error parsing complete XML return string (8)" error. Please help! The ability to update records in the TimeTracking table is one of the reasons that we purchased this product. Thanks!

There's currently a bug when using QODBC v7 and QuickBooks 2007 with the TimeTracking table. Intuit changed the structure of that table for QuickBooks 2007 and the internal coding in QODBC isn't right. The problem affects all updates to that table when using QuickBooks 2007 (SDK 6.0). It's reference Ticket No. is BR00000035 Dated 09 Nov 2006 09:06:14 if you want to raise the matter directly with your local sales office.