Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
We have identified an issue with SmartList Designer on Microsoft Dynamics GP 2013 where when you create a new Smartlist using SmartList Designer and then attempt to run the newly created Smartlist, no results are returned for users who are not 'sa' or not in the sysadmin server role. The issue occurs because the DYNGRP database role does not have the necessary rights to the necessary functions in the company database.
The current workaround is to run the below script against the companies that you are running the newly created SmartList against as this will give the DYNGRP database role the necessary rights for the functions. Here is the url to download the script from: https://mbs2.microsoft.com/fileexchange/?fileID=6fec21d8-1348-4733-bc64-2028a1f4cf2e Please watch for this to be fixed in a future service pack. Thank you!Sarah
Thank you, I have recently starting Smartlist Designer and I thought I was doing something wrong. But, when a Smartlist is created from 'sa', will there still be a problem with the Smartlist from the user's profile?
Is there an updated script for R2 perhaps? I just ran this and I still get no results for users other than sa. Thank you.
worked superbly for an GP 2016 R2 update
Thanks for your informative support. Just need to know it is applicable to MS Dynamics GP 2016 R2 as well.