14 Dec SmartList Export Solutions in Dynamics GP
The Export Solution functionality in SmartLists with Dynamics GP allows you to easily extract information from Dynamics GP, and then add additional formatting in Excel to add value to the information. Unfortunately not many people take advantage of this functionality. Too bad, because it can really provide even more value to your SmartLists.
You can have graphs, pivot tables, calculated fields, and sophisticated formatting added to your GP data automatically. Basically you record Excel macros to do all the formatting that you want. These macros can then be selected to run after your download the SmartList results to Excel.
This video shows this functionality in action: