on 07-18-2017 7:30 AM
Hi Experts
i need a SPT , which should allow only the mention User to add or edit BP Master Data
Regards
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
106 | |
14 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.