Skip to Content
avatar image
Former Member

Need SPT which allow only a single user to add or Edit BP Master Data

Hi Experts

i need a SPT , which should allow only the mention User to add or edit BP Master Data

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 18, 2017 at 06:32 PM

    Hi Shahan

    You can do something like this:

    IF (@object_type = '2' AND @transaction_type IN ('A', 'U'))
    BEGIN
    	IF (SELECT CASE WHEN @transaction_type = 'A' AND UserSign <> 1 THEN 1
    				    WHEN @transaction_type = 'U' AND UserSign2 <> 1 THEN 1
    			        ELSE 0 END 
    		FROM OCRD WHERE CardCode = @list_of_cols_val_tab_del) = 1
    	BEGIN
    		SET @error = -100
    		SET @error_message = 'Only user 1 is able to create and edit business partners'
    	END
    END
    

    Replace the value 1 in UserSign and UserSign2 comparison with the Id of the user that is allowed to create and edit BP.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded