Skip to Content
avatar image
Former Member

SAP B1 Item MAster Price

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers