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

Availability Controls for Microsoft Dynamics 365 Business Central

An allocation is only as good as the stock behind it. Expired lots and stock in blocked bins can make an order look ready when the warehouse cannot actually ship it. Order Fulfillment Worksheet setup lets you exclude expired inventory from allocation and decide whether inventory in blocked movement bins is included.

How Availability controls works in Order Fulfillment Worksheet

  1. Open Order Fulfillment Worksheet Setup.
  2. Turn on the option to exclude expired inventory if expired lots should never be allocated.
  3. Choose whether inventory in blocked movement bins is included.
  4. Recalculate the worksheet; allocation now follows the new rules.

Key capabilities

Expired stock left out

With expired inventory excluded, lots past their expiration date are not allocated to orders, so only usable stock is considered for fulfillment.

Blocked movement bins

A setup toggle decides whether inventory in blocked movement bins counts toward allocation, so you control whether that stock is treated as available.

One setting, every run

The controls apply to Recalculate, Split Allocation, and scheduled job queue runs alike.

Other setup choices

The same setup page holds the Combine Shipments setting, when picks can be created, and the default selection and launch modes for the worksheet.

See Availability controls on screen

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

Details that matter on the floor

Fewer surprises at the pick face

Excluding unusable stock at allocation time means an order is not released for picking against a lot the picker will have to set aside.

Who uses Availability controls

Inventory controllers

Decide which stock is eligible to be promised to orders.

Warehouse managers

Keep allocation in line with how bins are actually used on the floor.

Questions about Availability controls

Can Business Central skip expired lots when allocating orders?

Yes, with Order Fulfillment Worksheet. Turn on the setup option to exclude expired inventory, and allocation considers only stock that has not expired.

Does the blocked bin setting change the bins themselves?

No. It only decides whether inventory in blocked movement bins is counted when the worksheet allocates stock.

Do these settings apply to scheduled runs?

Yes. They are setup options, so they apply wherever allocation runs.

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 Availability controls?

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