Skip to Content
0
Former Member
Apr 18, 2010 at 12:32 AM

Aprroval for Invoice have due date greater than 100 days

53 Views

Hi all!

I would like to create query to approve for Invoice have due date greater than 100 days.

SELECT 'true' from OINV  where max(datediff(day, OINV.docduedate, getdate()))>100 and OINV.docstatus ='O' and  cardcode = $[$4.0.0] group by cardcode

It's not working. Can you help me!

Thanks!