Knowledgebase: QODBC
[QODBC-Desktop] Troubleshooting - VehicleMileage table showing deleted records
Posted by Jack - QODBC Support on 05 April 2018 12:06 PM

Troubleshooting - VehicleMileage table showing deleted records

Problem Description:

I am using QODBC for working with QuickBooks. I am able to delete the VehicleMileage record. But After that when I query VehicleMileage table it still showing deleted record.

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 QuickBooks SDK issue to Intuit.

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

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

For Example:

Select * from VehicleMileage UNOPTIMIZED

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).