Knowledgebase
[QODBC-POS] Not able to pull all data in Table SalesReceipt from QuickBooks POS
Posted by Rajendra Dewani (QODBC Support) on 17 April 2014 11:53 AM
|
|
Not able to pull all data in Table SalesReceipt from QuickBooks POSProblem Description:When there are huge data in QuickBooks POS, QODBC POS not able to pull all data in Table SalesReceipt from QuickBooks POS. Solution:1.When there are huge data in QuickBooks POS, QODBC/QB SDK may fail to get all data at once and you would need to add filters: SELECT * FROM SalesReceipt WHERE TxnDate>'YourDate' and TxnDate<'YourDate' Please use the exact time to filter, use TxnDate instead of TimeModified. 2. Need to change the iterator to 500 or 2000 via QODBC POS setup screen -> Advanced tab 3. Enable optimizer via QODBC POS setup Screen -> Optimizer tab See Also: How are dates formatted in SQL queries when using the QuickBooks generated timestamps | |
|
Comments (0)