Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Salesperson Filter on ...
Microsoft Dynamics NAV (Archived)

Salesperson Filter on Contact table

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello experts

I would like to set up security on "Contact" for salesperson - a salesperson can only view/edit the contacts assigned to him/her. 

I tried to use the security filter on the table Contact in the user profile and everything seems to work but it is tedious since I need to set up 15 different profiles for 15 sales persons.  When I checked the table Contact, there is "Salesperson Filter" in the table by default. So I was wondering that whether the "Salesperson filter" is a more natural way or anything difference from the "security filter"?  

Your input is much appreciated.

Thanks 

*This post is locked for comments

  • Alicja_ Profile Picture
    Alicja_ 241 on at
    RE: Salesperson Filter on Contact table

    Hello Paolo,

    Can you please repost the image? It is no longer working. I'm trying to set up the filters to test this solution.

    Thank you!

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Salesperson Filter on Contact table

    Hi Enc...

    Just add a code [Filter view: USERID] on the Page...

    When a sales person will try to open a page it will filter the records which has USERID = her/her USERNAME...

    Also Create Permission set where donot allow Sale Person to create a NEW record, only allow them to MODIFY the reocord...

  • The Simpsoid Profile Picture
    The Simpsoid 625 on at
    RE: Salesperson Filter on Contact table

    Beware a potential problem on this if your salespeople are able to create contacts - if there's a filter limiting them to only seeing those assigned to them, then at the point they create a new contact it would (almost?) immediately fail the check and no longer be viewable or editable by them.  The answer might be to allow all salespeople to see their own OR any not yet assigned to anyone.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Salesperson Filter on Contact table

    Hi,

    If the USERID matches with the salespersons, on the Page properties (I suppose Contact List) you can set a table filter

    Salesperson Code FILTER %USERID.

    s31.postimg.org/.../image.jpg

    If the USERID is more "like" the salespersons, you proceed in the same way, but you need to adjust the aim using the right string function, reference: msdn.microsoft.com/.../dd301259.aspx

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