Skip to Content

Alert PO overdue date and Sales Invoice overdue payment terms

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 11, 2016 at 03:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded