No Data is Returned from Estimate table |
Author |
Message |
|
Posted : 2008-02-23 10:38:27 |
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. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-24 23:13:22 |
Try running:
Select * from Estimate VERIFY |
|
|
|
|
Posted : 2008-02-26 06:56:08 |
I ran this in the VB Demo utility and it returned nothing :(. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-26 07:45:33 |
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.)
|
|
|
|
|
Posted : 2008-02-26 09:11:46 |
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. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-26 10:17:21 |
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. |
|
|
|
|
Posted : 2008-02-26 11:13:32 |
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.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-26 12:01:57 |
Looks like the XML parsing is also broken, sorry. This appears to be an open Intuit qbXML SDK issue in the UK version of QuickBooks 2008 and we think it's the same issue here with the Canadian version of QuickBooks too. There is a setting in QODBC v8.0.0.242 that allows you to turn off the field list with SendFieldList=No in the odbcinst.ini file but that only removes the warning message you are seeing and you still won't get estimates returned. We have written this problem up as an SDK bug and posted the incident with Intuit as IDN support incident #688539. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-03-01 07:20:38 |
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
|
|
|
|
|
Posted : 2008-03-18 02:23:02 |
Where can I go or who can I contact to find the status of this bug (QBCA001426)? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-03-18 10:45:59 |
You need to contact Intuit directly. |
|
|
|
|
Posted : 2008-04-24 06:04:40 |
This issue has not been resolved despite Intuit saying it would be incorporated into the next patch. This is one of the major reasons I purchased QODBC (to use the estimate tables) is there nothing you can do to assist in getting this resolved? It has now been 2 months with no resolution, and I am thinking I may have to look at some other option to use the estimate data. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-04-24 09:09:35 |
The only other workaround is to step back to QuickBooks 2007 and not use QuickBooks 2008 to begin with. I understand a number of fixes have been made in the 6.1 version of the SDK. I'm obtaining the Australian version of the SDK this week and will have a look if Estimate queries now work or not. |
|
|
|
|
Posted : 2008-04-25 01:55:09 |
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 |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-04-28 17:53:00 |
You need to obtain a 6.1 SDK update directly from Intuit Canada. QuickBooks requires the fixes in SDK release 6.1. |
|
|
|
|
Posted : 2008-05-09 00:42:52 |
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? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-05-09 07:53:07 |
The SDK components would be normally be updated during a QuickBooks update. |
|
|
|
|
Posted : 2008-05-15 08:20:14 |
These issues were fixed in the latest update "R4P" which was released today!!!
Hooray. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-06 16:33:23 |
|
|
|