Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWhat table are employees hours worked stored? Trying to use QODBC and Microsoft Access together. I can link to the Employee table just fine. I can run Employee Earnings Summary and see the hours worked on a particular day but where to find that information in table form? Is it "Time Tracking"? If so, I can never import or link that. It causes Access to stop responding.
Hi there, jimbofoxman.
Thanks for reaching out to us. I want to make sure you get the right support you need.
We do have a separate forum where you can get help with integrations. You can visit our Intuit Developer Community Site. They'll be the best experts to handle this concern and share insights about integrations about QODBC and Microsoft Access.
You can raise your questions by visiting our Intuit Developer portal through this link: https://developer.intuit.com/us.
If there's anything else I can assist you with, please don't hesitate to leave me a reply below.
You asked a mix of things:
"I can run Employee Earnings Summary"
That's Paycheck data. That's pay period based. For each Date, you can run More Reports in Excel for Employee Time & costs as Projected paycheck data in Excel format.
"and see the hours worked on a particular day but where to find that information in table form? Is it "Time Tracking"?"
Yes. It isn't Timesheets. It is Time Records. Each Time Record or task is Stand Alone. The Single-Activity view shows it. The Weekly view Presents it in that combined perspective.
Here:
https://doc.qodbc.com/qodbc/usa/
https://doc.qodbc.com/qodbc/usa/Relation.php?tableName=TimeTracking
https://doc.qodbc.com/qodbc/usa/Jumpins.php?tableName=TimeTracking
https://doc.qodbc.com/qodbc/usa/TableDetails.php?tableName=TimeTracking
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.