Business Central gives you several ways to check item availability – from a quick location snapshot to a full demand-and-supply timeline with forecast and planning data. This article walks through each view so you know which one to use and what to watch out for.
What Item Availability Shows in Business Central
The quantity on hand field on an item card shows you what is in stock right now. However, that number alone is not enough when you need to commit to an order. Item availability in Business Central shows the projected available balance. That is the quantity you can still sell or use after open purchase orders, sales orders, and transfer orders are counted. So instead of relying on a static count, you can see the full picture.
Business Central has several item availability views. Each one presents the same data in a different way. The right choice depends on what you need to know. Additionally, each view supports drill-down so you can move from a summary number to the individual source documents in a few clicks. Some views are fast and simple. Others give you a deep drill-down into every open document. Overall, the views cover everything from a location summary to a full planning timeline.
You can also reach some availability information from the Item Ledger Entries page. That page lists every transaction that makes up the current inventory. However, it works best for detailed analysis or export to Excel. It does not give you the same projected balance view as the dedicated item availability pages. So for day-to-day decisions, the availability views are the better starting point.
Item Availability by Location
The fastest way to see stock across locations is the availability by location view. Open the item card and click the assist button on the quantity on hand field. Business Central shows one row per location with the current stock. You can click any number to drill down into the lines behind it. For example, click the sales order quantity and you see all open sales lines for that item.
However, this view has a key limit. Locations with the Bin Mandatory checkbox turned on do not show here. The reason is that this page lets you make manual quantity adjustments. Business Central has no way to apply those at the bin level. So bin-managed warehouses are left out. Therefore, do not conclude that a location has no stock if it is missing from this view. It may just use bins.
Item Availability by Event
The item availability by event view is the most complete option. Unlike the location view, it includes all locations – even those with Bin Mandatory turned on. Open it from the item card by selecting Item Availability, then Event.
The page opens with rows collapsed to the period level. You can switch between day, week, month, and quarter. For short-term work, day or week is useful. For a longer view, month or quarter keeps the data easy to read.
Expand the rows to see a split by location. Each row shows the quantity on hand, scheduled receipts from purchase orders, and gross requirements from sales orders and transfer orders. You can drill into any number to open the source documents. The column on the right shows the projected available balance. That is the net result of all supply and demand together. As a result, you get a single number you can use for order decisions.
Adding Forecast and Planning Data to the View
The item availability by event page has options to add planning information. Each one is optional. Turn them on or off as needed. Specifically, there are three types of data you can include.
Demand Forecast
First, if you use demand forecasts, you can pick a forecast name and include it in the view. This adds future demand rows next to your confirmed orders. As a result, planners can see both committed and expected demand in one place instead of checking two separate pages.
Planning Worksheet Suggestions
You can also show lines from the planning worksheet or requisition worksheet. These are purchase plan lines that have not yet been turned into purchase orders. Including them shows what a planner intends to buy. For example, a plan for 25 units shows up in the view even though no purchase order exists yet. So you get a more complete picture of what is coming.
Blanket Sales Orders
Finally, you can include blanket sales orders. A blanket sales order records a customer commitment to buy a set quantity over time. It is more reliable than a forecast because it comes from a real agreement. Including blanket orders in the item availability view lets you plan for that demand before it turns into a confirmed sales order.
Bin Content and Available Quantity to Take
If your locations use bins, there is one more view to know: bin content. From the item card, go to Related, then Warehouse, then Bin Contents. This shows which bins hold the item and how much each bin has. It is the only view that breaks inventory down by bin rather than by location total.
By default, the bin content page does not show the Available Quantity to Take field. You need to add it through personalization. Once it is visible, you may notice that the available quantity is lower than the quantity on hand for some bins. That difference matters.
The gap comes from open warehouse picks. When you create a pick for a sales order, Business Central sets aside those items in that bin. No other pick can use them. For example, if a bin has 20 on hand but only 16 available, a pick for 4 is already out. Consequently, anyone creating a new warehouse document needs to check the Available Quantity to Take column and not just the on-hand total. Otherwise you may try to pick items that are already taken by another order.
This column is not visible by default. To add it, open the bin content page and select Personalize, then Fields. Search for Available Quantity to Take and drag it into the page. After that, it stays visible every time you open the page. In practice, warehouse staff and supervisors find this column essential when locations run with active picking throughout the day.
Wrapping Up: Choosing the Right Item Availability View
Business Central provides more than one way to check item availability because different roles need different levels of detail. The location view is fast for a quick cross-location check. The event view gives planners and sales staff the full supply-and-demand picture, with optional forecast and planning data on top. Bin content answers the warehouse question of where the stock is and how much you can actually pick. In short, using the right view for the right question saves time and prevents stock commitment errors.
For more Business Central guides and tutorials, visit NAV SEAL Blog and watch more videos on our YouTube Channel.
