Dynamics 365 Business Central: About complex Due Date Calculations

Hi, Readers.
Last week we briefly discussed how to get Start Date and End Date (Period) of the week/month/quarter/year (Includes last and next) from a given date, and today I would like to continue discussing questions about dates, complex Due Date Calculations.

Due date in Business Central is the date when something is due to be paid. You can find this field in Sales Documents, Purchase Documents, Service Documents, etc. For example, on the Sales Order page.

Due Date
Specifies when the related sales invoice must be paid.

The Due Date will also be displayed in the Customer Ledger Entries and will be displayed in red if the date has passed.

This is calculated based on the currently set Work Date.

And it is important to note that the Due Date is calculated by default based on the Document Date and Payment Terms Code, not the Posting Date.

table 36 “Sales Header”:

The calculation formula is set in Due Date Calculation field on the Payment Terms page.

Due Date Calculation
Specifies a formula that determines how to calculate the due date, for example, when you create an invoice.

As for how to use the date formula, you can refer to the instructions in MS Learn below.
Work with Calendar Dates and Times -> Use Date Formulas: The date formula can contain a maximum of 20 characters, both numbers and letters. You can use the following letters, which are abbreviations for calendar units.

You can construct a date formula in three ways.
The following example shows how to use C, for current, and a time unit.

The following example shows how to use a number and a time unit. A number cannot be larger than 9999.

The following example shows how to use a time unit and a number.

The following example shows how you can combine these three forms as needed.

The following example shows how you can use a minus sign to indicate a date in the past.

So we can easily do the following standard example.

Let’s look at something a little more complicated.

As far as I know, there is almost no concept of payment cut-off date for the current month in Europe and America, for example, Cut-off date: 5th every month, The payment: End of the month. Invoices before the 6th of the current month will be paid by the end of the month, and invoices after the 6th of the current month will be paid by the end of the next month, which is very common in countries such as Japan and China. Of course, this can also be done in Business Central.

8/5/2024:

8/6/2024:

More examples:

The above table covers almost all the examples, hope it can give you some help.
Give it a try!!!😁

END

Hope this will help.

Thanks for reading.

ZHU