You’re offline. This is a read only version of the page.
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
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.
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
If you look at the screenshot from company B here, you'll see it is in a slightly different order.
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!
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.
So I just copy the Blob in the Value column to another record and that then copies the menu settings?
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.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (