Skip to Content
avatar image
Former Member

AP Down Payment Request Alert

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 25, 2017 at 12:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded