Security Filter Problem

rust

hi

I have a Dynamics Nav 5.00 SP1 for SQL Option

i am trying to limit a user to only able to access 'DEFAULT' Batch for general journal.

in the permission table i have as following will standard 'ALL' user & G/L-Journal Role

with modification as below

table data type = Gen. Journal Line
read,insert,modify,delete = yes
security filter = Gen. Journal Line: Journal Batch Name=DEFAULT

after synchronize sql n relogin into the database i face this error when click on the general journal

The Gen. Journal batch Does not exist.

Indentification fields and values:

Journal Template Name='GENERAL',Name="

Is there anything i have done wrong?

ayhan06

rust wrote:

hi

I have a Dynamics Nav 5.00 SP1 for SQL Option

i am trying to limit a user to only able to access 'DEFAULT' Batch for general journal.

in the permission table i have as following will standard 'ALL' user & G/L-Journal Role

with modification as below

table data type = Gen. Journal Line
read,insert,modify,delete = yes
security filter = Gen. Journal Line: Journal Batch Name=DEFAULT

after synchronize sql n relogin into the database i face this error when click on the general journal

The Gen. Journal batch Does not exist.

Indentification fields and values:

Journal Template Name='GENERAL',Name="

Is there anything i have done wrong?

To correctly apply security filters to Gen. Journal screens, you must set security filters on Gen. Journal Batch table. I tried Gen. Journal Line or gen. Journal Templates with standard nav roles , but they didn't work.

kriki

For the functionality you need, I would just put some C/AL code in the code to select/validate a batch.
You only need to put it in some places.

And the way you did it means that ALL the users will ONLY be enabled to use the DEFAULT batch for ALL templates. Maybe this is not what you want?