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

alert msg when add new po order

i want alert message when i will add new po order.

how can i do it?

i have written trigger after insert , but it's not working.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2007 at 07:57 AM

    Firstly, You are not suppose to use triggers with SBO.

    You will have to create a query and attach it to an Alert. How often you want the alert to go off can be set in the Alerts Management Window.

    A simple Query to give you DocNum, DocDate, CardCode for PO's created in that day would be

    SELECT T0.DocNum, T0.DocDate, T0.CardCode FROM [dbo].[OPOR] T0 WHERE DATEDIFF(DAY,T0.CreateDate, GETDATE()) = 0

    Save this Query. Then Go to Administration -> Alerts Management --- Open Saved Query and select this query, Click Active and select the user and check the Int checkbox to send an alert through SBO's internal messaging. You may set the frequency as desired.

    If you are using a flag to mark the PO as read / alert received then this flag can be added in the Where Clause of the Query so that the same PO's don't alert repeatedly.

    It all depends on your business need.

    Let me know if you need further assistance

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2007 at 06:39 AM

    Avijit,

    Please check Administration->System Initialization->General Settings -- Services tab and see Display Inbox when new message arrives is checked.

    This has to be checked.

    Try to set the priority on the Alert to high. Have you checked ACTIVE?

    Regarding the Read Flag. You may create a user field and set values Y and N and when the user has opened the PO / reviewed the PO can set this user field to 'Y'.

    In the query add an AND UserField <> 'Y'

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2007 at 10:16 PM

    The suggession I have for this it to keep the Alert coming for a set number of days.

    for example: DocDate + 5 days and base the alert of this.

    The Ultimate check would be to see if OPOR.DocStatus <> 'C' which is when PO received or Cancelled.

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 05:28 AM

    Martin,

    I request you to post the question as a new question for the benefit of the users and I will reply on that.

    Thanks

    Suda

    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.