TimeTracking IsBillable Update |
Author |
Message |
Bill |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-11-02 |
|
Profile |
|
Posted : 2006-11-02 05:07:11 |
I am trying to set the IsBillable Field in the TimeTracking Table to false. I am using version 7 (evaluation) of the QODBC Driver and Quickbooks pro 2006. I am using VB6 and ADO. I can get the recordset I an interested in and the values appear to be correct. I then change the IsBilable field value to 0 for the record. When I attempt to do the update I get the following message in the QODBC Log:
"IsAService: False SQL Statement: UPDATE "QODBC"."TimeTracking" SET "IsBillable"=? WHERE "TxnID"=? AND "IsBillable"=? Error Modify not supported on this table in BuildXMLHeader
Can you tell me what I am doing wrong?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-02 10:53:01 |
The TimeTracking table cannot be updated (modified) using QuickBooks 2006. You can only create (INSERT) new records. To update the TimeTracking table you need to be using QuickBooks 2007 (USA Edition). |
|
|
|
Bill |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-11-02 |
|
Profile |
|
Posted : 2006-11-09 05:56:41 |
Tom,
I have installed Quickbooks Pro 2007. Now when I attempt to set the BillableStatus Field I get an XML Parsing Error. I have tried to set it with a string variable set to "NotBillable" and a variant set to 1 with the same results.
The QODBC Log Contains:
2006-11-08 11:54:33 QODBC Ver: 7.00.00.199 *********************************************************************************************************************************** IsAService: False SQL Statement: UPDATE "QODBC"."TimeTracking" SET "BillableStatus"=? WHERE "TxnID"=? AND "BillableStatus"=? 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>246A-1012002951</TxnID> <EditSequence>1012002951</EditSequence> <BillableStatus>1</BillableStatus> </TimeTrackingMod> </TimeTrackingModRq> </QBXMLMsgsRq> </QBXML> Bill |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-09 10:36:37 |
You are correct:
UPDATE TimeTracking SET "BillableStatus"='NotBillable' WHERE "TxnID"='687-933358111'
fails with:
20061108.154351 I 3152 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2076). 20061108.154351 E 3152 XercesSAXErrorHandler Element 'BillableStatus' is not valid for content model: '(TxnID,EditSequence,TxnDate?,EntityRef,CustomerRef?,ItemServiceRef?,Rate?,Duration,ClassRef?,PayrollItemWageRef?,Notes?,BillableStatus?)' -- error at line 7, column 133 in XML data. 20061108.154351 I 3152 MsgSetHandler Parser error, finishing. 20061108.154351 I 3152 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2076), ret = 1. 20061108.154351 E 2076 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file.
2006-11-08 15:43:51 QODBC Ver: 7.00.00.199 *********************************************** IsAService: False SQL Statement: UPDATE TimeTracking SET "BillableStatus"='NotBillable' WHERE "TxnID"='687-933358111' Error parsing complete XML return string (8)
This problem has been reported to the QODBC Software Engineer for resolution. |
|
|
|
Bill |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-11-02 |
|
Profile |
|
Posted : 2006-11-21 23:23:43 |
Tom, Could you please provide me an update on the status of this item? Thanks Bill |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-22 08:46:55 |
A QSupport HelpDesk Priority Support Ticket ID: BR00000035 was assigned on 09 Nov 2006 09:06:14 to this issue and the fix will appear in QODBC v7.00.00.201 or later. |
|
|
|
JimK |
|
Group | : Members |
Posts | : 34 |
Joined | : 2006-08-08 |
|
Profile |
|
Posted : 2006-11-29 08:59:03 |
Tom, any idea on the timing of v7.00.00.201? I was anxiously awaiting the upgrade of QBE and QODBC for this very reason (being able to update the BillableStatus field of a TimeTracking entry) so that I could create invoices in a batch. I'm obviously getting the identical error so I'd like to see a resolution.
Thanks as always! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-29 09:17:26 |
I just checked and it hasn't been fixed yet in Build 204. Sorry. |
|
|
|
JimK |
|
Group | : Members |
Posts | : 34 |
Joined | : 2006-08-08 |
|
Profile |
|
Posted : 2007-02-03 06:14:12 |
Tom,
The following statement still does not work with build 207 (same parsing error). Do you have an estimate on when this fix will 'make the cut'? Thanks.
UPDATE TimeTracking SET "BillableStatus"='NotBillable' WHERE "TxnID"='687-933358111' |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-02-03 10:35:15 |
No, I have over 40 tickets to be attended to and we are also going to make a big change in the optimizers operation. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-04-18 10:20:14 |
Further work was done in QODBC v7.00.00.214 to fix this however I found that while no error messages are no longer returned, this update statement:
UPDATE TimeTracking SET BillableStatus='HasBeenBilled' WHERE TxnID='5C08-1197761584'
didn't actually change the record in QuickBooks. The workaround is to include EntityRefListId (or EntityRefFullName) and DurationMinutes in the update set section to update any other fields as shown below. This will be fixed in QODBC v7.00.00.215 or higher.
SELECT BillableStatus, EntityRefFullName, DurationMinutes FROM TimeTracking WHERE TxnID='5C08-1197761584'
UPDATE TimeTracking SET EntityRefFullName='Dan T. Miller', DurationMinutes=7200, BillableStatus='HasBeenBilled' WHERE TxnID='5C08-1197761584'
SELECT BillableStatus, EntityRefFullName, DurationMinutes FROM TimeTracking WHERE TxnID='5C08-1197761584'
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-08-08 09:39:24 |
|
|
|