Skip to content
Order Fulfillment Worksheet app iconOrder Fulfillment WorksheetAvailability and allocation

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

  1. Load the worksheet for a location.
  2. Sort or filter the orders into the sequence that should receive stock first.
  3. Choose Recalculate; stock is allocated to each order in turn until it runs out.
  4. 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.

Order Fulfillment Worksheet app icon

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.

Ask a product question

Product Questions