I have tried using MS Access, VBA utility and Alpha 5 to access data in the estimate and estimateline tables.  Whenever I query the tables I get no data back.  I have several records in both tables and I have even tried adding a new estimate and line items, but they do not show up either.  I know I am connected to the correct database because other data I enter shows up.  I can view most main tables, customer, item, employee etc.

I am using the Canadian version of QODBC version 8.0.0.240 with Quickbooks Premium for contractors 2008 (Single user mode with the DB file on a server share).

Please help, as I have tried everything I can think of.

Try running:

Select * from Estimate VERIFY

Ok, using VB Demo, please run:

Select * from Estimate UNOPTIMIZED

and if no data is returned, start the QODBC Setup Screen and in the Messages Tab, "Review QODBC Messages", go to the end and paste the last error message in your reply so I can see what's happening. (Check the SDK Messages also.)

There was no message in the QODBC Messages from today.

The SDK Messages had the following...

20080225.150745 I 3020 CertVerifier The file does not contain an Authenticode signature.

20080225.150745 I 3020 RequestProcessor ========= Started Connection =========
20080225.150745 I 3020 RequestProcessor Request Processor, QBXMLRP2 v6.0
20080225.150745 I 3020 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20080225.150747 I 3020 RequestProcessor Opening the file in the DoNotCare mode.
20080225.150748 I 3676 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3020).
20080225.150748 I 3676 SpecVersion Current version of qbXML in use: 4.0
20080225.150748 I 3676 QBSDKMsgSetHandler QUERY: Host
20080225.150748 I 3676 QBSDKMsgSetHandler Request 1 completed successfully.
20080225.150748 I 3676 QBSDKMsgSetHandler QUERY: Company
20080225.150748 I 3676 QBSDKMsgSetHandler Request 2 completed successfully.
20080225.150748 I 3676 QBSDKMsgSetHandler QUERY: DataExtension Definition
20080225.150748 I 3676 QBSDKMsgSetHandler Request 3 completed successfully.
20080225.150748 I 3676 MsgSetHandler Finished.
20080225.150748 I 3676 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3020), ret = 0.
20080225.150753 I 3676 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3020).
20080225.150753 E 3676 TagDefs Lookup: looking for Tax1Total, but not found!
20080225.150753 W 3676 QBNEstimateQueryRq::AddIncludeRetElement IncludeRetElement specified unknown tag 'Tax1Total'.
20080225.150753 E 3676 TagDefs Lookup: looking for Tax2Total, but not found!
20080225.150753 W 3676 QBNEstimateQueryRq::AddIncludeRetElement IncludeRetElement specified unknown tag 'Tax2Total'.
20080225.150753 E 3676 TagDefs Lookup: looking for ExchangeRate, but not found!
20080225.150753 W 3676 QBNEstimateQueryRq::AddIncludeRetElement IncludeRetElement specified unknown tag 'ExchangeRate'.
20080225.150754 I 3676 SpecVersion Current version of qbXML in use: 6.0
20080225.150754 I 3676 QBSDKMsgSetHandler QUERY: Estimate
20080225.150754 I 3676 EstimateStorage::DoQuery Setting iterator chunk size to 00000500
20080225.150754 I 3676 QBSDKMsgSetHandler Request 1 completed successfully.
20080225.150754 I 3676 MsgSetHandler Finished.
20080225.150754 I 3676 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3020), ret = 0.

I am wondering if it has to do with the new taxes structure in 2008.

You are correct. I've reported this issue to the QODBC Software Engineer under QSupport Ticket ID: BR00000080 for further investigation. There is no time frame set for when I will receive a reply.

In the meantime, you can query the Estimate table by using the column names and the UNOPTIMIZED tag instead of using SELECT *. Just be sure to aviod the Tax and ExchangeRate columns for now. See: How do I create Estimates? for the differences in the Tax columns.

After I suspected this was the case, I tried just what you said SELECT RefNumber FROM Estimate UNOPTIMIZED and I still got 0 records back.

Again, no QODBC Messages, and the SDK Message is as follows...

20080225.170910 I 3972 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 212).
20080225.170911 I 3972 SpecVersion Current version of qbXML in use: 6.0
20080225.170911 I 3972 QBSDKMsgSetHandler QUERY: Estimate
20080225.170911 I 3972 EstimateStorage::DoQuery Setting iterator chunk size to 00000500
20080225.170911 I 3972 QBSDKMsgSetHandler Request 1 completed successfully.
20080225.170911 I 3972 MsgSetHandler Finished.
20080225.170911 I 3972 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 212), ret = 0.

Here's Intuit's reply. Along with a list of other things that are broken:

Yes, this is a known issue. This bug (QBCA001426) is in the list of QB_CA_2008 issues (see below) we recently escalated to QB_CA engineering team. They are actively working on fixing them. We don't have an ETA as of yet but the release of these fixes are likely in a patch release of QB.

Thanks,
- Iqbal

• QBCA001238: CreditCardCreditAdd request in SDK ignores SalesTaxCodeRef
• QBCA001280: ItemReceiptAdd message in SDK does not set sales tax code
• QBCA001356: Sales tax items cannot be added using SDK
• QBCA001384: SDK issue with PayrollWageItemQuery crashes
• QBCA001404: BirthDate is not returned for EmployeeQuery. Both BirthDate and SIN is not showing in QBUI.
• QBCA001410: Error storing field when doing EmployeeAddRq
• QBCA001412: GeneralDetailReportQuery does not return SubtotalRow where applicable
• QBCA001420: billpaymentcheckquery
• QBCA001426: EstimateQuery does not work
• QBCA001429: InventoryAdjustmentQuery does not work as expected
• QBCA001430: ItemReceiptQuery does not work as expected
• QBCA001431: BuildAssemblyQuery is not working as expected
• QBCA001432: CustomDetailReportQuery ignores ReportTxnTypeFilter
• QBCA001435: chargequery
• QBCA001436: purchaseorderquery
• QBCA001437: salesorderquery
• QBCA001438: billpaymentcreditcardquery
  

What do you mean step back to QuickBooks 2007?  This is not even possible once the database has been upgraded.  This is a live database and is changed daily, so we cannot "step back" to a previous version.  Is this not affecting any other users, and why is a resolution taking so long?

Where can one view the status of this bug (QBCA001426)?  I cannot find it on the intuit SDK site.

Tom,

Please forgive my ignorance.  Could you educate me on how I would use the 6.1 SDK to update quickbooks to resolve this issue?  Also,  I have searched the Intuit SDK site thoroughly and cannot find the Canadian 6.1 SDK anywhere.  Do you have this file or a link to it that I could use?

These issues were fixed in the latest update "R4P" which was released today!!!

Hooray.