Troubleshooting - VehicleMileage table showing deleted records

Problem Description:

I am using QODBC for working with QuickBooks. I can delete the VehicleMileage record. But After that, when I query the VehicleMileage table, it still shows deleted history.

The UNOPTIMIZED query working fine.

Solution:

This issue is related to QuickBooks SDK. QuickBooks SDK is not returning deleted records in TxnDeleted & due to this, QODBC cannot remove the deleted records from the Optimizer.

We have already reported the QuickBooks SDK issue to Intuit.

Until Intuit fixes the issue, we have applied a workaround in QODBC V18.0.0.326 that the VehicleMileage table will directly fetch data from QuickBooks & does not use the Optimizer.

So if you are using QODBC V325 or an earlier QODBC version, then you need to use the "UNOPTIMIZED" keyword in your query to fetch correct records.

For Example:

Select * from VehicleMileage UNOPTIMIZED