Hi all,
I have made an alert in which when a sales invoice is added to the system an automayic alert goes to the sales employee but the problem is that when the sales employee logs in, he get the complete full as on date ar invoices which are been made into the system which includes old invoices.
SELECT T0.[DocNum], T0.DocDate,T0.[CardCode], T0.[CardName], T0.[OwnerCode], T0.SlpCode,T1.[lastName]' 'T1.[firstName] as Creater
FROM OINV T0 INNER JOIN OHEM T1 ON T0.OwnerCode = T1.empID
WHERE T0.[SlpCode] =1
I want that in the alert invoices should come from e.g 01/02/2009 onwards. Also when the sales employee gets and sees the alert, it should automatically get removed from the alert list of the sales employee.
How to achive this...Kindly help please
Regards
Kamlesh