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 POS

Problem Description:

When there is huge data in QuickBooks POS, QODBC POS cannot 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

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).