Skip to Content
0
Former Member
Aug 04, 2016 at 12:35 PM

ALert message scheduling after every 4 hours in SAP B1

123 Views

Hi Experts,

My customers needs every 4 hours alerts needs to come.

For example, invoice is greater than $5000 then particular user needs that alert for every 4 hours.

i have created and scheduled but it didn`t comes correctly .

if the end of the day, they logout of sap b1 then tomorrow if their login again it should shows maxmium of 4 alerts but don`t show any alert

after the logout of previous day.

Kindly suggest me.kindly find the attachment.

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[DocCur], T0.[DocTotal]

FROM OINV T0 WHERE T0.[DocTotal] >5000 and T0.DocDate between DATEADD(mm,-1, getdate()) and GETDATE()

order by t0.docdate desc

Attachments

fd.png (11.0 kB)