Dynamics 365 Business Central 2025 Wave 1 (26.x): real values to upgrade
Dynamics 365 Business Central 26.x introduces a less-locking inventory posting engine and optimizes FlowField calculations on pages. A production environment with 2,000+ background sessions per hour saw nearly all Item Ledger Entry deadlocks disappear after upgrading and enabling these features, though subsequent third-party application deadlocks required targeted optimization.
post Dynamics 365 Business Central tales, myths, legends. And something serious.
"Item Ledger Entry deadlocks and lock timeouts… puff. Gone with the wind."
Key points
- The new 26.x inventory posting engine, built on Number Sequence, practically removed Item Ledger Entry deadlocks and lock timeouts in a busy online manufacturing environment
- Changing the locking order exposed new deadlocks in in-house third-party apps, fixed with read isolation instead of locktable, SIFT tuning with a session-based bucket number, and Number Sequence instead of Autoincrement
- Skipping FlowField calculation for hidden page columns cut page load times, sometimes dramatically when the hidden FlowField lacks an index
- One visible standard column depended on a hidden FlowField and stopped calculating; making the hidden field visible via personalization fixed it
- Test concurrency heavily with BCPT and check for visible fields depending on hidden FlowFields before enabling these features
Quotes
- “Item Ledger Entry deadlocks and lock timeouts… puff. Gone with the wind.” (Demonstrates the tangible impact of the new inventory posting engine on reducing contention in complex manufacturing environments)
- “The difference, sometimes, is HUGE. (overall when you have invisible FlowFields that does not have a supporting index)” (Shows why skipping FlowField calculations for hidden columns can dramatically improve page performance)
- “When you upgrade and enable the new inventory posting engine, you must test the concurrency A LOT.” (Emphasizes that the feature requires comprehensive testing to surface new deadlock patterns that may emerge)
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 32 “Item Ledger Entry”
- table 169 “Job Ledger Entry”
- table “Resource Ledger Entry”
- other “Number Sequence”
Not found in BC28-30: table “Resource Ledger Entry”.
Context
- Features: Less-locking inventory posting engine, Visible FlowField calculation optimization, Number Sequence object for inventory posting, SIFT optimization with bucket distribution, ReadIsolation isolation level
- Versions: 26.x, 26.1, 25.x
Source: Duilio Tacconi, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.