SQL Script – Calculate Due Date

Script #1

Last day of Due date month

Update ARInvoice
Set DueDate = DateAdd(day, -1, DateAdd(month, 5, DateAdd(day, 1 – day(Docdate), DocDate)))
Where DisplayTerm = ’60 NETT’

Script #2

Number of days calculate from last day of invoice date

Update ARInvoice
Set DueDate = dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 – day(Docdate), DocDate))) + 120
Where DisplayTerm = ’60 NETT’