[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 POS
When there is huge data in QuickBooks POS, QODBC POS cannot pull all data in Table SalesReceipt from QuickBooks POS.
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