Microsoft Dynamics GP SmartList Tips
I presented a webinar for our customers last month on SmartList tips and realized it would make a great blog!
If you’re new to Microsoft Dynamics GP or just unfamiliar with SmartList, it is an ad hoc query tool built into Dynamics GP. At its base level, it lets you pull quick lists of master records, period summaries, transactions, etc.
There are standard “queries” in SmartList that give you a starting point and then options that let you fine tune your queries. I’m not going to go into the basic usage of SmartList since there are already many posts and videos to cover that. I’m just going to list out some of the features that I think are very helpful and often missed.
Order By: Simple sorting in SmartList is accomplished by clicking the column header in the data view. But if you need to sort by multiple fields, use the Order By option in the Search window to sort by as many fields as you like. If you do click on a column heading in the data view, you’ll lose your multiple sorts – but if you know you’re going to export to Excel then sort by two or three fields, setting this up in your Search will save a few steps.
In the interest of keeping this blog fairly short, I’ll skip over to Export Solutions (found under the SmartList button/icon on the ribbon).
In a nutshell, Export Solutions allow you to export data to a pre-saved template and trigger a macro upon completion of the export. The benefit again is massive time savings. Let’s say I need a pivot table and/or pivot chart of my top 10 customers. I can create an Excel template with a macro saved in it and all the repetitive work done for me by having SmartList trigger the macro to slice and dice my data.
I’m not going to walk you through all the steps to create an Export Solution in this blog, but if you search for Microsoft Dynamics GP Export Solution you’ll find several videos walking you through the setup. I also have the steps documented for you and you can download it here.
Hope this gives you some new ideas on how to get more out of SmartList.