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