Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Smartlist not showing records to the user

Posted on by Microsoft Employee

I had created a smart list thru smartlist bulder from GP10, this is working perfectly for sa account,  I had given the object access to one user.

Now user can see the smartlist but it doesn't give output(records).

please tell me what access I need to provide this user?

*This post is locked for comments

  • CarlosCarlos Profile Picture
    CarlosCarlos 41 on at
    RE: Smartlist not showing records to the user

    Hola Dencio

    Thank you very much, it works now; users are very happy.

    Carlos

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Smartlist not showing records to the user

    Thanks Dencio, It is working now.

  • Dencio Profile Picture
    Dencio 2,172 on at
    Re: Smartlist not showing records to the user

    Hi, 

    Please review new sql objects (view, stored procs, table, etc) you created for SLB.  Run the grant.sql script to allow all users access to these objects via DYNGRP user role.  Lastly, review the security configured in SLBs for Data Connection and SQL tables.

    Hope this helps!

    Cheers,

    Dencio

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Smartlist not showing records to the user

    If you are conecting to an external database with the smartlist, does the user have access to these tables?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans