Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Where are Navigation Pane options stored?

Posted on by Microsoft Employee

Hi


I have 60 companies to manage and I would like to standardize the navigation pane menu (i.e. the ledgers that are visible and the sort order). Where is the navigation pane table stored? Thank you for your help.

Yours


Arie

*This post is locked for comments

  • Martin Dráb Profile Picture
    Martin Dráb 230,104 Most Valuable Professional on at
    RE: Where are Navigation Pane options stored?

    Does it mean that the part of your question about what's visible in the menu is now answered and now the discussion is only about the order? I've never paid attention to the order, so I don't know whether it depends on how you use the menu or what - I'll leave this topic for somebody else.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Where are Navigation Pane options stored?

    Hi Martin

    Signature update.

    With regards to your other comments, it is not about security. Let me provide you with an example:

    If you look at this screenshot from company A, you'll see the menu

    MainMenu2.JPG

    If you look at the screenshot from company B here, you'll see it is in a slightly different order.

    MainMenu2.JPG

    I want the order in both companies to be the same. Normally, the screens would be the way through "Navigation Pane Options". But in my case, I'd need to do that 60 times. So I want to be able to do this through code or Atlas as it should be faster and more accurate.

    Thanks!

  • Martin Dráb Profile Picture
    Martin Dráb 230,104 Most Valuable Professional on at
    RE: Where are Navigation Pane options stored?

    Code and metadata (including menus) is defined once for the whole installation and shared by all companies. What can differ is security setup in different companies.

    It seems that your goal is having the same permissions set up in all companies, but you don't have it now for some reason. That's the direction you should follow and leave the incorrect expectations that each company has a distinct copy of the menu stored somewhere.

    By the way, I find the list versions in each of your post rather distracting and not very useful, as it doesn't make clear even whether you're talking about AX 2009 or AX 2012. Consider making it smaller, removing line spacing and visual separating it from your actual reply, if you don't want to get rid it completely.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Where are Navigation Pane options stored?

    So I just copy the Blob in the Value column to another record and that then copies the menu settings?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Where are Navigation Pane options stored?

    It probably is. But so far I have unconvered a couple of SYSxxx tables but data seems to be stored in BLOBs. The most promising table so far is SysLastValue. I'm not sure I understand that table fully yet.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Where are Navigation Pane options stored?

    Hi Martin

    Just to clarify a bit further, the issue is not for users but for companies. I'm the admin of the system and I can see all 60 companies. I want a common look/feel for the modules so I am not searching all the time as currently the menu differs in each company.

    What I want to do is get my setup for the menu correct in one company and then copy it across to the other companies for my user account only, rather than redo the set up manually in each of the 60 companies with the added complication of user errors and mistakes.

    Hence my question about what tables this is stored in so I can check how to copy this. I trust that clarifies it further.

  • Martin Dráb Profile Picture
    Martin Dráb 230,104 Most Valuable Professional on at
    RE: Where are Navigation Pane options stored?

    Your picture shows the main menu, which is a collection of module menus (that's what you call ledgers). These are defined by developers in AOT.

    But users usually don't see the full content of main menu, because they don't have permissions to see all items. A menu item is each link in the menu and you can set permissions for each of them, therefore two users can see different things in the same module. And if user doesn't have access to any item in under a given module (such as Sales ledger), he or she won't see the menu for the module at all.

  • Suggested answer
    jayh Profile Picture
    jayh 410 on at
    RE: Where are Navigation Pane options stored?

    This is probably stored in Usage data (SysLastValue) in the record with elementName "Usersetup" and deisgnName "NavPaneOptionsButtons".

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Where are Navigation Pane options stored?

    I'm afraid not. This tells me how to customise the front-end as an end-user. What I am looking for are the back-end tables where the settings are stored so I can align this for 60 companies in one go and ensure it is consistent across all 60 companies, rather than go in to 60 companies separately and modify it like that.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,104 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans