I frequently get asked by my Microsoft Dynamics GP clients if they can increase the default SmartList maximum records from 1000 to 10,000 and if they can add a default column like Batch ID or Posted User ID without going into the search window or the columns window each time. By following the steps below you can accomplish this.
- Go into Microsoft Dynamics GP > Tools > Setup > System > SmartList option
- Category: Select the Account Transactions Category (accounts, transactions, customers, vendors, items or employees)
- Maximum Records: (Select the maximum number of results you want your search to return.) The default will always be 1,000. The maximum record you can go up to is 1,410,065,407.
- Search Defaults: (Mark or unmark the default columns you want on your SmartList)
In the example below, I added Batch Number and Posted user ID to my default Columns
- Click OK to save changes
Keep in mind, all of the settings specified in SmartList Options are system wide and will impact all companies that use SmartList. If you look at the screen shot in step four, you will notice that the SmartList for Payables Transactions now includes Batch Number and Posted User ID in the columns and the maximum record is now 1,410,065,407.
RSM is a national partner of Microsoft Dynamics with Gold Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) Competency in the Microsoft Partner Network. This competency means we have demonstrated our ability to meet Microsoft customers’ evolving needs in today’s dynamic business environment and have completed the rigorous tests to prove our level of technology proficiency. The competency also requires that we have a number of Microsoft Certified Professionals and customer references. If you are looking for support for your Microsoft Dynamics GP system, we can help. Contact our professionals for more details – firstname.lastname@example.org or by phone at 855.437.7202.
By: Priten Patel – Great Lakes Microsoft Dynamics GP partner