Skip to Content
Author's profile photo Former Member

How to block the change of the columns in the documents and results

To realize the blockades in the columns of the documents and results we use the following combinations. If anyone has other suggestions, please add a post.

Administration >> System Initialization >> Authorizations >> General Authorizations:

– General -> Edit Document tables
– General -> Settings document

and/or

1062635 – Can I block a user from having access to Form Settings

and/or

You can blocking according with TransactionNotification include the fields:

— Column can not be modified —

if @object_type = (‘218’) and @transaction_type in (‘A’,‘U’)

     Begin

        if (select COUNT (*)

            from CHFL T0

            where objname in (‘OITM’,‘OCRD’) AND GroupBy <> ‘N’) > 0

     Begin

            Set @error = 1

Set @error_message = ‘Column can not be grouped’

END

END

http://scn.sap.com/community/portuguese/business-one/blog/2013/06/30/como-bloquear-a-altera%C3%A7%C3%A3o-das-colunas-nos-documentos-e-resultados

Regards,

Marcelo Silva Santos

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rodrigo Barbosa da Costa
      Rodrigo Barbosa da Costa

      Excelent post, but I have a doubt it's how I can block all the filds in  Inventory -> Item Master Data?

      The user only can modify just in User Fields. Do you understand?

      Author's profile photo Former Member
      Former Member

      Nice post yes.

      Rodrigo, do you have Boyum B1UP? You can hide fields and make fields read only for individual users. We could not use B1 without it!

      Author's profile photo Rodrigo Barbosa da Costa
      Rodrigo Barbosa da Costa

      Tim, I'm looking for the solution yet. About the B1up, I hear about and I will get a demonstation, thanks.

      Author's profile photo Former Member
      Former Member

      Hi Rodrigo

      You can do the form settings for Modules(Uncheck the Item Master Data) and you can block the form settings by doing additional authorization creator.

      Regards

      Karunakaran P.