web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Permission to only shows the purchase orders created by user himself

(0) ShareShare
ReportReport
Posted on by 19

Hi,

Person A creates the purchase orders in BC, and put his own Purchaser Code to the related box in that page. I want to arrange a permission which allows him to only see the purchase orders he created, not the other purchase orders created by other users.

Is it possible ?

Thanks in advance,

Best Regards

I have the same question (0)
  • Verified answer
    Tech-Lucky Profile Picture
    1,288 Moderator on at

    You can try Security Filters in Permission Sets: learn.microsoft.com/.../security-filters

    Mark my answer Varified if this was helpful

  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 Moderator on at

    Security filters are the thing to use. Just remember to make sure that at least one of your resources still are available to see all the data in case someone gets sick or leave the company.

  • Suggested answer
    YUN ZHU Profile Picture
    102,361 Super User 2026 Season 1 on at

    Hi,  Security Filters is a very good solution because it does not require customization.
    More details: https://yzhums.com/10133/

    If you consider customizing, please refer to the method below.

    How to make some filters mandatory on the list page (users can not change or remove)
    https://yzhums.com/8427/

    Hope this helps.

    Thanks.

    ZHU

  • Oguzhan Gok Profile Picture
    19 on at

    Hi, Thank you for the response. I have one additional question.

    In this scenario, I prepare a permission set for 3 people. All of them will use the same permission set. They all use the purchase orders and they have to see the orders only they have their own code in "Purchaser Code" box. When I add the security filter to purchase order table in the permission set, I have to choose one of them or add all of them, but in this way whether they will see the same orders from the purchaser I choose or they will see all the orders 3 of them created. I tried to put %me but it didnt work. How can I solve it?

    Thanks in advance for the help.

    Best regards,

  • Suggested answer
    Tech-Lucky Profile Picture
    1,288 Moderator on at

    I don't think that you can use the security filters dynamically as you want.

    for that, I have a suggestion for customization as follows:

    Step 1.) There is a Field on User Setup >> Salespers./Purch. Code: Fill in the Purchaser Code user-wise.

    Step 2.) Add a Filter of "Salesperson./Purch. Code" in Purchase Order List Page on Open Page Trigger as follow

       trigger OnOpenPage()

       var

           UserSetup: Record "User Setup";

       begin

           UserSetup.Get(UserId);

           FilterGroup(0);

           SetRange("Salespers./Purch. Code", UserSetup."Salespers./Purch. Code");

           FilterGroup(1);

       end;

    Note: Please mark my answer as varified if this was helpful.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 647 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans