Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How can I prevent a us...
Microsoft Dynamics NAV (Archived)

How can I prevent a user from modifying a record in NAV 2017?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

Scenario: I have 10 fields in a table. The FIELD2 is a drop down and can have two values CREDIT or CASH. 

//Questions

1. How can I make sure that only 2-3 special users can change FIELD2? These 2-3 users should be able to change all 10 fields.

//All users do not include 2-3 special users.

2. If FIELD2 is CREDIT then only FIELD8 and FIELD9 are editable by all users. Other fields should be uneditable for all users.

3. If FIELD2 is CASH then only FIELD5, FIELD6, FIELD7 and FIELD9 are editable by all users. Other fields should be uneditable for all users.

Thanks,

Umair

*This post is locked for comments

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,891 on at
    RE: How can I prevent a user from modifying a record in NAV 2017?

    Zulfi ,

    i think Suresh Kulla mention the easiest way addition to his comment  i suggest to create separate permission set for them

    you can have another solution by separate little customization with another new table but i think this would be enough

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,688 on at
    RE: How can I prevent a user from modifying a record in NAV 2017?

    Umair,

    One way to do is add a boolean on the user setup table and enable that permission only for the users who has permission to edit the field, and then on Validate of the FIELD2 check the user setup for the permission and throw appropriate error for users.

    Making fields editable based on permission and other field value follow same logic, you need to assign other fields Editable Property to a variable with IncludeInDataSet property set to true and then make that variable true or false based on your condition.

    For example check the customer card contact field it will editable only when the primary contact no. is filled. The logic is on the ActivateFields Function

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans