Skip to Content
0
Former Member
Feb 19, 2009 at 10:24 PM

Help for Alert once AR Invoice booked to sales employees

34 Views

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