Knowledgebase
[QODBC-Desktop] Troubleshooting: TimeTracking or Transaction Table is Blank
Posted by Rajendra Dewani (QODBC Support) on 16 October 2012 11:35 AM

Troubleshooting: TimeTracking / Transaction Table is Blank

Problem Description:

The TimeTracking / Transaction table always returns null/ no rows. I tried to reset the QODBC optimizer, but it didn't work.

Solution:

Please update your QuickBooks to the latest version & recheck the issue.

Also, please ensure that the short date format in the Regional Setting is not set to "yyyy mmm dd." If your short date format is "yyyy mmm dd," you might face this issue. 

We have received multiple reports about table TimeTracking not returning any data, and we found that this is usually caused by Corruption in the Company file. To locate your issue, please test the same query on another company file, such as a sample company file, to see if it can bring data back.

Also, try limiting the result set by adding filters and applying a date range.

If the same query can bring data back to other company files, please try rebuilding your company file via File->Utilities->Rebuild Data in QuickBooks to see if it can fix your issue.

Rebuild Company file

And if rebuilding does not work, please get in touch with Intuit for more help.

And if QODBC cannot extract TimeTracking/Transaction data on other company files, please post a ticket to us so we can further investigate the issue.

 

For Advanced Troubleshooting, Click Here

 

(4 vote(s))
Helpful
Not helpful

Comments (6)
John Harrington
22 August 2013 05:47 PM
Still no satisfaction.

I've spent the past day doing the following: 1) confirming that time tracking returns records from another company file, 2) File|Utilities|Verify Data on the problem company file - no problems, 3)File|Utilities|Rebuild Data (anyway) on the problem company file - still no TimeTracking records, 4) Cleaning up data to 12/31/2010, 5) Creating and restoring a portable company file, 6) updating the company file from v11 to v13, and finally, 7) running File Doctor.

I do not think the problem is related to corruption in the company file.
Hartmut von Gaza
28 November 2013 11:21 PM
I am having this problem with QuickBooks 2014 r1 and QODBC 14.00.00.298
Did everything you suggested above. Still no access to the time tracking table.
Kevin Williams
26 February 2014 06:45 PM
Same problem here running QuickBooks 2013 and QODBC 13.00.00.291. Nobody seems to have solved this issue.
Jack
07 July 2014 02:22 PM
Hi John, Hartmut,Kevin,

Please refer steps from Advanced Troubleshooting:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2481

If you are not getting data in QBResponse.xml, then you have to contact Intuit.

I would like to inform you that SDKTestPlus3 is a test tool from Intuit. You can download it from Intuit's website. SDKTestPlus3 does not use QODBC, SDKTestPlus3 & QODBC uses QuickBooks SDK to connect to QuickBooks.
If QuickBooks SDK or QuikcBooks is having issue, SDKTestPlus3 will also fail.

Liz Bawden
29 August 2014 06:17 PM
My Timetracking Transaction Table is blank. I thought it was an excel issue so I bought Access and still no luck. I did a rebuild and everything is fine. Not sure how to get the information to work.
Jack
03 September 2014 10:05 AM
Hi Liz,
Please refer steps from Advanced Troubleshooting:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2481

If you are not getting data in QBResponse.xml, then you have to contact Intuit.

I would like to inform you that SDKTestPlus3 is a test tool from Intuit. You can download it from Intuit's website. SDKTestPlus3 does not use QODBC, SDKTestPlus3 & QODBC uses QuickBooks SDK to connect to QuickBooks.
If QuickBooks SDK or QuikcBooks is having issue, SDKTestPlus3 will also fail.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).