ALERT MESSAGE FOR INCOMING PAYMENTS

[Former Member]

Hi Experts,

I want a query to help me create an alert message to a particular user immediately a payment is added.

And the alert or query should show the payments made and the invoice number of the payment made.

So in all ,the query message should send the user an alert immediately a payment is added and the amount paid should be displayed and also the invoice number of the particular invoice the payment is made to.

A prompt reply and solution to this will be much appreciated

Regards

Justice

[Former Member]

hi all,

does that mean I don't have to do settings in the alert management?

if I have to do I tick the "send alert for activities scheduled today"?

do I have to schedule the minutes too in alert management if this update message in general settings is scheduled?

@nagarajan please your queries works too.

Regards

Justice

[kothandaraman_nagarajan]

Hi,

Have you tried with my query?

Not possible to trigger immediately, at least system needs one minute. But from the experience from this forum, minimum Five minutes required to receive the alert.

Thanks & Regards,

Nagarajan

[Former Member]

@raviraj,the doctotal display has been done by myself,

all i want now is the trigger or alert to go to a particular user immediately the incoming payment ass button is clicked.

using alert management to schedule keeps recurring  the message several times.

Regards,

Justice

[Former Member]

Hi Justice,

Try for this setup in General Setting:

GBU

[Former Member]

Hi Justice,

You can set 1 min in 'Update Messages (Min.)' field in service tab of general setting as said by Toan.

Definitely some time required to trigger alert by system.

regards,

Raviraj

[Former Member]

Hi Experts,

@Raviraj, your query works but i want to see the doctotal field from the invoice so that when a part payment is done on the incoming payment i will see  both the Paid to invoice and the doctotal.

Also, we want the alert to be automatic ,immediately the "add button" is added on the incoming payment without scheduling in the alert management.

Because when it is scheduled in the alert management the messages recur and the customer does not like it that way.

Your urgent help on how to automate the alert without scheduling and without recurring will be much appreciated.

Regards,

Justice

[Former Member]

Hi Justice

Try Below Alert Query & let me know result

SELECT T0.[DocNum]ReceiptNo,T0.[CardCode],T0.[DocDate]ReceiptDate,

case when T1.[InvType]=13 then (select docnum from oinv where docentry=T1.[DocEntry])

when T1.[InvType] in (30,-2) then (select Baseref from ojdt where transid=T1.[DocEntry])end InvNo,

T1.[SumApplied] FROM ORCT T0  INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum  WHERE convert(varchar(20),T0.[docDate],103)  =(select convert(varchar(20),getdate(),103))

regards,

Raviraj

[kothandaraman_nagarajan]

Hi,

Please assign below query in alert management:

SELECT T0.[DocDate], T0.[DocNum] as IncommingDoc#, T2.[DocNum] as Invoice#, T0.[DocTotal] as Amount FROM ORCT T0  INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum left join  OINV T2 on t1.docentry = t2.docentry and T2.[ObjType]  = T1.[InvType] WHERE T0.[DocDate]  = CONVERT(VARCHAR(10),GETDATE(),110)

Thanks & Regards,

Nagarajan

[venkateswaran_k]

Hi

Do you want it to send it as an email notificiation?

Regards,

Venkat

[Former Member]

hello ,

i want it to send both internal alert message and email.