Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Access Restriction of ...
Small and medium business | Business Central, N...
Suggested answer

Access Restriction of Location Items

(0) ShareShare
ReportReport
Posted on by LearnBC 190

Dear Team,

How we can Restrict of Location items to a specific User

Eg: We Have two locations  Eg : Location -DELHI (with Branches- Apple, Orange) and another Location- Mumbai (with branches- Green and Yellow).so there are two users we can Tom and Jerry , TOM should only have the access item in the Location DELHI (and its branches) and JERRY should have the access of ITEMS in MUMBAI Only. (should not able to access other Person Location items)

How we can set this restrictions. kindly requesting the suggestions on this 

  • LearnBC Profile Picture
    LearnBC 190 on at
    RE: Access Restriction of Location Items

    Pls let me know how we can do with that..

    As i said before,i only want to restrict the user for doing location transfer from others location ( both users sharing same user groups also)

  • BrianDev Profile Picture
    BrianDev 105 on at
    RE: Access Restriction of Location Items

    You can achieve this by using Responsibility centers.

  • LearnBC Profile Picture
    LearnBC 190 on at
    RE: Access Restriction of Location Items

    Still am confusing that is am doing correct or not....

    One issue is both of the Users and using Same Multiple User Groups .

    i want to only Restrict the transactions from Transfer Order page(they should transfer their own stock)

    there is no issues for seeing the data in any of the location, only need to restrict for transfer orders

    so in this case, how do i need to change the code

  • LearnBC Profile Picture
    LearnBC 190 on at
    RE: Access Restriction of Location Items

    Okay...

    i have 2 queries..

    a) right now on items, while clicking on the total stock itself it is not allowing to go inside

    b) , how we can put the options for getting teh data of sub branches means (in location Delhi. Branches like reg green etc)

    as you said, if we give same logic on transfer order page, i have small confusion, in Transfer Order page, i think its selecting the item from item table, so at that time whether it will check the Location also?

    pls guide me

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,544 Moderator on at
    RE: Access Restriction of Location Items

    Hi,

    In that case you can put the same logic as well in the transfer order page.

  • LearnBC Profile Picture
    LearnBC 190 on at
    RE: Access Restriction of Location Items

    Hello Dear,

    Thanks for the update.

    Right now, while going to items and clicking on inventory -its showing correct location data only (means one location items only) BUT

    when the user user goes to transfer orders, he can able to select the item from another location also.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,544 Moderator on at
    RE: Access Restriction of Location Items

    Hi LearnBC ,

    Can you please try this? I have not checked that. please let me know.

    pageextension 62006 "Location Item Restrict" extends "Item Ledger Entries"

    {

       trigger OnOpenPage()

       begin

           if (UserId = 'TOM') then

               rec.SetFilter("Location Code", 'Delhi');

           if (UserId = 'Jerry') then

               rec.SetFilter("Location Code", 'Mumbai');

       end;

    }

  • LearnBC Profile Picture
    LearnBC 190 on at
    RE: Access Restriction of Location Items

    is this is the right way to get the desired result. pls let me know what is the issue in this or How we can do it

    pageextension 62006 "Location Item Restrict" extends "Item Ledger Entries"
    {
        trigger OnOpenPage()
        var
            Items : Record "Item Ledger Entry";
            myint : Integer;
           Confirm: Label 'You have No access On Another Location items';
            users : Record "User Group Member";
           begin
               
                Items.Reset();
                if (UserId = 'TOM' ) then
                Items.SetFilter("Location Code",'Delhi');
                if (UserId = 'Jerry') then
                Items.SetFilter("Location Code", 'Mumbai');
                else
                CurrPage.Update();
           end;

           end;
  • LearnBC Profile Picture
    LearnBC 190 on at
    RE: Access Restriction of Location Items

    Thankyou,

    while making the Purchase Order itself, we Mentioned that this item should come on which location based on the Project/Requirement. Most of the times items comes in Delhi Location, (if reqd later do the transfer out to Mumbai). Means any item can come in any of the location also.

    So once item is reached on Delhi (Tom) and Mumbai(Jerry) locations, then they should able do the transactions on their location items only.

    pls do let me know, in which method we can follow to complete the requirement

    Thank you again

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,025 Moderator on at
    RE: Access Restriction of Location Items

    Welcome to be BC world!

    I think you should put Tom and Jerry in different user groups so you can assign different security filters to them.

    If you have a default location for each Item on the Item card you should set the filter on the Item table.

    If the same Items are sold from all locations and you need to restrict them for selling at different locations we need another approach.

    So if you can detail a little more how you have registered your items and locations it would be a better base for helping you further

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,459 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,066 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans