Top-Down Inventory Allocation for Microsoft Dynamics 365 Business Central
If two orders need the same last unit and both look shippable, one picker comes back empty-handed. Order Fulfillment Worksheet allocates stock down the order list in the sequence you sort it, deducting as it goes, so each unit of stock is counted once.
Recalculate, the worksheet's default allocation action, makes the order of the list the priority.
How Top-down inventory allocation works in Order Fulfillment Worksheet
- Load the worksheet for a location.
- Sort or filter the orders into the sequence that should receive stock first.
- Choose Recalculate; stock is allocated to each order in turn until it runs out.
- Review the allocated quantities and statuses, then create picks for the orders that received stock.
Key capabilities
Deduct as it goes
If eight units are available and the first order needs two, six remain for the next order. A later order for the same item gets nothing once the quantity is used up above it.
Priority through sorting
Sort or filter the worksheet, for example to put your largest customers first, then choose Recalculate. Allocation follows the new sequence. Saved custom views keep a sort you use often.
Oldest orders first by default
The default sort is by shipment date, so overdue orders get first claim on stock. When new stock is received, the next recalculation surfaces those orders as shippable.
Picks match the allocation
Create Picks creates picks only up to the allocated quantity, so the warehouse is never sent to pick something that is not there.
Timing reported
After Recalculate runs, the worksheet reports how long fetching orders and calculating availability took.
See Top-down inventory allocation on screen
Real screens from Order Fulfillment Worksheet, shown with demo data.
Details that matter on the floor
An allocation, not a report
An availability report shows stock on hand against each order. Top-down allocation commits each unit to one order, which is what makes the result safe to pick from.
Arriving stock goes to waiting orders
Because older orders sort first, received stock goes to the orders that have waited longest the next time allocation runs, without a separate backorder list.
Who uses Top-down inventory allocation
Warehouse and shipping managers
Decide which orders get stock first by how they sort the list.
Order fulfillment specialists
Re-sort and recalculate during the day as priorities change.
Questions about Top-down inventory allocation
How does Order Fulfillment Worksheet decide which order gets stock?
By position in the list. Recalculate allocates stock to the first order, then the next, until it runs out. Change the sort or filter and recalculate to change who gets stock first.
Can I give certain customers priority?
Yes, by sorting or filtering the worksheet so those customers' orders come first and then recalculating. Orders also have a priority field you can set by hand, and setting it automatically needs an extension. Priority-weighted allocation is on the roadmap. Until then, rules beyond the list sequence need an extension through the app's published events.
What if I would rather share stock across orders?
Use Split Allocation, which spreads limited stock evenly across the displayed orders instead of filling them from the top.
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 Top-down inventory allocation?
Send us a note and the Order Fulfillment Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
