Availability Controls for Microsoft Dynamics 365 Business Central
An allocation is only as good as the stock behind it. Expired lots and stock in blocked bins can make an order look ready when the warehouse cannot actually ship it. Order Fulfillment Worksheet setup lets you exclude expired inventory from allocation and decide whether inventory in blocked movement bins is included.
How Availability controls works in Order Fulfillment Worksheet
- Open Order Fulfillment Worksheet Setup.
- Turn on the option to exclude expired inventory if expired lots should never be allocated.
- Choose whether inventory in blocked movement bins is included.
- Recalculate the worksheet; allocation now follows the new rules.
Key capabilities
Expired stock left out
With expired inventory excluded, lots past their expiration date are not allocated to orders, so only usable stock is considered for fulfillment.
Blocked movement bins
A setup toggle decides whether inventory in blocked movement bins counts toward allocation, so you control whether that stock is treated as available.
One setting, every run
The controls apply to Recalculate, Split Allocation, and scheduled job queue runs alike.
Other setup choices
The same setup page holds the Combine Shipments setting, when picks can be created, and the default selection and launch modes for the worksheet.
See Availability controls on screen
Real screens from Order Fulfillment Worksheet, shown with demo data.
Details that matter on the floor
Fewer surprises at the pick face
Excluding unusable stock at allocation time means an order is not released for picking against a lot the picker will have to set aside.
Who uses Availability controls
Inventory controllers
Decide which stock is eligible to be promised to orders.
Warehouse managers
Keep allocation in line with how bins are actually used on the floor.
Questions about Availability controls
Can Business Central skip expired lots when allocating orders?
Yes, with Order Fulfillment Worksheet. Turn on the setup option to exclude expired inventory, and allocation considers only stock that has not expired.
Does the blocked bin setting change the bins themselves?
No. It only decides whether inventory in blocked movement bins is counted when the worksheet allocates stock.
Do these settings apply to scheduled runs?
Yes. They are setup options, so they apply wherever allocation runs.
Related Order Fulfillment Worksheet features
All Order Fulfillment Worksheet features →Part of Order Fulfillment Worksheet
Optimize your order fulfillment process by focusing on in-stock orders.
Have a question about Availability controls?
Send us a note and the Order Fulfillment Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
