BC Tip #19 - Date Formulas for Posting Ranges in Business Central
- Ben Cole
- 1 day ago
- 6 min read
Updated: 9 hours ago
This is one of those Business Central features that looks small at first, and then you realize it can eliminate a bunch of monthly maintenance almost immediately.
With the 2026 Wave 1 Spring release, Business Central now supports date formulas for allowed posting dates in both General Ledger Setup and User Setup.
If you have been manually updating posting date ranges every month, this is the kind of improvement that makes you wonder why it did not exist years ago.
The big win is simple: instead of entering static posting dates and changing them over and over, you can now use formulas that automatically roll forward with the calendar.
For a full rundown on date formulas - check out the resources at the end of this post.
Table of Contents
Why this feature matters
Posting date controls are important for finance teams. They help prevent transactions from landing in the wrong period, support cleaner month-end processes, and reduce the chances of accidental future posting.
The problem has always been the upkeep. If your allowed posting dates were fixed values, someone had to remember to update them each month. If they forgot, users would run into posting errors as soon as the new month started.
Date formulas solve that problem.
Less manual maintenance
Fewer support tickets at the start of a new month
Better posting controls
More flexibility for user-specific exceptions
Using date formulas in General Ledger Setup
A very practical starting point is to limit posting to the current month only.
In General Ledger Setup, use the new formula fields for the posting date range:
Allowing Posting From DateFormula | -CM |
Allow Posting To - DateFormula | CM |
If you do not immediately see these fields, click Show More / Show Less. Depending on your page layout, they may not be visible by default.
What the formula means
-CM | Returns the First Day of the Current Month |
CM | Returns the Last Day of the Current Month |
Together, those settings create a posting window that starts on day one of the current month and ends on the final day of the same month.
The really nice part is that this is dynamic. When the month changes, Business Central recalculates the range automatically. No one has to go back into setup and update the dates manually.
Important warning: static dates and formulas do not mix
There is one behavior to be aware of right away.
You cannot keep both a specific date and a date formula populated for the same posting limit. Business Central only allows one method at a time. If you enter a formula, the matching fixed-date field will be cleared. If you enter a fixed date, the formula field will be cleared.
That makes sense once you know it, but it is worth calling out because it can be confusing the first time you test the feature.
How the current-month setup works in practice
Using -CM and CM is probably the most common use case for many organizations.
It gives you a clean way to say:
Users can post inside the current accounting month
Users cannot backdate into older periods
Users cannot post into a future month
That is a strong default control for day-to-day accounting, especially if you want your system to keep pace with the calendar without manual intervention.
When we go from June 30th to July 1st we do not have to rely on an administrator to change those dates manually. It will automatically update the range to now be July 1st to July 31st as an example.
Handling Exceptions in User Setup
Of course, not everyone should always have the exact same posting window.
That is where User Setup becomes useful. You can apply date formulas at the user level when a particular person needs a wider range than the standard rule in General Ledger Setup (think of it basically overriding the global settings we just created).
A good example is allowing a specific user to post in both the current month and the previous month.
For that user, set:
Allow Posting From DateFormula | -1M-CM |
Allowing Posting To DateFormula | CM |
What that configuration does
This setup opens the posting window from the beginning of the previous month through the end of the current month.
In practical terms, that means the user can:
Post in last month
Post in the current month
Not post beyond the end of the current month
That is a great fit for users who need a little extra flexibility for cleanup, corrections, or late entries, without giving them access to future posting periods.
-1M tells the system to go back 1 month from today and then -CM tells the system to give us the first day of that month. For more information date formulas, check out my blog post.
What happens when someone posts outside the allowed range
Once these formulas are in place, Business Central enforces them just like any other posting control.
If a user posts within the allowed range, everything works as expected. If they try to post outside that window, such as into a future month when their posting limit stops at the current month, Business Central blocks the transaction and returns an error.
That gives you a much more controlled and predictable posting process without having to babysit date settings every month.
A simple setup strategy that will fit most companies
If you want a practical way to roll this out, start with a basic two-layer approach:
In General Ledger Setup, use formulas that restrict everyone to the current month.
In User Setup, create exceptions only for the people who need access to the prior or future months.
That gives you strong default controls while still allowing flexibility where it is actually needed.
Why this feature is such a win
There are plenty of large features in every release, but sometimes the most valuable enhancements are the ones that remove repetitive admin work.
Date formulas for posting ranges do exactly that.
Instead of relying on someone to remember month-end maintenance, you can let Business Central calculate the right posting period automatically.
That means fewer interruptions, cleaner controls, and less time spent fixing avoidable posting-date issues.
For finance and ERP admins, that is a very real quality-of-life improvement.
Date Resources
For more information on Date Formulas - Check out the below links:
FAQ
Where can date formulas for posting ranges be used in Business Central?
You can use them in both General Ledger Setup and User Setup. This allows you to define a general posting rule for everyone and then override it for specific users when needed.
What does -CM mean in an allowed posting date formula?
-CM returns the first day of the current month. It is commonly used as the starting point when you want users to post only within the current month.
What does CM mean in an allowed posting date formula?
CM returns the last day of the current month. It is often used as the posting end date to prevent future-dated entries beyond the current month.
Can I use both a fixed posting date and a date formula in the same field?
No. Business Central only allows one method at a time. If you enter a date formula, the fixed-date field is cleared. If you enter a fixed date, the formula field is cleared.
How do I allow a user to post in both the current and previous month?
In User Setup, set the allowed posting from formula to -1M-CM and the allowed posting to formula to CM. That creates a window that starts at the beginning of the previous month and ends at the end of the current month.
What happens when the month changes?
Business Central recalculates the posting window automatically based on the formula. That means the allowed range updates with the new month without manual changes.
What if I do not see the date formula fields?
Check whether the page is hiding additional fields. In some cases, you may need to select Show more to reveal the new formula fields.
If you are still manually adjusting posting ranges at the beginning of every month, this is a great time to stop. Set the logic once, let Business Central do the work, and keep your posting controls consistent without the recurring maintenance.
Ready to optimize your Business Central environment with guidance from a BC expert?
Contact Ben Cole at Ben@BenColeBC.com or (214) 433-0923.
Don't forget to subscribe so that you never miss a weekly tip.
Ben Cole is passionate about making Microsoft Dynamics 365 Business Central work smarter for real people—users and partners alike. With roots in public accounting, Ben’s seen firsthand how automation and clever solutions can transform the Business Central experience. He’s known for breaking down complex topics with a dash of wit and plenty of practical advice. If you want to get more out of Business Central (and maybe even enjoy the process), Ben’s your go-to guide.
(214) 433-0923
