[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
The TimeTracking / Transaction table always returns null/ no rows. I tried to reset the QODBC optimizer, but it didn't work.
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.
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