Block users from closing documents which they didn't create

[isaac_kalii]

Hi,

Please assist on how to block users from closing documents like PO's which they did not create.

Thanks,

Isaac.

[former_member205766]

Hi

Try this Stored Procedure

if @object_type ='22' and @transaction_type in ('L')

begin

If Exists (select r.DocEntry  from OPOR r

where r.DocStatus='C' and r.UserSign2 <> 4 and r.DocEntry = @list_of_cols_val_tab_del   )

  Begin

  select @error = 1

  select @error_message = 'You are not authourized to close the document '

end

end

With Regards

Balaji Sampath