Skip to Content
0

Alert PO overdue date and Sales Invoice overdue payment terms

Nov 10, 2016 at 04:19 PM

60

avatar image

Dear Experts,

I will like an alert for SA Business One, that will send an alert when a Purchase order date is overdue for 7days and a sales invoice alert for overdue payment days.

Regards

Justice

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

1 Answer

Edmund Leung Nov 11, 2016 at 03:16 AM
0

Dear Justice

create two queries and two alerts

SELECT 'TRUE', docentry, 'PO overdue 7 days' from opor where docstatus='O' and docdate<DateAdd(DD,-7,getdate() )

SELECT 'TRUE', docentry, 'ARI overdue payment days' from OINV where docstatus='O' and docduedate<getdate()

Regards

Edmund

Share
10 |10000 characters needed characters left characters exceeded