Re: TimeTracking - Is it a table in Quickbooks or a View?

Method_Jonathan — Mon, 25 Apr 2016 21:27:46 GMT

EndiGrow,

Time tracking records are stored within the TimeTracking table in Method. For QBD, Method retains a specific number of days of transactional history (this is to limit the size of your database). By default, Method only retains the past 31 days of transactions, after which, the transactions are removed from Method (though they will stay in QuickBooks).

If you increase the number of days of transactional history to keep within Method and perform a full sync, you'll find that your transactions from prior months will become visible.

The 'Transactional History' setting can be found via the QuickBooks Tab -> Synchronize Tab Link.

Let me know if you have any further questions about this,

Cheers

Jon

TimeTracking - Is it a table in Quickbooks or a View?

EndiGrow — Fri, 15 Apr 2016 19:32:23 GMT

When we import time records from our tracking utility into Quickbooks, the data shows up in QB for a time until it gets approved and then it is no longer visible via the TimeTracking "table".

I am using the API to import data into a MySQL database. I delete and rebuild the MySQL TimeTracking table during each import.

Now I find the data that was in TimeTracking last month is not there this month.

Where can I find all the data that was visible via TimeRecords in the actual Quickbooks tables?

Method:API Q&A

Re: TimeTracking - Is it a table in Quickbooks or a View?

TimeTracking - Is it a table in Quickbooks or a View?