alert msg when add new po order

[Former Member]

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.

[former_member583013]

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

[former_member583013]

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

[former_member583013]

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

[Former Member]

Hi ! Suda,

thank you for your suggestion.

We had few problem in server , now we solve that .And now Alert is working

But problem regarding flag.

here multiple user can see this message. so if one user open that alert message

and set flaf as Y, i think in that case other user can't see that message.

Avijit

[Former Member]

Suda,

Is there a way to have the alert execute only once - even if the user has opened the PO or not?

[former_member583013]

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

[Former Member]

Thank's Suda,

I have tried but it's not response.

Sql query is working but alert msg is not working.

in alert msg i have set 1 minute freqency.

still i am not geting any response.

Another issue-

how i am using flag to mark the PO as read / alert received y.

Regards,

Avijit

[Former Member]

Suda

Can we send an alert every time a PO is created? Can you drive the query based on the document number or else instead of the date?

Martin