How to make a field uneditable based on an option on the User Setup Page

(0) Share

Report

Posted on by Olagoke Agboibon

Hello all.

I need some help with the following.

I'm trying to make a field uneditable for some certain users on the Purchase Order. And my process was this, I created a option field Post P.O on the User Setup Table with two options (Confirm and Deny), put it on the User Setup Page.

Then I created a boolean as a global variable on the P.O page, set it in the editable property for the field.

The following code is what I put in the Onaftergetcurrecord trigger

IF UserSetup."Post P.O"=UserSetup."Post P.O"::Confirm THEN Fielditable:=TRUE;

IF UserSetup."Post P.O"=UserSetup."Post P.O"::Deny THEN Fielditable:=FALSE;

Yet it doesn't seem to work if either option is selected on the User Setup Page.

Any help please?

I have the same question (0)

All responses (6)

Answers (2)

navision begginers 387 on at

Like (1)

Report

Dear Olagoke,

You don't need to write the code on Onaftergetcurrecord trigger. Just write the code on additional field which you have created on PO page.

Write code on field - OnValidate() trigger.

please see my below example code

'Your New field'- OnValidate()

usersetup.SETRANGE("User ID", USERID);

IF usersetup.FINDFIRST THEN BEGIN

IF usersetup."Your New field"<>TRUE THEN BEGIN

usersetup.TESTFIELD("Your New field",TRUE);

ERROR('You do not have permission to change the field')

END;

END;

here usersetup is a variable (table 91)

I hope it will help you to resolve your query.

Was this reply helpful? Yes No
Olagoke Agboibon 10 on at

Like (0)

Report

Thank you so much.

How about if I wanted to use a similar control for the post button?

Also, doesn't this line below mean I have to specify the user ID in code?

usersetup.SETRANGE("User ID", USERID);

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (1)

Report

Yes try on On Validate Trigger and cross check how it behaves.

Was this reply helpful? Yes No
Verified answer

navision begginers 387 on at

Like (1)

Report

you don't need to hard code. It will work depend on permission which you have provided in user setup.

Was this reply helpful? Yes No
Olagoke Agboibon 10 on at

Like (0)

Report

Okay.

Thank you for your help.

I do have one more question.

How about if I wanted to do something similar with a button on the page or the purchase lines?

Was this reply helpful? Yes No
Verified answer

navision begginers 387 on at

Like (1)

Report

yes of course, you can do same as in purchase line.

Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has verified answer and was beneficial to you.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to make a field uneditable based on an option on the User Setup Page

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to make a field uneditable based on an option on the User Setup Page

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates