Create an Alert to Certain User if Someone Add/Edit Business Partner Master Data

[Former Member]

Hi Guys,

So i've been trying to make an approval if someone add/edit Business Partner Master Data.
I've been search about it and it's not possible. The alternative way to my case is create an Alert to the top management.

So, could you help me how to create an Alert to certain user (my boss) if someone add or edit the BP Master Data in SP Transaction Notification.

Thanks in advance,
Irwan

[kothandaraman_nagarajan · Accepted solution]

Hi,

It is possible to create an alert when adding new BP and you can assign this alert to your boss user ID.

SELECT T0.[CardCode], T0.[CardName], T0.[CardType] FROM OCRD T0 WHERE Datediff(day, T0.[CreateDate], getdate()) = 0

It is possible to block updating of BP. but it is not possible to send to your boss.

SELECT T0.[CardCode], T0.[CardName], T0.[CardType] FROM OCRD T0 WHERE datediff(day, T0.[UpdateDate] ,getdate()) = 0

You can use alert for creating new user and updating existing BP.

Regards,

Nagarajan