Skip to Content
0

AP Down Payment Request Alert

Sep 25, 2017 at 09:39 AM

36

avatar image
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

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nagarajan K Sep 25, 2017 at 12:14 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded