User gets an 'Object variable or block variable not set…' error when getting time entries, expense entries, or invoices from QuickBooks into BillQuick. This happens mostly while getting expense data.
QuickBooks cannot handle a large data transfer as BillQuick can, so when it gets overloaded with data records, it gives an error message.
This issue can be fixed by setting a date range filter in the BillQuick-QuickBooks Integration Settings screen.
1. Open the BillQuick-QuickBooks Integration Settings screen from the Integration > QuickBooks menu in BillQuick.
2. Go to the Get Settings panel and select the module from which you want to get data, say Time Entry or Expense Entry.
3. Under Date Filters, select the desired date range. Else, you a Last Modified date filter starting with one year at a time.
4. Save you settings and try to get the data.
5. If you still get the error, filter the date further by specifying 6 months, then 1 month, 2 weeks, 1 week or even 1 day at a time. 6 months to a year date range usually works.
6. If you are still getting the error even with a date limit of 1 day, enter that data manually in BillQuick; then set the date filter to get data from that day (Today) onwards.
