Restrict access to G/L balances

Hello all,

I am wondering if anyone knows if it is possible to restrict access to G/L balances by user. I don’t mind if these users can see the account numbers and descriptions, but I would like to prevent them from accessing the account balances. If anyone has information on if this can be accomplished and how, I would greatly appreciate it.

Thanks!

You need to do some customizations.

Add one boolean field in User Setup say Show Balance

On Form 16 you can write following code on OnopenForm Trigger

UserSetup.SETFILTER(UserSetup.“User ID”,USERID);

IF UserSetup.FINDFIRST THEN BEGIN

IF NOT UserSetup.“Show Balance” THEN

CurrForm.Balance.VISIBLE:=FALSE;

END;

This will help you…

Hi Amol,

Since User Id is already primary key of User Setup table your code could be simplified as:

IF UserSetup.GET(USERID) THEN

CurrForm.“Balance at Date”.VISIBLE := UserSetup.“AllowG/LBalances”;

However, it does not help Mac I believe! Because it will only hide the column and user can use Show Columns to make it visible again.

Hi Amol,

Since User Id is already primary key of User Setup table your code could simplified as:

IF UserSetup.GET(USERID) THEN

CurrForm.“Balance at Date”.VISIBLE := UserSetup.“AllowG/LBalances”;

However, it does not help Mac I believe! Because it will only hide the column and user can use Show Columns to make it visible again.

Jay,

Very well Noted.

I suggested this solution because Navision doesn’t provide the field level permission,so he might get some idea from our suggestion.