I think we all know adding a SmartList in Dynamics GP is pretty straight forward and easy.
Here are the steps:
The first step is to open the SmartList Builder window.
Then enter the SmartList ID and the name of the SmartList.
Enter the Item Name.
Once entered, select the Product that the SmartList will be grouped under.
Select tables and fields for the SmartList.
You probably even created a Favorite or two and saved your SmartList exactly the way you like to see it. But, did you know you can make some of those changes to SmartLists at a system level? That is done using the SmartList Options settings.
SmartList System Level Changes
One of the most common issues with SmartLists and the data they return is that it seems to only be returning data for a certain timeframe, but what is often the case is that the SmartList only allows 1,000 records to be returned by default, and the actual number of records has exceeded that amount. You can certainly save a SmartList Favorite and increase that number, but that only increases it for that one Favorite that you just created.
To make this change so it applies to the SmartList you choose and any new Favorite you might create in the future, go to Microsoft Dynamics GP | Tools | Setup | System | SmartList Options.
In my screen shot, you can see that I have chosen the Category of ‘Payables Transactions’, which corresponds to the folder with the same name in SmartList.
You can see that my Maximum Records default is now 5,000 instead of 1,000 records on this SmartList. Now that I have made this change to the ‘Payables Transactions’ category, all the NEW favorites that you create based on this SmartList will also default to 5,000 records.
To change this for existing SmartList favorites, you can open them, click the Search button, then modify the Maximum Records amount (which is a required field at the bottom of the window).
Once you have made the change to the Maximum Records, click OK, then click Favorites to open the Add or Remove Favorites window, and click the Modify button.
This saves the existing favorite with the new Maximum Records amount.
The middle section of the SmartList Options window allows you to add or remove columns from your SmartList and change the order in which they appear. These changes will also impact all NEW favorites that you create based on that SmartList.
The last portion of the SmartList Options window allows you to make changes to Search Defaults and allows you to password protect the modifying of SmartList Favorites.
About Rockton Software
Work Simpler & Easier® isn’t just a catchy motto. It’s a lifestyle.
Rockton Software, a Microsoft Dynamics Partner, is an Independent Solutions Vendor (ISV) based in the United States. The company started in 1999 by offering custom development for clients using Microsoft Dynamics GP accounting software. Today, Rockton Software is a creative company with add-on products for Dynamics GP and Acumatica. Our product suite consists of: SmartFill, Dynamics GP Toolbox, Auditor, Dynamics Report Manager, Omni Price, Project Cost, and the newest addition to the Rockton product family, Rockton Pricing Management.
Rockton Software is a virtual company with employees in seven states and its headquarters in Erie, Colorado. Serving over 100,000 users worldwide, Rockton Software supports innovation by offering Microsoft Dynamics add-ons for all industries. Whether you’re in need of auditing, pricing, searching, reporting, or general user enhancements, we’ve got the solution for you!
Here are some ways you can learn more and get connected:
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent.
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Your blog was very informative. I learned a lot from this blog of yours.
Thank You!