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
- Filter the worksheet to the orders that should share the available stock.
- Choose Split Allocation.
- Each displayed order receives an even share of the available quantity.
- 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.
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 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.