Some of you may already know about Smartlist Designer. For those who don’t, this is an exciting tool that we can’t wait to share with you!
Smartlist Designer was first introduced to us as a FREE tool in Microsoft Dynamics GP 2013 (SP2+). At the time, we would have liked to see additional features BUT Smartlist Designer could do some really nice things quickly that standard GP Smartlist couldn’t do!
In March 2015 at Microsoft Convergence, Microsoft announced a new and improved Smartlist Designer in Microsoft Dynamics 2015. These great new features help streamline the reporting process and allows users to quickly, easily and accurately pull the exact information they need for their particular role.
Some of the great new features in the Dynamics GP 2015 release include:
Create and modify existing Smartlists
Allow users to use both tables and views as a data source when creating or modifying existing SmartLists
Flexibility to create refreshable excel reports
SmartList Designer View Workflow Type allows a user to send a new or updated Smartlist through a Workflow for approval before others have access to it. Once the Smartlist is approved by the appropriate person, the Smartlist is now available to others
View your exported data excel file on your smartphone or tablet
Allow users to create SQL views from SmartList Designer
Smartlist Favorites Default Settings allows the system administrators to redefine the default selection for new Smartlist favorites by Company, User Class or User ID. By selecting User ID, only the creator can view his or her favorite list.
For those on GP 2013 (SP2+)……whether you’re waiting for GP 2016 or you just haven’t moved to GP 2015 yet, we’ve got 3 tips for you! Check out pages 18-19 of the Spring 2014 GPUG Magazine to view these tips; Tip#1 Create your Smarlist in the Correct Series, Tip#2 User SmartList Designer to Show 1099 Box and Tip#3 When using multiple tables, limit the “join” statement.
Try out Smartlist Designer Yourself!
You can access Smartlist by going to Microsoft Dynamics GP > Smartlist > select the “New” Button in the left hand corner of Smartlist – and practice modifying it for your needs! **just be sure you are using GP 2013 SP #2 or higher
We hope this helps make your life a little easier! CONTACT US with any questions.
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.