Using VBDemo, if we need to figure out the GRM and GRM percentage since the new fiscal year (ours starts September 1st),  using the following query:

select txndate, refnumber, billaddressaddr1, shipaddressaddr1, shipaddressstate, salesrepreffullname, shipdate, invoicelineitemreffullname, invoicelinequantity, salesprice, (invoicelinequantity * salesprice) as amount, purchasecost, (invoicelinequantity * purchasecost) as cogs from invoiceline, item where txndatemacro = 'ThisFiscalYear' and listid = invoicelineitemreflistid order by salesrepreffullname, shipaddressstate, shipaddressaddr1 which we know is more than 5,000 line items (one of three company files, well over 380Meg) always stops at exactly 5,000. Or if we do the same query using 'LastFiscalYear', again stops at exactly 5,000. The work around for this is to do txndate >= and txndate <= but it's easier to do it by txndatemacro.     

Try increasing the Iterator or Chunk Size to 20000 (any value up to 100000 is allowed). If you are not using QuickBooks 2006 or 2007 (USA editions), QODBC reverts to using chunks to retreive sets of records and there's currently a bug in QODBC v7.00.00.199 that doesn't reload the next chunk correctly.