Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
possible bug "sp_report CustomTxnDetail" ModifiedDateFrom and ModifiedDateTo |
Author |
Message |
|
Posted : 2007-09-03 12:22:57 |
Please see below logs created from QODBC and Quickbookm SDK for the possible bug about the modified date from and to filter.
" </ReportModifiedDataRangeFilter> " maybe should be "</ReportModifiedDateRangeFilter>"
Wiht best regards, Rodney
2007-09-01 15:20:55 QODBC Ver: 6.00.00.176 ************************************************************************
IsAService: False
SQL Statement: sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, ItemDesc, ModifiedTime, Quantity, Amount parameters ModifiedDateFrom = {d'2007-08-01'}, ModifiedDateTo = {d'2007-08-30'}, SummarizeRowsBy = 'TotalOnly', AccountFilterType = 'CostOfSales' , TxnFilterTypes = 'Invoice'
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?> <?qbxml version="4.0"?> <QBXML> <QBXMLMsgsRq onError="continueOnError"> <CustomDetailReportQueryRq requestID="1"> <CustomDetailReportType>CustomTxnDetail</CustomDetailReportType> <ReportAccountFilter> <AccountTypeFilter>CostOfSales</AccountTypeFilter> </ReportAccountFilter> <ReportTxnTypeFilter> <TxnTypeFilter>Invoice</TxnTypeFilter> </ReportTxnTypeFilter> <ReportModifiedDataRangeFilter> <FromReportModifiedDate>2007-08-01</FromReportModifiedDate> <ToReportModifiedDate>2007-08-30</ToReportModifiedDate> </ReportModifiedDataRangeFilter> <SummarizeRowsBy>TotalOnly</SummarizeRowsBy> <IncludeColumn>TxnType</IncludeColumn> <IncludeColumn>Date</IncludeColumn> <IncludeColumn>RefNumber</IncludeColumn> <IncludeColumn>Name</IncludeColumn> <IncludeColumn>ItemDesc</IncludeColumn> <IncludeColumn>ModifiedTime</IncludeColumn> <IncludeColumn>Quantity</IncludeColumn> <IncludeColumn>Amount</IncludeColumn> </CustomDetailReportQueryRq> </QBXMLMsgsRq> </QBXML>
20070901.152055 I 688 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3752).
20070901.152055 E 688 XercesSAXErrorHandler Unknown element 'ReportModifiedDataRangeFilter' -- error at line 13, column 34 in XML data.
20070901.152055 I 688 MsgSetHandler Parser error, finishing. 20070901.152055 I 688 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3752), ret = 1.
20070901.152055 E 3752 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-03 15:15:34 |
Actually this was corrected in QODBC v7. Your query actually runs without error:
sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, ItemDesc, ModifiedTime, Quantity, Amount parameters ModifiedDateFrom = {d '2000-08-01'}, ModifiedDateTo = {d'2010-08-30'}, SummarizeRowsBy = 'TotalOnly', AccountFilterType = 'CostOfSales' , TxnFilterTypes = 'Invoice'
However, the report query fails to return rows as can be seen here.
Running the query without the ModifiedDateFrom and ModifiedDateTo parameters shows the ModifiedTime rows that should appear:-
sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, ItemDesc, ModifiedTime, Quantity, Amount parameters SummarizeRowsBy = 'TotalOnly', AccountFilterType = 'CostOfSales' , TxnFilterTypes = 'Invoice'
I've reported this bug to the QODBC Software Engineer for further investigation. I don't have a time frame at this stage when this will be corrected. |
|
|
|
|
Posted : 2007-09-03 16:35:36 |
Thanks Tom, will it be possible to notify me once this issue is resolve? I need to be able to use the time modified method to lessen the time needed to extract data. |
|
|
|
|
Posted : 2007-09-04 11:26:52 |
By the way , If I upgrade QODBC to the newest version, will it affect my license? I'm still using Quickbook enterprise ver 2005. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-25 10:25:25 |
|
|
|
|
Posted : 2007-10-02 19:31:42 |
Going back to this issue: I downloaded and installed the latest version of QODBC v8.00.00.234.
When I executed below SQL statement using the VB demo, I can now retrieve records. But the problem is, the records retrieved are from the time I installed the new version of QODBC which is from 10/01/2007 and onward.
sp_report CustomTxnDetail Unoptimize show TxnType, Date, RefNumber, Name, Item, ItemDesc, ModifiedTime, Quantity, Amount parameters ModifiedDateFrom = {d'2007-09-15'},ModifiedDateTo = {d'2007-10-10'}, SummarizeRowsBy = 'TotalOnly', AccountFilterType = 'CostOfSales' , TxnFilterTypes = 'Invoice' , 'SalesReceipt'
I tried "nosync" aside from "Unoptimize" settting, but stil cannot get records prior to 10/01/2007.
Any suggestion, Tom?
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-03 06:45:37 |
Try re-running the query without the ModifiedDateFrom and ModifiedDateTo parameters to see what's really there??:-
sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, ItemDesc, ModifiedTime, Quantity, Amount parameters SummarizeRowsBy = 'TotalOnly', AccountFilterType = 'CostOfSales' , TxnFilterTypes = 'Invoice' |
|
|
|
|
Posted : 2007-10-03 14:16:26 |
Tried it without the modified date from and modified to-unoptimize, and still getting the same result. records returned are from 10/1 onward, and not a single record prior to 10/1. I used VB Demo for the test, accessing live production data from QuickBook which have transactions way back 1998.
10/1 is exactly the day I installed the new version of QODBC. |
|
|
|
|