Skip to main content

Notifications

Announcements

No record found.

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 4,401

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 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

    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

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 74,141 Super User 2024 Season 2 on at
    RE: 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

    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
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: 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

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

    Do 1M+CM.

  • Suggested answer
    RodRodriguez Profile Picture
    RodRodriguez on at
    RE: 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

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

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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: 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

    I would try CM+1M

    CM should not be prefixed with a number

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans