Not able to pull all data in Table SalesReceipt from QuickBooks POS

Problem 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