Finance - Payment Terms Due Date Calculation Formula

Primer on basic date calculations:

C = Current
D = Day
W = Week
M = Month
Q = Quarter
Y = Year
CD = Current Day
CW = Current week
CM = Current month

10D = 10 days from today
2W = 2 weeks from today

D10 = The next 10th day of a month
WD4 = The next 4th day of a week (Thursday)

CM+10D = Current month + 10 days

-1Y = 1 year ago from today

Example:

Example on due date calculations:

Example on complex due date calculations:

Case example 1 - yearly due date

a) if document date is before July 31, the due date is Jul 31 of the year.

b) if document date is after Jul 31, the due date is Jul 31 of the following year. 

Calculation formula can be 5M-CY+7M-1D, calculation b/d as below:

a) Document Date before Jul 31

b) Document Date after Jul 31

Case example 2 - quarterly due date

a) due date on 1st Monday after beginning of the next quarter from the document date

Calculation formula can be 3M-CQ+WD1, calculation b/d as below:

Reference: 

https://docs.microsoft.com/en-us/dynamics365/business-central/ui-enter-date-ranges#using-date-formulas