If you sell items with expiration dates in Business Central, standard item availability doesn’t tell you the whole story. The system can show 11,000 units on hand, but if part of that inventory expires before you can ship it, the real available quantity is much lower. By setting up reserved quantity calculation and the graphical inventory profile to respect expiration dates, Business Central reserves only the quantity you can actually deliver before it goes out of date.
To make this work, you go into the item availability setup and enable the “Show Items That Expire” field on the reserved quantity line. If you use the graphical inventory profile, you also enable the same setting on the graphical profile setup for your user ID. With both settings matching, Business Central reserves only the stock that is still usable and leaves the expiring stock out of the calculation.
In the example below, two sales orders fall short by 480 units, even though the on-hand inventory looks sufficient. The reason is that 5,500 units expire between the two orders, which lowers the real availability.
How Business Central handles items with expiration dates
Take a snack bar item as an example. It has two item ledger entries, each with its own batch number and expiration date. The total on-hand inventory is 11,520 units.
On the first sales order line, you enter a quantity of 2,500. All of it gets reserved. On the second line, you enter 4,000. This time the system only reserves 3,250, even though no standard item availability warning appears in Business Central.
The warning is missing because the standard availability check still sees the full 11,000 units in stock. It doesn’t account for the fact that one of the batches expires before you can ship everything.
Why the available quantity is lower than the inventory
The graphical inventory profile makes the situation clear. The item starts with 11,520 units available.
You place the first sales order for 2,500 units. At that point, the full inventory of 11,250 is still available, so the order is covered.
Then comes a specific date where one item ledger entry expires. You lose 5,500 units that can no longer be sold and have to be thrown out. The inventory drops to 3,520.
On the second sales order, you still come up short by 480 units, because one of the batches expired. The 480 you’re missing is the difference between what you ordered and what was usable. The 3,250 reserved on the last line was the real available quantity. When you view the graphical profile including the reserved sales order quantity, the inventory drops to zero.
Setting up reserved quantity to respect expiration dates
To get this behaviour, you need to make at least one change. Go into the item availability setup, open the general setup list, and find the reserved quantity line. From there, open the setup card.
On the setup card, enable the “Show Items That Expire” field.
If you also use the graphical inventory profile to break down the lines the way shown here, make sure the graphical profile setup for your user ID has the same check mark enabled. In this scenario, leave the remaining shelf life percentage empty.
With both setups matching, you can view the sales order line and see the reserved quantity correctly, and the graphical profile will show the same result. The key point is that the reserved quantity setup and the graphical profile setup must use the same settings.
Q&A
Why does Business Central reserve fewer units than I have on hand?
Because part of your inventory expires before you can ship it. If you enable expiration handling on the reserved quantity setup, Business Central only reserves the stock that is still usable on the delivery date and leaves out the batches that will have expired by then.
Why doesn’t Business Central show an availability warning when stock will expire?
The standard item availability check counts all on-hand inventory, including batches that will expire before shipment. It doesn’t account for expiration on its own. You have to enable the “Show Items That Expire” field on the reserved quantity setup to get the correct picture.
What setting do I need to enable for expiration-aware availability?
Go into the item availability setup, open the general setup list, find the reserved quantity line, and open the setup card. Enable the “Show Items That Expire” field. If you use the graphical inventory profile, enable the same setting on the graphical profile setup for your user ID.
Why must the reserved quantity setup and the graphical profile setup match?
If only one of them has expiration handling enabled, the sales order line and the graphical profile will show different results. Setting both the same way ensures the reserved quantity and the graphical profile reflect the same available stock.