New in Business Central: Automate Posting Periods with Date Formulas

Microsoft continues to introduce practical improvements to Dynamics 365 Business Central, and one of the latest additions is a particularly useful one for finance teams.

As part of Business Central 2026 Release Wave 1, Microsoft introduced new Date Formula fields for posting periods, giving organisations a new way to control when users are allowed to post transactions.

Until now, many businesses have relied on fixed Allow Posting From and Allow Posting To dates. These work well, but if your permitted posting period changes every month, somebody has to remember to update those dates each time.

The new functionality changes that.

Business Central can now use dynamic Date Formulas to calculate permitted posting periods automatically based on the Work Date.

So instead of setting:

1 September – 30 September

and then manually changing it again in October, you can create a rule that effectively says:

“Allow posting for the current month.”

Business Central then works out the relevant dates for you.

It is one of those Business Central enhancements that may sound relatively small on paper, but for finance teams regularly maintaining posting periods, it could remove another repetitive task from the month-end process.

In this article, we’ll look at what’s new, how posting Date Formulas work, why they matter and what you should consider before using them.

What’s new with posting periods in Business Central?

Microsoft has added two new fields that give finance teams the option to create dynamic posting periods rather than relying entirely on fixed dates:

Allow Posting From Date Formula

Allow Posting To Date Formula

These fields are available in General Ledger Setup, User Setup and General Journal Templates.

Rather than entering a specific date, you enter a formula that tells Business Central how the permitted posting period should be calculated.

Think of it as changing the instruction from:

“Users can post between 1 September and 30 September.”

to:

“Users can post during the current month.”

With the first approach, somebody needs to update the dates when October arrives.

With the second, Business Central calculates the relevant dates automatically.

How do Business Central posting Date Formulas work?

A Date Formula is simply a rule that Business Central uses to calculate a date.

For example, you might want users to be able to post:

• during the current month only;
• within the previous 30 days;
• from one month ago until one week ahead; or
• only on the current Work Date.

Rather than entering the dates that achieve that range manually, you enter the relevant formula.

Business Central then evaluates that formula each time a posting date is validated.

The examples below show how different Date Formulas can automatically create posting windows based on the relevant date in Business Central.

The simplest example is Current month only.

If the Work Date is 17 March, Business Central can calculate a permitted posting period of:

1 March – 31 March

When the Work Date moves into April, the same rule can calculate the April period instead.

There is no need for somebody to manually replace March’s dates with April’s dates.

One point worth clarifying is that Microsoft’s earlier release information referred to calculations against “today’s date”, while the current Business Central product documentation states that posting Date Formulas are evaluated against the Work Date. For customers using the feature in practice, Work Date is therefore the important reference point to understand.

Why does this matter to finance teams?

At first glance, updating two dates once a month might not seem like a major administrative burden.

But ERP systems are full of small, repetitive jobs like this.

If you operate several Business Central companies, have different posting restrictions for different users, or regularly manage your accounting periods, those tasks soon add up.

There is also the question of consistency.

Posting restrictions help prevent transactions being entered into periods finance does not want users to access. If the dates are not maintained when they should be, the permitted period may no longer reflect the policy finance intended.

Using Date Formulas means a recurring posting rule can be configured once rather than recreated every accounting period.

For finance teams, that can mean:

• less routine month-end administration;
• more consistent recurring posting windows;
• fewer issues caused by outdated posting-date settings; and
• easier maintenance of posting periods across users and companies.

Microsoft describes the new capability as a way to reduce maintenance effort and help prevent posting errors caused by outdated restriction settings.

A simple before-and-after example

Imagine your finance team wants most users to post only into the current accounting month.

Previously, the setup might look something like this:

September:
1 September – 30 September

Then, when October arrives, somebody changes it to:

October:
1 October – 31 October

And again in November:

November:
1 November – 30 November

With a Date Formula, the rule can instead effectively be:

Allow posting from the start of the current month to the end of the current month.

Business Central then works out the actual dates.

It is the difference between maintaining the dates and configuring the rule behind the dates.

Can different Business Central users have different posting periods?

Yes.

This is another useful aspect of the new functionality because the Date Formula fields are also available through User Setup.

An organisation may, for example, want most employees to work within a relatively narrow posting period while selected members of the finance team require access to a different range during month-end.

Business Central can therefore apply posting restrictions at user level as well as through the wider General Ledger Setup.

When Business Central checks posting restrictions, it evaluates them in this order:

1. User Setup
2. General Ledger Setup
3. General Journal Template, where the relevant journal setting applies.

This gives organisations more flexibility without having to abandon wider company-level controls.

Do you have to replace your existing fixed posting dates?

No.

Introducing Date Formulas does not mean every organisation should immediately replace all of its fixed posting dates.

Business Central allows you to combine the two approaches.

For example, you could keep a fixed Allow Posting From date but use a dynamic Allow Posting To Date Formula.

That might be useful if finance wants a firm lower boundary protecting previously closed periods while allowing the upper boundary to move automatically.

For each individual boundary, however, you use either a fixed date or a Date Formula. Entering a formula clears the corresponding fixed date, and entering a fixed date clears its formula.

One important consideration: the Business Central Work Date

There is one aspect of the new feature that organisations should understand before deciding how to use it.

Date Formulas are evaluated against the user’s Work Date.

The Work Date is a setting within Business Central that allows somebody to work as though they are operating on a particular date.

For example, a finance user completing September month-end activity in early October may still be working with a September Work Date.

If the Work Date changes, a dynamic posting period based on that Work Date can change too.

That makes Date Formulas more flexible, but it also means they should not automatically be viewed as a replacement for every fixed posting-date control.

Microsoft recommends using fixed dates where strict, administrator-controlled boundaries are required, and Date Formulas where the benefit of automatic period management is more important.

For some businesses, a combination of both approaches may therefore be the best fit.

A new Business Central feature worth knowing about

Posting Date Formulas are a good example of the type of practical improvement Microsoft continues to add to Business Central.

They may not fundamentally change how your finance function operates, but they can remove a recurring administrative task and make an existing control easier to maintain.

For businesses already using Business Central, that is often where some of the most useful improvements are found: not necessarily in completely new processes, but in making the processes you already rely on simpler and more efficient.

It also fits into a wider direction we are seeing from Microsoft.

Across its latest Business Central releases, Microsoft continues to focus on reducing repetitive administration, increasing automation and bringing more functionality into the standard product.

We explore that wider direction in our guide to Business Central 2026 Release Wave 2: What BC 29 Means for Business, including the continued focus on finance automation and helping users spend less time on repetitive processing.

For existing Business Central customers, enhancements like this are a useful reminder that getting more value from your ERP system does not always mean implementing something completely new.

Sometimes, it is simply about finding a better way to handle something you are already doing.

Should your business use dynamic posting periods?

That will depend on how your organisation currently controls posting periods.

If somebody in your finance team is manually updating the same posting dates month after month, this new functionality is certainly worth reviewing.

You may find that a Date Formula can simplify the process.

Equally, where your organisation needs firm posting boundaries that users should not be able to influence through their Work Date, fixed dates may still be the more appropriate option.

The important thing is understanding the difference and choosing the approach that best reflects your financial controls.

At The HBP Group, we help Business Central customers understand new Microsoft functionality and, more importantly, what it could mean for the way they work.

If you would like help reviewing your existing Business Central posting controls or understanding whether the new Date Formula functionality could simplify your month-end processes, speak to our Business Central team.