Skip to Content

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