Skip to Content
author's profile photo Former Member
Former Member

Alert Management

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Apr 27, 2012 at 04:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Apr 27, 2012 at 06:27 AM

    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 OQUTWHERE 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 27, 2012 at 01:08 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.