web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... What formula to use in...

Small and medium business | Business Central, N...

Answered

What formula to use in payment condition for 60 days end of month /paid first 5 days of month?

(3) Share

Report

Report

Posted on by CU19020939-0

22

What formula to use in payment condition for 60 days end of month /paid first 5 days of month?

If I have an invoice date 07.01.25 (dd/mm/yyyy), the due date must be 05.04.25 (dd/mm/yyyy). Are there any options to reflect this condition in BC?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, hope the following can give you some hints.

Dynamics 365 Business Central: About complex Due Date Calculations

https://yzhums.com/55211/

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Nitin Verma 21,698 Moderator on at

Like (2)

Report

Hi,

You can try this

CALCDATE('<CM+2M+5D>',070125D)

Was this reply helpful? Yes No
Verified answer

Yi Yong 2,555 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

Nitin is right, you can use "CM+2M+5D" on Payment Term's Due Date Calculation.

CM = Force the Due Date to the end of the current month

+2M = Add 60 days

+5D = Add 5 days (to be the fifth day of the month).

1 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,143

#2

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans