Page History

Create Payment Terms

1, Use search function to find Payment Terms

2. Enter the Payment Terms Code

3, Enter the Due Date Calculation (please refer to the section Due Date Calculation Formula for details)

4. Enter Discount Date Calculation and Discount % if any

5. Enter the Payment Terms Description.

Image Added

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 todaytoday 
2W = 2 weeks from today

D10 = The next 10th day of a month (e.g. 10th date of every month)
WD4 = The next 4th day of a week (Thursday) (e.g. Thursday of every week)

CM+10D = Current month + 10 days

-1Y = 1 year ago from today

...

Due Date Formula example

Due date calculation example

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