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.
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.
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
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
Don't put 1 in front of CM. There is no number on CM.
Do 1M+CM.
Have you looked here for setting the recurring frequency in periodic (recurring) journals?
I would try CM+1M
CM should not be prefixed with a number
André Arnaud de Cal... 291,419 Super User 2024 Season 2
Martin Dráb 230,492 Most Valuable Professional
nmaenpaa 101,156