alert msg when add new po order

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

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

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

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