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

Location Worksheet for Microsoft Dynamics 365 Business Central

A warehouse supervisor who starts the day with a hundred open orders has to check availability one order at a time, or send pickers out to find the shortages on the floor. Order Fulfillment Worksheet lists every sales and transfer order for one location on a single Business Central page and works out how much of each can ship from current stock.

From that list, the same page creates the warehouse shipments, picks, and movements to act on the answer.

How Location worksheet works in Order Fulfillment Worksheet

  1. Open Order Fulfillment Worksheet and choose the location to work.
  2. The worksheet loads every open sales order and transfer order for that location, sorted by shipment date.
  3. Sort or filter the list to reflect today's priorities, then choose Recalculate.
  4. Review the availability and allocation status of each order and its lines.
  5. Select the orders that can go and create their warehouse shipments, picks, or movements.
Video thumbnail: Manage backorders in Order Fulfillment Worksheet
Manage backorders in Order Fulfillment Worksheet For order processing and warehouse teams that want to know which backordered sales orders they can ship as soon as stock arrives. Transcript and details →

Key capabilities

One location, every order

Choose a Location Code and Order Fulfillment Worksheet loads the open sales orders and transfer orders shipping from that location. Batch names let different users or purposes keep their own worksheet for the same location.

Answers on demand

Recalculate allocates current stock across the listed orders, and Reload Orders re-reads the order set to pick up new, changed, and deleted orders. Statuses change only when one of these runs, so the list does not shift while someone is working through it.

Order line detail

Select an order to see its lines below the header list, with quantity needed and quantity allocated. The Order Line Details panel shows the line's shipment date, item availability, scheduled and reserved receipts, and gross requirements.

Sort to set priority

Orders are sorted by shipment date by default, so the oldest orders claim stock first. Re-sort or filter the list, then recalculate, and allocation follows the new order. See Top-Down Allocation.

Act from the same page

Select the orders that are ready and use Create Shipments or Create Picks on the worksheet's action bar, so the decision and the warehouse documents stay together.

See Location worksheet on screen

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

Details that matter on the floor

Built around one question

The worksheet is laid out to answer what can ship today from this location. Everything on the page, from the sort order to the status columns, serves that decision.

Works with any warehouse setup

The worksheet works at locations that use directed put-away and pick, basic warehousing, or no warehouse documents at all. Picks are created as warehouse picks or inventory picks to match the location.

A stable list while you work

Because availability is recalculated only on request or on a schedule, a supervisor working down the list is not surprised by orders changing status mid-task.

Who uses Location worksheet

Warehouse and shipping managers

Open the worksheet each morning to see what can ship from the location and release the work to the floor.

Order fulfillment specialists

Work the list through the day, re-sorting and recalculating as orders arrive and stock is received.

Inventory controllers

See where stock is committed across open orders and which orders are short.

Questions about Location worksheet

How do I see which orders can ship today in Business Central?

Open Order Fulfillment Worksheet, choose the location, and run Recalculate. The worksheet allocates current stock across every open sales and transfer order for that location and shows each order as available, partially available, or not available, with move and pick states as well.

Does the worksheet include transfer orders?

Yes. Sales orders and transfer orders for the location are listed together, and each document type can be filtered on its own.

Does availability update automatically?

Availability is calculated on demand. It refreshes when Recalculate, Split Allocation, or Reload Orders runs, whether a person presses the button or a scheduled job queue entry runs it.

Who should use Order Fulfillment Worksheet?

It is built for the warehouse to decide what to execute today. It is not meant as an allocation tool for salespeople.

What licenses do I need?

Licensing depends on your setup. See the licensing FAQ for current requirements, or contact your Microsoft Partner.

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 Location worksheet?

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