Alert Management

[Former Member]

Whenever users changed one particular UDF (U_VALUE) value to 'Yes' in sales quotation (OQUT), I want SAP to pop out a alert with notification message.

I assume this can be accomplished by using the alert function(Administration > Alerts Management).

If I need to create a new per-defined alert, I guess I'd need to create a new query to link to the alert.If so, what will be the query looks like?

[Former Member]

Hi,

Try:

SELECT T0.[DocNum], T0.[DocStatus], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[DocTotal]

FROM OQUT T0 WHERE T0.U_VALUE = 'Yes' and DateDiff(dd,T0.UpdateDate,GetDate())<3

Thanks,

Gordon

[Johan_H]

Hi Ken,

Just to make sure that the alert does not keep returning all quotations every time, and only gives you relevant information, I would suggest an adapted version of Malhaar's query:

SELECT DocNum /*<-- Gives you the drill down link to the quotation*/
, DocDate  /*<-- The date the quotation was made */
, DocDueDate /*<-- The date until which the quotation is valid */
, CardCode /*<-- The customer number */
, CardName /*<-- The customer name */
, DocTotal /*<-- The total value (inc. VAT) of the quotation */
FROM OQUT
WHERE U_VALUE = 'YES'
      AND DocStatus = 'O' /*<-- Only open quotations */
      AND DocDate > DATEADD(days, -7, GETDATE()) /*<-- Only quotations that are maximum a week old */

Regards,

Johan

[former_member218051]

Hi Ken,

Select * from oqut where u_value = 'YES'.

alert derives the result from the saved records. If you just want to know about the documents where change has occured then this is ok.

If you want to validate something atthen alert won't help you.

Please clarify your purpose.

thanking you

malhaar

[Former Member]

All I want to do is if users select 'Y' for u_value, it will trigger some kind of message to warn users about the consequences. It does not need to validate anything. Just need to notify users. Is alert the best way to handle this or there's a better way?

[former_member218051]

Hi Ken,

If you want the system to alert the user about his selection at run time then you have to do this through Add On.

Because as I said alert will give you the list of quotations where user have selected Yes for that UDF. It will not notify the users of their selection at run time.

At the most in the defination of the UDF you can set the defaule value to No so as to take the benefit of user having missed to select the field.

thanking you

malhaar

[former_member186095]

Hi,

you can use alert management but it will work only after the sales quotation has been created or added.

So, the system will work based on the query's condition i.e when T0.U_VALUE = 'Yes'.

But you must remember that alert will shows the alert every days and it will make slow performance to SAP B1 system except you make another condition e.g. docstatus is still open.

SELECT a.docdate, a.DocNum, a.DocStatus, a.CardName, a.DocTotal

FROM OQUT a WHERE a.U_VALUE = 'Yes' and a.docstatus = 'o'

After the sales quotation status is closed because it is copied to sales order, the alert won't appears in the alert messages window anymore.

JimM