Microsoft Dynamics GP 2015 R2 will soon be released (due late May/early June and, as with previous releases, Microsoft have started a Feature of the Day series on the Inside Microsoft Dynamics GP Team blog. As I have done with the last three series, I’ll be reposting these blog posts here with a little commentary.
The thirteenth Feature of the Day is SmartList Designer Create View .
Within SmartList Designer a user can send a SmartList through workflow to create a SQL view based on the SmartList query.
This SQL view can then be used outside of GP for such purposes as creating reports using SQL reporting services or Power BI reports in Excel.
The view will also allow the user to publish the SmartList as a refreshable excel report from inside of Dynamics GP.