Allow Posting From/To DateFormula: No More Monthly Date Updates from Business Central v28

Key points

• New DateFormula fields (Allow Posting From DateFormula and Allow Posting To DateFormula) on General Ledger Setup and User Setup tables calculate posting windows dynamically
• DateFormula and static Date fields are mutually exclusive; setting one automatically clears the other to prevent conflicts
• Use standard DateFormula syntax like <-CM> for month start and for month end, same as payment terms
• Posting window recalculates automatically each period without manual intervention required
• Error messages for out-of-range posting dates work the same whether dates come from static fields or formulas

Quotes

• “No more monthly manual updates. Set the formula once, and the posting window moves forward on its own.” (This summarizes the core benefit of eliminating repetitive administrative tasks that were easy to forget.)

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”

Context

• Features: Allow Posting From DateFormula, Allow Posting To DateFormula, DateFormula data type, Automatic posting window calculation, Mutual exclusivity validation
• Versions: BC28, 2026 Release Wave 1

Source: Mohana’s Dynamics NAV & BC blog, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.