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

Split Allocation for Microsoft Dynamics 365 Business Central

When stock is short and allocation fills orders from the top, the first order gets everything and the next gets nothing. For a distributor serving several stores of one customer, that is often the wrong result. Split Allocation in Order Fulfillment Worksheet spreads the available quantity evenly across all the orders on the worksheet.

How Split allocation works in Order Fulfillment Worksheet

  1. Filter the worksheet to the orders that should share the available stock.
  2. Choose Split Allocation.
  3. Each displayed order receives an even share of the available quantity.
  4. Create picks for the allocated quantities.

Key capabilities

Even distribution

If one customer's two stores each order 100 units and only 50 are in stock, top-down allocation gives the first store all 50. Split Allocation gives each store 25.

You choose which orders share

Split Allocation works across the displayed orders, so filter the worksheet first, for example to one customer or one item, to decide who shares the stock.

Same follow-through

After the split, picks are created up to each order's allocated quantity, the same as after Top-Down Allocation.

Extensible for other rules

Proportional or priority-weighted distribution is not built in yet, and priority-weighted allocation is on the roadmap. Today it can be added through the worksheet's published events.

Details that matter on the floor

Everybody gets something

Split Allocation trades complete orders for fair partial ones. Nobody receives everything they asked for, but no order is left with nothing.

Even, not proportional

The split is even across orders. An order for 10 and an order for 100 receive the same share until the smaller order is filled.

Who uses Split allocation

Order fulfillment specialists

Run Split Allocation when stock is short and several customers are waiting.

Warehouse and shipping managers

Decide when fair partial shipments are better than filling a few orders completely.

Questions about Split allocation

What is the difference between Recalculate and Split Allocation?

Recalculate fills orders from the top of the list until stock runs out. Split Allocation divides the available stock evenly across all displayed orders.

Can stock be split in proportion to order size?

Not yet. The built-in split is even, and priority-weighted allocation is on the roadmap. Today, proportional or priority-weighted allocation can be added by extending the worksheet through its published events.

Will an order with Shipping Advice set to Complete receive a partial share?

The worksheet honors Shipping Advice of Complete and reports such an order as not shippable rather than partially picked.

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 Split 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