web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

What formula to use in payment condition for 45 days end of month - or 45 days first day of month

(0) ShareShare
ReportReport
Posted on by 17

Is There  a possibility to have a payment condition date formula in business central online version to calculate formula as 45 days end of month or beginning of month.

Example 

Date 6/2/2021 : payment condition 45D end of month => due date = 31/03/2021

or

Date 6/2/2021 : payment condition 60D first day of month => due date = 1/4/2021. You have the possibility to define the first day as D1 but can you combine it with 60D?

So there are two calculations to do, first count number of days/months and then go to end of this month or 1st of this month, or 10th of this month

I have the same question (0)
  • Indira88 Profile Picture
    980 on at

    Hi kristien,

    You could use CM+45 and CM-45

    by the formula CalcDate(CALCDATE('CM+45', TODAY)).

    Not sure but this maybe a solution let me know if it works.

    Indira

  • Dallefeld Profile Picture
    211 User Group Leader on at

    For your first example 45D+CM work , CM+45D give you April 14th because the calculation starts with CM and then does 45 days rather than 45D then CM or end of month.

    For your second example, 60D first day of month is an issue because 60 days puts you past the first day of the month. 60D+CM+1D gives you May 1st and 45D+CM+1D gives you April 1st.

    Hope this helps, please let us know.

  • kristien Profile Picture
    17 on at

    Hi Kim,

    This helps indeed.

    Thanks!

    Kristien

  • Suggested answer
    George Tsarev Profile Picture
    5 on at

    Example1: Date 6/2/2021 :  1M+CM        => due date = 31/03/2021

    Example2: Date 6/2/2021 :  1M+CM+1D => due date = 01/04/2021

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans