Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Can you limit user access using Dimension

(0) ShareShare
ReportReport
Posted on by 60

Is it possible to apply a dimension against a BC user and have that user only able to see the dimension they are permitted to see. For example, we would like to limit which customers a user can see based on the dimension set for that user. This would also need to work for purchase orders and inventory items. Ideally, we would like to limit access to that dimensions in the General Ledger too.

  • Suggested answer
    Amit Baru Profile Picture
    3,025 on at
    RE: Can you limit user access using Dimension

    Hi,

    Yes you can do. for that you should develop custom functionality for that.

    My suggestion use Responsibility Center functionality which is available in BC D365.

    Regards

    Amit Sharma

    www.erpconsultors.com

    https://www.linkedin.com/in/amit-sharma-94542440/

  • Suggested answer
    Inge M. Bruvik Profile Picture
    32,718 Moderator on at
    RE: Can you limit user access using Dimension
    [quote user="Makdaddy_AU"]

    Seems like there is no solution for this problem. The only fix here is to create an extension

    [/quote]

    The solution is simply to use the security filters that Josh suggested to you. No need to customize this.

  • Alfredo_Iorio Profile Picture
    1,260 on at
    RE: Can you limit user access using Dimension

    I would go for Josh's option 1.

    Since you mention that the dimension is on customers, purchases and general ledger, you likely have this dimension as a global dimension.

    With that, you can apply security filters for the users so they can only see records tagged with that dimension.

    I am doing something similar for a UK client. We have Division and a global dimension and the division is linked to a responsibility centre.

    Users assigned to a certain responsibility centre can only operate on their records while line managers can work on everything.

  • Suggested answer
    Makdaddy_AU Profile Picture
    45 on at
    RE: Can you limit user access using Dimension

    Seems like there is no solution for this problem. The only fix here is to create an extension

  • Community Member Profile Picture
    Microsoft Employee on at
    RE: Can you limit user access using Dimension

    To grant access to dimensions:

    On the Home page, select Application, and then click the application name to display the Application Overview.

    From the application Overview screen, select Dimensions and Models

    Click the name of the dimension for which you want to grant access.

    From the Dimension Overview screen, select Access. The name of the selected dimension is displayed at the top of the screen.

    Click Add User/Group buttonand select the users to which you want to assign access, as follows:

    Select the user type:

    Users

    Groups

    Users and Groups

    On the Select User dialog box, enter the first few letters for the user name in the text box, and then click Search Search icon to populate the list of names. To display all users and groups, enter an asterisk "*" as a wildcard in the Search field.

    Select the users and groups to which you want to assign access, and then click OK.

    From the Access tab Access tab, select Administer to enable the user or group to view, modify, or delete the dimension.

    Optional: Select Remove to delete the selected user or group from the list. Highlight the name, and then click X to remove the name and any associated permissions.

    Click Close.

    Hope this information is helpful to you.

  • Suggested answer
    JAngle Profile Picture
    33,135 on at
    RE: Can you limit user access using Dimension

    Opens up an interesting debate. Method 1 is more up keep but method 2 has more development.

    1. Permissions could control this. Use the security filter feature for the chosen tables for a chosen dimension value. Will need to be a global dimension though.

    2. Using various table/page extensions to enable the filtering when pages are opened. This would follow a similar concept to the responsibility centre where quote/order/invoice pages are filtered. Following on it that vein you could add the dimension field on the user setup and then call this on each of the pages you need for filtering. The user setup table already has the sales/purchaser code which is a table already with the ability to hold dimensions. That could be another way of determining the filtering.

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Test role Public

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans