Skip to Content
0

SAP B1 Item MAster Price

Oct 29, 2017 at 09:09 AM

31

avatar image
Former Member

Hi,

Please help me on how to restrict users to update the item master price while giving them full authorization. I will only give list of users that can update the price, by using the notification.

i have tried below, but still i cant do it.

--RESTRICT CHANGING PRICE LIST TO SALES USER & MANAGER ONLY 10.27.11--
IF @OBJECT_TYPE = '4' AND @TRANSACTION_TYPE IN ('A','U')
IF EXISTS (SELECT 1
FROM OITM a inner join ITM1 b on a.ITEMCODE=b.ITEMCODE
inner join AITM c on b.ITEMCODE = c.ITEMCODE
WHERE a.ITEMCODE=@LIST_OF_COLS_VAL_TAB_DEL
AND a.ITEMCODE = b.ITEMCODE
AND b.PRICE <> b.PRICE
AND c.USERSIGN NOT IN ('19','20','21','22','23','24','25'))
Select @error =1,
@error_message = 'You are not authorized to update the Selling Price! by: IT Dept.'

Please help me.

Regards,

Jon

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers