What's New: Concurrent Inventory Posting (2025 release wave 1)
Concurrent inventory posting in Business Central 2025 release wave 1 (BC26): a feature key in Feature Management lets multiple users post item, value, project and resource ledger entries at the same time. It uses number sequences instead of table locks and adds an item register number field for register drill-down. Automatic cost posting to the GL is deferred to the end of the batch, and the video gives developer guidance for custom entries.
- Concurrent inventory posting overview and feature management
- Project and resource ledgers, and legacy locking mechanism
- Number sequences and item register drill-down design
- Automatic cost posting and GL locking demonstration
- Developer guidance and event handling for custom entries
- Performance benchmarks and real-world benefits
Overview
The video explains a new feature in BC25 wave 1 that lets several users or sessions post item ledger entries and value entries at the same time. Before, only one session could insert into the item ledger at a time. The feature replaces table locking with number sequences for entry numbers, and the same rules extend to project ledger and resource ledger entries.
It also shows the supporting changes: a new item register number field on ledger entries so drill-down from the item register still works when from and to entry numbers overlap, and automatic cost posting that is deferred to the end of the batch so the GL is not locked during inventory posting. The video includes a GL locking demonstration, guidance for developers handling custom entries, and performance benchmarks.
Key points
- In BC25 or earlier, only one user or session could insert into the item ledger at a time, and others could hit lock timeouts.
- The feature key ‘enable multiple users to post item ledger entries and value entries at the same time’ is off by default and is planned to be on by default in three releases. There is no upgrade step and no penalty for switching it on and off.
- Project (job) ledger and resource ledger entries follow the same concurrent posting rules.
- Entry numbers come from number sequences, so unused numbers can be lost, like a bakery number dispenser. Legacy code paths remain behind the inventory setup legacy posting check.
- Ledger entries get a new item register number field. Register drill-down filters on it, and old entries have value zero for backwards compatibility.
- Automatic cost posting to the GL is deferred to the end of the batch. Only one session can post to the GL at a time, so concurrent batches still wait for each other at the GL step.
- Developers adding entries must use the get next entry number functions and set the item register number. Otherwise they get ‘record already exists’ errors. Before each batch, the number sequence is resynced with the table, and changes made in events are checked.
Features
| Feature | Status | At |
|---|---|---|
| Enable multiple users to post item ledger entries and value entries at the same time | status not stated, demoed | 0:33 |
| Concurrent posting for project ledger entries | status not stated | 1:53 |
| Number sequence-based entry numbering for concurrent posting | status not stated, demoed | 3:11 |
| Item register number field for drill-down filtering | status not stated, demoed | 4:21 |
| Deferred automatic cost posting to GL | status not stated, demoed | 5:33 |
AL objects mentioned
As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.
- table “item ledger” at 0:33
- table “project ledger” at 1:53
- table “job ledger” at 1:53
- table “resource ledgers” at 1:53
- table 46 “Item Register” at 4:21
- table “value entries” at 4:35
- table 5802 “Value Entry” at 8:52
- other “inventory setup” at 4:02
Not found in BC28-30: table “item ledger”, table “project ledger”, table “job ledger”, table “resource ledgers”, table “value entries”.
Quotes
- 0:33 “In BC25 or earlier only one user or session can insert into item lure at the same time”
- 1:05 “Now two users or many user basically uh can insert and if you look closer you can see that both of these are counting”
- 1:20 “we have added a new feature key for enable multiple users to post item ledger entries and value entries at the same time”
- 1:31 “It’s off by default. Um, we will set it on by default in three releases.”
- 3:25 “instead of incrementing the counter the next entry number we just ask for the next entry number which may not be you know 1”
- 4:50 “we also filter on the register number because all the entries now have a new field called item register number”
- 6:17 “what we did did for BC26 was that we basically do the same as before, but we postpone it till the end”
- 7:41 “you can use the get next entry number functions on the entry tables and you would also need to specify”
- 10:14 “if we post one batch it took you know ballpark of 20 seconds and if we post two um batches as we just demoed”
- 10:49 “one will always be slower than I mean one of them will always have to wait for the other for the GL. But the”
Disclaimers in the video
- 1:31 other: It’s off by default
- 1:31 coming-later: we will set it on by default in three releases
- 1:42 other: there’s no upgrade. there’s no no penalty to go back and forth to try it out
Presenters (as heard): Bardock Nuden.