Automating Posting Periods in Business Central with Date Formulas

Key points

• Date formulas define allowed posting ranges relative to the current date, so posting windows move automatically instead of needing manual updates.
• They can be set in General Ledger Setup, User Setup and General Journal Templates.
• Restrictions are checked in order: User Setup, then General Ledger Setup, then General Journal Template when its mandatory toggle is on.
• Examples include current month only, rolling 30 days, previous month close and today only.
• A formula can be used for one boundary while the other boundary stays a fixed date.

Quotes

• “Date formulas are dynamic expressions that calculate allowed posting ranges relative to today’s date.” (This explains the core concept of how date formulas work as smart boundaries that move with time rather than being static.)
• “You can combine formulas with fixed dates - one boundary can be dynamic, the other fixed.” (This flexibility allows organizations to implement hybrid approaches that mix static and dynamic posting period controls.)

AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

• table 98 “General Ledger Setup”
• table 91 “User Setup”
• table “General Journal Templates”

Not found in BC28-30: table “General Journal Templates”.

Context

• Features: Date formulas for posting restrictions, Dynamic posting windows, Automated posting period management, Relative date calculations
• Versions: 2026 Wave 1

Source: Saurav Dhyani, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.