Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

how to automatically filter a Salesperson Code/Purchaser Code based on the current user

(0) ShareShare
ReportReport
Posted on by 30

Good morning,

In user setup we have signed in Salesperson Code/Purchaser code "CV" salesperson code.

Is it possible to filter all the screens, in the case of having the field, by the salesperson code?

For example, if I access sales orders, and I am assigned the salesperson code "CV" I only see the "CV" orders.

Thank you

best regards

  • Suggested answer
    YUN ZHU Profile Picture
    84,555 Super User 2025 Season 1 on at
    RE: how to automatically filter a Salesperson Code/Purchaser Code based on the current user

    Hi, using Security Filters is a way, but it is not that smart. As far as I know, it cannot pass "CV" as a variable, so if you have multiple Sales Persons, you need to set multiple permission sets.

    More details: https://yzhums.com/10133/

    I think it might be easier to customize it. Here is a simple example, hope it helps.

    https://yzhums.com/8427/

    Thanks.

    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    9,278 Moderator on at
    RE: how to automatically filter a Salesperson Code/Purchaser Code based on the current user

    Hi

    look this

    learn.microsoft.com/.../security-filters

    DAniele

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Featured topics

Product updates

Dynamics 365 release plans