Availability by Location for Microsoft Dynamics 365 Business Central
A purchase suggestion for one warehouse can be a wasted buy when another location already holds the stock. Finding that out usually means leaving the planning worksheet to look up each location.
Enhanced Planning Worksheet adds an Availability by Location FactBox, an information pane beside the worksheet lines, that lists on-hand and future available quantities by location for the selected line, including stock in other companies.
How Availability by location works in Enhanced Planning Worksheet
- The planner selects a planning line for an item at one location.
- The Availability by Location FactBox lists on-hand and future available quantity for that item at each location, including other companies.
- If another location has spare stock, the planner changes the line to a transfer from that location.
- If no location can spare the stock, the planner keeps the purchase suggestion and moves on.
Key capabilities
Every location in one list
For the selected planning line, the FactBox lists each location code with its on-hand quantity and its future available quantity, so a planner sees where stock sits and where it will be short.
Other companies too
Availability includes on-hand and future stock in other companies, which helps groups that plan several Business Central companies side by side.
Future availability, not just on hand
Future Available shows what is left at each location after its own demand, so a location with stock but no spare quantity is easy to spot.
A step toward a transfer
When another location has spare stock, the planner can switch the line to a transfer instead of buying more.
Next to the planning summary
The FactBox sits under the Planning Summary, so supply and demand for the line and stock elsewhere are read together.
See Availability by location on screen
Real screens from Enhanced Planning Worksheet, shown with demo data.
Details that matter on the floor
The decision happens on the line
The planner sees stock at other locations while the suggestion is in front of them, rather than after the purchase order is sent.
Spare stock, not just stock
Because future availability is shown, a location that has stock already promised to its own orders does not look like a source for a transfer.
Who uses Availability by location
Inventory planners
Check other locations before accepting a purchase suggestion.
Distribution managers
Balance stock across distribution centers by moving it instead of buying it.
Warehouse managers
See which locations hold spare stock that could be transferred out.
Questions about Availability by location
Can I see stock at other locations from the planning worksheet in Business Central?
Yes, with Enhanced Planning Worksheet. Its Availability by Location FactBox lists on-hand and future available quantity by location for the selected planning line, beside the worksheet lines.
Does availability include other companies?
Yes. Enhanced Planning Worksheet shows on-hand and future availability at other locations and companies, so a group with several Business Central companies can check stock across them before buying.
Can I turn a purchase suggestion into a transfer?
Yes. When another location already has the stock, the planner can switch the planning line to a transfer instead of a purchase. See Transfer or Purchase.
Related Enhanced Planning Worksheet features
All Enhanced Planning Worksheet features →Part of Enhanced Planning Worksheet
Align Inventory with Demand and Optimize Vendor-Driven Purchasing.
Have a question about Availability by location?
Send us a note and the Enhanced Planning Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
