Instruction:

When you want to insert multiple records into a line item table, you can use column FQSaveToCache.

Set column FQSaveToCache to 1 in all insert queries except the last line set to 0. But table TimeTracking is not a line item table; there is no FQSaveToCache column in that table.

So you need to use the alternate method. This article will show you how to use the sp_batch command to insert multiple records into TimeTracking.

If you are not familiar with the sp_batch statement, please refer to This article for more information.

First, please run:

SP_BATCHCLEAR Timetracking

This command will remove all cached data from the TimeTracking table. It will make sure only the queries below will be executed.

Note:  QODBC Support Wizard is used to test QODBC SQL queries only and is not a development tool.

Then run this query to start the batch:

SP_BATCHSTART Timetracking

When this query is executed, all queries later will be stored into the cache instead of directly sending to QuickBooks

Then run your insert queries. Here we use our test company file as an example:

INSERT INTO TimeTracking (EntityRefListID, DurationMinutes, TxnDate, CustomerRefFullName, ItemServiceRefFullName, PayrollItemWageRefFullName) Values ('60001-1039046236',540, {d'2022-01-06'},‘'Kim:Garland'’,'Installation Labor','Sick -Salary')

INSERT INTO TimeTracking (EntityRefListID, DurationMinutes, TxnDate, CustomerRefFullName, ItemServiceRefFullName, PayrollItemWageRefFullName) Values ('F0002-1039046343',600, {d'2022-01-06'}, ‘'West:Test'’,'Installation Labor','Sick -Salary')

After all insert queries are executed, upload all cached queries to QuickBooks using this command:

SP_BATCHUPDATE Timetracking

This query will upload all queries in the cache to QuickBooks.