How can I set security on general journal batches based on user setup as follows:
the user has full permissions for the batches he created but only can read other`s batches
if he granted the permission in user setup then he has full permission
Hi, Is it possible to try setting Security Filter per user?
More details: https://yzhums.com/10133/
Hope this will help.
Thanks.
ZHU
Hi
As Josh mentioned not possible out of the box. I think you may need development for this. Some apps are available as Josh mentioned but they work based on "Security Group" and not based on creator of document.
query.prod.cms.rt.microsoft.com/.../RWQLrO
support.fenwick.com.au/.../360000444916-Activating-Field-Security-
I don`t want to use third party, I tried to do the following
trigger OnOpenPage()
var
myInt: Integer;
UserSetup: Record "User Setup";
begin
if UserSetup.Get(UserId) then
if UserSetup."Batch security" = false then begin
if rec."Created by" <> UserId then begin
Message('You do not have permissions to edit this page');
Editable(false);
end
else
Editable(true);
end;
end;
I created "Created by" field on gen. journal Lines and used the above code
Batch security is a boolean field in user setup
Difficult with standard. I’d check out: www.efoqus.ca/.../
Sohail Ahmed
2,655
Mansi Soni
1,574
YUN ZHU
1,453
Super User 2025 Season 1