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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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... / Recurring Frequency fo...
Small and medium business | Business Central, N...
Answered

Recurring Frequency formula for Month end

(0) ShareShare
ReportReport
Posted on by Chandra Moulee

Hi All,

Pls share the frequency (Date) formula for recurring journal that need to create entries at end of every month.

like 31/01/2022, 28/02/2022, 31/03/2022 like wise..

I have the same question (0)
  • Suggested answer
    Gavin Profile Picture
    Gavin 2,510 on at

    Hi,

    Can you try CM+1M. I've just tested and this works for me.

    pastedimage1671099378186v1.gif

    Hope this helps.

    Thanks
    Gavin

  • Chandra Moulee Profile Picture
    Chandra Moulee on at

    This formula is working in one of the sandbox - Recurring journal , able to post and creating next entries with next month end date.

    But its stop working in other sandbox - Recurring journal entry , stops at Feb - 2021

    pastedimage1671099951897v1.png

    getting this error while posting

    pastedimage1671100011251v2.png

    Dont know why this stuck here. Also allotted the amount.

    pastedimage1671100143147v3.png

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,423 Super User 2026 Season 1 on at

    hi

    look this

    community.dynamics.com/.../766125

    DAniele

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,812 Moderator on at

    You can go with below one.

    1D+1M-1D.

    Thanks.

  • Suggested answer
    Manan_Shah Profile Picture
    Manan_Shah 1,461 on at

    Hi Chandra,

    I suggest you can use "1M". it will always pick next date from currency month date. 

    For more details please check below attach link on this there is table with combination what result you get.

    https://thatnavguy.com/date-formula-in-business-central/


    pastedimage1671117217290v1.png

    Hope this will help. 

    Many Thanks,
    Manan

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    I agree with Nitin Verma

    1D+1M-1D

  • Chandra Moulee Profile Picture
    Chandra Moulee on at

    Thanks for the response.

    It is working now, but I tried this formula the other day, its was not working and unable to understand the reason behind it.

    Thanks

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May 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,222 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,603 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,186 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans