Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Wiser]

My boss has asked if we can hide certain columns on the physical inventory journal for certain roles.  I know that I can open the role in configuration mode and hide the columns, but (unless I disable personalizations for the role) the user can just “Choose Columns” and add then hidden columns back to their page.  Is there a way to hide certain columns based on roles which would also prevent individual members of  the role from adding them back?  I don’t want to delete them from the page completely since other roles do need to see the columns.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————

[Franz Kalchmair]

you could declare a global bool variable, e.g. RoleVisible. set that variable to the Visible property of the fields you want to display dynamically by role/profile.

add then following to onopenpage trigger:
// UserPers / Record / User Personalisation
UserPers.GET(USERSECURITYID);
RoleVisible := UserPers.”Profile ID” = ‘PURCHASER’; // or what ever you want to do

columns can then be seen in the “choose column” window, but are not shown in the column list if RoleVisible=false.

——————————
Franz Kalchmair
Microsoft MVP
Senior Consultant
Vienna, Austria, Europe
——————————
——————————————-

[David Singleton]

Have you looked at Easy Security.

it probably does what you need.

http://www.mergetool.com/easysecurity.html

——————————
David Singleton
Go Live International
SQL Perform Navision Performance Consultant
dsingleton@go-live.us
——————————
——————————————-

[Mathew Ealy]

Easy Security is a great tool for this need.Once you start hiding fields it becomes a slippery slope and having a tool that allows field level security like Easy Security becomes a god send.

——————————
Mathew Ealy
Nav Support Specialist
Rentokil N. America
Reading PA
——————————
——————————————-

[Kris Ruyeras]

Hi Dave,

You could look at the Application Area Setup / ApplicationArea option for Dynamics NAV. Under Properties of the field you are trying to ‘hide’, you can assign it with ApplicationArea and can be user specific who gets to see the field/column or not.

——————————
Kristoffer Ruyeras
Director of Business Technology
Seattle, WA
——————————
——————————————-

[Naveen Jain]

Dave,

First modify the user roles as needed and then From the USER permissions remove insert/delete/modify permission for TableData 2000000080 Page Data Personalization

——————————
Naveen Jain
Director of IT
Symbex Companies
Santa Fe Springs CA
——————————
——————————————-