Using DateFormulas to Control Allowed Posting Dates in Business Central v28.0
If you’ve ever had to update your allowed posting dates at the start or end of every month, you know how tedious that gets. Business Central version 28.0 finally addresses that with a practical addition to the General Ledger Setup and User Setup pages: date formula fields. Instead of typing in a fixed date that you’ll forget to change, you can now define a rolling window relative to the current system date. It’s a small change that saves a real headache.
If you’re also working through other financial configuration updates, it’s worth checking out what’s new for accountants in BC and working with payment terms in Business Central for related setup tips.
Key Takeaways
- New date formula fields in v28.0: The Allow Posting From Date Formula and Allow Posting To Date Formula fields are now available on both the General Ledger Setup and User Setup pages, letting you define a rolling posting window using standard BC date formula syntax (e.g.,
-1Dfor yesterday,5Dfor five days out). - Based on system date, not work date: The date formula calculations use the current system date as the reference point, not the work date. Keep this in mind when configuring and testing your settings.
- Specific dates override formulas: If you enter a hard date into the Allow Posting From or Allow Posting To fields, it will override and clear the date formulas. Use one approach or the other.
- User Setup takes priority: Just like before, settings on the User Setup page override General Ledger Setup for individual users, so you can still give certain users a wider or narrower window as needed.
- Bonus tip: Silence the future-date notification: When posting with a date beyond the current work date, BC shows a warning notification. You can turn this off through the My Notifications page by disabling the “Confirm Posting After the Working Date” notification.
- No need to wait for v28.0: This feature is already available, so you can try it now without waiting for the full version rollout.
