Hi SIG,

No, I have often done this. Is the escalation service running? do other escalations trigger OK? Do you have any SQL Triggers on the company table that might be going against what you're trying to do?

Hi Matthew - thanks for the reply, yes the escalation service is running and other escalations are working ok, i do have a couple of SQL triggers on the company table but they dont go against the escalation rule that isnt working

this is my escalation trigger:
oppo_paidinfull_n is null and ( (oppo_invoicesentdate_n +60) < #T)   and comp_renewalun is null and Oppo_BookingType = 'MC' AND  Oppo_Status !='Cancelled'

ive set the escalation to run on table opportunity and view vOppoCompany

this is my escalation trigger:
oppo_paidinfull_n is null and ( (oppo_invoicesentdate_n +60) < #T)   and comp_renewalun is null and Oppo_BookingType = 'MC' AND  Oppo_Status !='Cancelled'

ive set the escalation to run on table opportunity and view vOppoCompany

This shouldn't be any different but just try the following, I've just changed a few elements of your query. Intrigued to see if this affects it in any way

oppo_paidinfull_n IS NULL AND DATEDIFF(Day,oppo_invoicesentdate,GETDATE())<60 AND comp_renewalun IS NULL AND oppo_bookingtype = 'MC' AND oppo_status <> 'Cancelled'

thanks Matthew - that worked!