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

Alarm or notice when a Document is created

I need to create an alarm ,message or notice when a document is created. Especially when a Good Receipt PO is created, I need an alarm or message to a specific user in SBO. Any help?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 12:12 AM

    Hi Hector ,

    Try this as sample

    SELECT Top 1 T0.[DocNum], T0.[CardCode], T0.[CardName] FROM OPDN T0 WHERE T0.[DocStatus] ='o' ORDER BY T0.[DocNum] Desc

    1. save this query

    2. Go to administration >.alert maangement

    3. create a alert using this query

    Hope this helps

    Bishal

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Hector

      I realise id that means

      SELECT Top 1 T0.DocNum, T0.CardCode, T0.CardName FROM OPDN T0 INNER JOIN OHEM T1 ON T0.OwnerCode = T1.empID WHERE T0.DocStatus ='o' and T1.empiD ='1' ORDER BY T0.DocNum Desc

      OHEM .empid is stored in Human resources modules >> considering the empID 1 is owner of the purchase order.

      By the way

      What do you mean by sole document ? Can you explain what exactly(field)

      you want to see in the alert ?

      Actually with the yellow arrow you can see the detail of the report by drill down

      Thank you

      Bishal

      Edited by: BIshal Adhikari on Dec 17, 2008 5:27 PM

      Edited by: BIshal Adhikari on Dec 17, 2008 5:36 PM

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 12:08 AM

    You can check this thread, the same question asked quite a few times. The table you are looking for is OPDN:

    how-to-set-alert

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 01:40 AM

    Hi

    I have edited my answer .Hope this meets requirement

    Thank you

    Bishal

    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.