Open Forum

 View Only
  • 1.  Access to Smartlist

    Posted Jun 27, 2022 10:35 AM
    i created a new smartlist from a previous smartlist for my co-worker. She can see the smartlist but it doesn't pull any results. Apparently I need to grant her access but I've done everything I can think of to give her access. She is a power user.
    I created a security task.

    I added the task to the Accounting Manager role

    I made sure she had access to that role. She also is a POWER USER.

    What else do I need to do to allow her access to the Smartlist?

    Deborah Butters
    Valley Coop Oil Mill
    Harlingen TX

  • 2.  RE: Access to Smartlist

    Posted Jun 27, 2022 11:17 AM
    Hi Deborah,
    How was this smartlist created ? are you using SL Builder from eOne or SL Designer (built-in to GP) ? 
    If the SmartList is based one some custom SQL view rather than existing GP tables or views, you need also to grant read permissions (select) to the view for the GP user account that wants to consume the data.
    Usually we grant the permissions to the DYNGR SQL role, which gives access to the data for all GP users that would want to use the SL in GP.

    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013

  • 3.  RE: Access to Smartlist

    Posted Jun 27, 2022 11:43 AM

    Here's a screenshot of the Smartlist designer page that I created and the favorites screen showing it should be visible to everyone. Please walk me step by step how to allow another user to access this Smartlist.




If you've found this thread useful, dive deeper into User Group community content by role