Where are Navigation Pane options stored?

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

Hi Crispin

I'm referring to the left bottom section of the screen that lists the various ledgers. Where is it stored what the sort order is and which ledgers are visible?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

jayh 410 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No