Alert management query for massage for every delivery creation

[Former Member]

I want to create the alert message for every delivery creation to AR invoice team.

Help me for this query.

Anantha Desai

91-9845721048

[Former Member]

Hi Anantha,

There is no such option to get exact alert from B1 system function. You may set up an alert by a frequency such as every 30 minutes. The 2 alerts above should work. I prefer the 2nd one.

If you have B1UP addon, it is doable.

Thanks,

Gordon

[Former Member]

Thanks to Gordon and Deepak. I have added the second alert in system.

Still waiting for remarks from end user.

[former_member196081]

Hi

Try below

SELECT T0.DOCNUM AS 'Delivery No', T0.DOCDATE AS 'Posting date Date',T0.Cardname AS 'Customer Name'

FROM ODLN T0 WHERE datediff(day,T0.createDATE,GETDATE())=0 and t0.docstatus = 'O'

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM ODLN T0  INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocDate]  = CONVERT(VARCHAR(10),GETDATE(),110)

Thanks & Regards,

Nagarajan