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

Order Availability Status for Microsoft Dynamics 365 Business Central

Knowing an item is in stock does not tell a shipping manager whether a particular order can go, because other orders may claim the same units and some stock sits in bins that cannot be picked. Order Fulfillment Worksheet gives every order an Availability value that reflects stock already allocated to orders above it and where that stock sits.

A second status, Allocation Status, describes how much of each order's lines received stock.

How Order availability status works in Order Fulfillment Worksheet

  1. Open the worksheet for a location; the orders load with their last calculated statuses.
  2. Choose Recalculate to allocate current stock down the list.
  3. Read each order's Availability value and Allocation Status.
  4. Create picks for Available orders, movements for Move Required orders, and leave Not Available orders for the next recalculation.

Key capabilities

Seven Availability values

Each order shows Available, Available with Move Required, Partially Available, Partially Available with Move Required, Pick Created, Picked, or Not Available. That is more than a ship or do-not-ship flag: it says what has to happen next.

Move Required states

An order marked Move Required has the stock it needs, but some of it sits outside the pickable bins. The worksheet separates pick and move quantities so the movement is visible as the next step, not mistaken for a shortage.

Orders already in progress

Pick Created and Picked identify orders that already have warehouse work against them, so nobody creates a second pick for the same order.

Allocation Status

Allocation Status of blank, Partial, or Full describes how the order's lines were allocated. Read it together with Availability to understand both the state of the order and the state of its lines.

Ship-complete orders respected

When an order's Shipping Advice is Complete, the worksheet reports it as not shippable rather than partially available, so a ship-complete order is never partly picked.

See Order availability status on screen

Real screens from Order Fulfillment Worksheet, shown with demo data.

Details that matter on the floor

Allocation, not just stock on hand

Availability is based on stock allocated down the list, so two orders never both appear available on the same unit.

One subtlety to know

Allocation Status ignores lines with nothing available to allocate, so an order with one completely unallocated line can still read Full. Check Availability alongside it.

Statuses change only on recalculation

Filtering, sorting, or editing allocation quantities does not change Availability until Recalculate, Split Allocation, or Reload Orders runs.

Who uses Order availability status

Warehouse and shipping managers

Scan the status column to decide which orders to release for picking now.

Inventory controllers

Spot orders held back by stock in non-pickable bins and arrange the movement.

Order fulfillment specialists

Track which orders already have picks so work is not duplicated.

Questions about Order availability status

What do the availability statuses mean?

Available means the order can be picked in full from pickable bins. Partially Available means some of it can. The Move Required versions mean stock exists but some must be moved to a pickable bin first. Pick Created and Picked mean warehouse work already exists, and Not Available means no stock was allocated.

Why did an order's status not change after I edited it?

Availability is recalculated on demand. Run Recalculate, Split Allocation, or Reload Orders to refresh it.

How are ship-complete orders handled?

An order with Shipping Advice set to Complete is shown as not shippable until it can ship in full. You can reserve the available quantity so another order does not take it while the rest arrives.

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 Order availability status?

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