Update IsBilled to True |
Author |
Message |
JimK |
|
Group | : Members |
Posts | : 34 |
Joined | : 2006-08-08 |
|
Profile |
|
Posted : 2006-09-04 17:13:12 |
When creating an invoice I insert all the unbilled, billable time entries for a Customer/Job. I would then like to mark the entry IsBilled=True in the TimeTracking table. Something to the effect of "Update TimeTracking Set IsBilled=True Where TxnID='12236-1157351682'". I get a 'not supported' error. Whe running a sp_columns on TimeTracking I notice that IsBilled is not updateable. Is there another way around this so I can mark the entry as billed? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-05 09:21:20 |
Sorry, Intuit have only added the ability to modify (update) the TimeTracking table to QuickBooks 2007. You will need to purchase QODBC v7 and QuickBooks 2007 to update the TimeTracking.IsBilled column. |
|
|
|
JimK |
|
Group | : Members |
Posts | : 34 |
Joined | : 2006-08-08 |
|
Profile |
|
Posted : 2006-12-28 16:38:13 |
Tom, now that I have v7 rev 204, I'd like to readdress this question of how I can update time entries. I'm trying to create invoices from clients with time entries and then I want to update those same time entries. The following entry now comes back with the 'error parsing complete XML return string'. Any ideas?
UPDATE TimeTracking SET BillableStatus='HasBeenBilled' WHERE TxnID='1FD69-1165866173'
Thanks as always! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-12-28 20:29:01 |
Sorry, the fix for BillableStatus did not make Build 204, it's still on the to be fixed list under Ticket ID: BR00000035. See: TimeTracking IsBillable Update for more. |
|
|
|
JimK |
|
Group | : Members |
Posts | : 34 |
Joined | : 2006-08-08 |
|
Profile |
|
Posted : 2007-01-16 03:14:56 |
Tom, any ETA on this? I don't want to be a pain, but this is really the only reason I upgraded to the latest versions of QBE and QODBC. It sure would be nice to automate the process of producing 225 (time calculated) invoices each month. Thanks as always! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-01-16 08:15:57 |
Intuit have insisted that we make QODBC work with Vista prior to public release, so much of the last three months has been occupied on the Vista project. This is now complete and hopefully the fourty issues or so I have to be corrected will get addressed. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-04-18 10:18:05 |
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:03 |
|
|
|