AP Down Payment Request Alert

[Former Member]

Hi All,

I am looking to write a query that alerts when an AP Down Payment Request Is Due? Even due date - 1 Day would be fantastic.

I hope you can help,

Many Thanks,

James

[kothandaraman_nagarajan]

Hi,

Try this query,

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T0.[DocDueDate] FROM ODPI T0 WHERE Datediff(day, Getdate(), T0.[DocDueDate]) >= 1

Regards,

Nagarajan