cancel
Showing results for 
Search instead for 
Did you mean: 

Alert Query for Sales Opportunity

Former Member
0 Kudos
550

Hi,

I am trying to determine if it is possible in SAP B1 to setup an automatic alert message to be sent to any user for each creation and update of Sales Opportunity.

Please advise what query shall I use. Many thanks.

Regards,
Khurram

View Entire Topic
kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Run the below query under query generator and save it under query manager.

SELECT T0.[CardCode], T0.[CprCode], T0.[SlpCode], T0.[OpenDate], T0.[Status], T0.[CardName], T0.[CloseDate], T0.[Name] FROM OOPR T0 WHERE T0.[Status] = 'o'

Open alert management and assign saved query.