O'Reilly logo

Microsoft Dynamics GP 2013 Cookbook by Mark Polino, Ian Grieve

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Controlling data with SmartList record limits

When running a SmartList, the number of records returned by the SmartList is shown in the lower-left corner. By default, SmartLists have a record limit of 1,000 records. The idea behind this default limit is to prevent long running SmartList queries from slowing down the system. However, sometimes it makes sense for queries to return more than a thousand records. For example, if a firm knows that they have more than a thousand fixed assets, it doesn't make sense to limit fixed assets' queries to a thousand, since most of the time this number will need to be adjusted. Similarly, many companies easily have more than a thousand bank transactions in a given month.

There are a few options for increasing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required