Dispatch alert to Sales employee

[Former Member]

Hi,

I have sales employee who have their B One login.

I want to send alert to this employee whenever delivery is added.

Details to be displayed in alert must be delivery number, customer name, delivery date, Item number, name and quantity.

Any one guide me with the query for the same

[Former Member]

Hi Prince....

try this....

SELECT T0.[DocNum], T0.[CardName], T0.[DocDate], T1.[ItemCode], T1.[Dscription], 
T1.[Quantity] FROM ODLN T0  INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry
Where DateDiff (dd, T0.DocDate,Getdate())=0

Save above query and assign it as an alert for the User who punches Delivery.

This will alert for the Current Date Deliveries......

For back dates Deliveries it will be stopped.....

Regards,

Rahul

[Former Member]

Thanks Rahul,

One more help can i control the frequency for alert. I want the user to get alert only one time after addition of delivery.

Pls guide

[Former Member]

Yes you can by doing some work around like you have to pass the value in terms of time so that when user adds the document then say after one or two minutes he gets an alert when system time is equal to entered time....

Regards,

Rahul

[Former Member]

Hi rahul,

can you pls add the details in query. lets say i have to send alert after 5 mins of addition of delivery. pls help

[Former Member]

Hi Prince,

The way to do the timing thing is, you assign the above query to AlertManagement(in Admin module), activate it, assign it to staff that picks, and you have a field for assigning the frequency at which an alert needs to be sent.

I tried it and it works. As soon as delivery is added, I had a timer of 1 minute, and the alert is raised on delivery persons's client at one minute.

[Former Member]

Hi Sayed,

You are right i have already tried with the frequency it is working fine.

As example given by you after delivery is posted after 1 min alert is received in the required staff ID. But my concern is the

alert keeps on poping up after every 1 min. How to stop this alert after receiveing.

[Former Member]

Hi Prince......

You can have this work around in order to stop the Alert keep on generating.

Just create an UDF at Delievry level say U_Status and give deafault values as OK/Not OK

Once when user creates Delivery initially Status UDF is Not Ok. when he gets first alert then he has to go to the delivery and make the status OK manually which will intimate that he has gone through this delivery by alert and he has made it OK......

So the Alert will be stopped.....

Hope this would be feasible for you........

Regards,

Rahul

[Former Member]

Hi Prince, that query in alert is a powerful functionality. Can be used for many a things.

With regards to user getting alerted too much, reduce the frequency and uncheck the history. If history is unchecked, then the alert buffer will not build unless it is new delivery.

This way, the users the shippers will look at it at their own convenient time, the computer may mildly beep, so what, the buffer will not increase unless it is a new delivery.

Hope it helps out your client. This is not the best solution but way cheaper than many add-ons you can buy just for alert management. This comes free with SAP B1.