Does Smartlist have max # of records it looks at?

[inin]

I created a report through SmartList builder and when I run it, the
information stops at 12/7/09. It does not show the rest of the year
regardless of what date criteria I use. I then created a similar SQL query
and made a new SmartList from that query. Again the information stops at
12/7/09. Is there a maximum number of records that SmartList will look at?
Or any ideas on why this is happening?

This is my SQL query:
select a.ordocnum, a. crdtamnt, a.debitamt, a.trxdate, a.actindx,
a.ormstrid, a.ormstrnm, a.dscriptn, b.mnacsgmt, c.userdef1, c.userdef2

from gl20000 a left join sop10106 c on a.ordocnum = c.sopnumbe
inner join gl00100 b on a.actindx=b.actindx

where b.mnacsgmt='1150'

THANKS!

[Mariano Gomez]

In the SmartList toolbar, click the Search button and change the maximum
number of records being displayed from 1,000 (default value) to a number that
best suit your needs.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

[Richard Whaley -- MVP 2006-2008]

Have you checked to be sure you have transactions after 12/7 through GP?

--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com