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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / ERROR: Your entry of &...
Small and medium business | Business Central, N...
Answered

ERROR: Your entry of '1M + 1 CM' is not an acceptable value for 'Recurring Frequency'. The date formula '1M + 1 CM' should include a time unit. Time Units can be D, WD, W, M, Q, or Y.C. In Navision 2018

(0) ShareShare
ReportReport
Posted on by joshtechsolutions 4,979

Hi Community,

While using Recurring Journal, I tried to put 1 M + 1CM in the Recurring Frequency and I was ported this message.

Please advise how can I put 1 M + 1 CM. Thank you.

pastedimage1650250325704v1.png

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 Moderator on at

    I would try CM+1M

    CM should not be prefixed with a number

  • Suggested answer
    RodRodriguez Profile Picture
    RodRodriguez on at

    Have you looked here for setting the recurring frequency in periodic (recurring) journals?

    docs.microsoft.com/.../post-periodic-journals

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    Don't put 1 in front of CM. There is no number on CM.

    Do 1M+CM.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 95,729 Super User 2025 Season 2 on at

    Hi, Here are some examples of date formulas

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

    Letter Meaning
    C Current
    D Day(s)
    W Week(s)
    M Month(s)
    Q Quarter(s)
    Y Year(s)
    Expression Meaning
    CW Current week
    CM

    Current month
    Expression Meaning
    10D 10 days from today
    2W 2 weeks from today

    Expression Meaning
    D10 The next 10th day of a month
    WD4

    The next 4th day of a week (Thursday)
    Expression Meaning
    CM+10D

    Current month + 10 days
    Expression Meaning
    -1Y 1 year ago from today

    Hope this also helps.

    Thanks.

    ZHU

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Josh,

    The entry should be 1M+1CM with no spaces. Never put spaces between the number and letter.

    Here are more Date Formulas:

    Date Formula

    Resulting Date

    Description

    Notes

    1D+1M-1D 

    9/30/13 (Sunday)

    Last Day of a Month

    This should be used when creating Recurring Reversing entries

    CW

    9/29/13 (Sunday)

    Returns the last date of the current week

     

    CM

    9/30/13 (Monday)

    Returns the last date of the current month

     

    CQ

    9/30/13 (Monday)

    Returns the last date of the current quarter

     

    D15

    10/15/13 (Tuesday)

    Returns the next 15th of the month

     

    D15 + 1M

    11/15/13 (Friday)

    Returns 1 month after the next 15th of the month

    Same result as 1M + D15

    1M + D15

    11/15/13 (Friday)

    Returns 15th day after the date is advanced 1 month

    Same result as D15 + 1M

    1M – 15D

    10/10/13

    Returns the date 15 days less than a full month after reference date

     

    1M + 15D

    11/9/2013

    Returns the date 15 days more than a full month after reference date

     

    CM +1D

    10/1/13 (Tuesday)

    Returns the 1st of the following month

     

    CM+1M

    10/30/13 (Wednesday)

    Returns the last date of the current month advanced by one month

    If the reference date had been 02/23/2013 the returned date would be 03/28/13

    CM + D10 + 90D

    1/8/2014 (Wednesday)

    Returns a date 90 days after the next 10th of the month

     

    1M+CM

    10/31/13 (Thursday)

    Returns the last date of the following month

    If the reference date had been 02/23/2013 the returned date would be 03/31/13

    CW+1D

    or

    CW+WD1

    9/30/13 (Monday)

    Returns the Monday of Next Week

     

    CW+5D

    or

    CW+WD5

    10/4/2013 (Friday)

    Returns the Friday of Next Week

     

    CW+1D+3W

    10/21/2013 (Monday)

    Returns 3 Weeks from Next Monday

     

    CW-1D

    9/28/2013 (Saturday)

    Returns Saturday of This Week

    If the reference date had been 09/29/2013 (Sunday) the returned date would still be 09/28/2013. The week starts on Monday in NAV.

    D15+WD1

    10/21/13 (Monday)

    Returns the Monday after the next 15th of the month

     

    WD4 + 6W

    11/7/13 (Thursday)

    Returns the Thursday 6 weeks after the next Thursday.

    Imagine a vendor that ships only once a week with a long time in transit.

    Hope this helps.

    Thanks,

    Steve

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans