the Available quantity in the SAP Business One warehouse management system refers to the quantity of an item that is actually available at a certain point in time and can be used for new customer orders. It is therefore a key performance indicator for stock and delivery capability.
The available quantity is managed in SAP Business One at the level of each warehouse and displayed in the Article master is displayed under the „Inventory data“ tab. It is an integral part of the automated availability check in sales documents such as sales orders and influences decisions on delivery capability, scheduling and order acceptance.
Calculation basis:
The standard formula for determining the available quantity is as follows:
Available quantity = In stock - Confirmed + Ordered
These three components are made up as follows:
-
In stockThe physically available stock in the warehouse. Arises from goods receipts, production or inventory adjustments.
-
Confirmed (Committed)The quantity already reserved for other purposes (e.g. customer orders or internal stock transfers). It reduces the available quantity.
-
OrderedFuture receipts due to open orders or ongoing production processes. They increase future availability.
Area of application - article availability check (ATP):
the Available quantity is the basis of the so-called Available-to-Promise (ATP) test. This test answers the questions:
-
Is the item available in the desired quantity?
-
Is it available in the desired warehouse?
-
Can the item be made available on the specified delivery date?
If the available quantity falls below the planned delivery date, the „Item availability check“ window opens automatically. Various options are available to the user there, e.g. reduction to the available quantity or calling up an availability report.
Differentiation from related terms:
In contrast to the term „In stock“, which only shows the physical stock, the „available quantity“ also takes into account reservations and expected receipts.
Example:
An article has 100 items in stock, 30 of which are already reserved by customer orders. At the same time, 50 items are in stock due to an open order. The available quantity is:
100 - 30 + 50 = 120 pieces
ERP for discrete manufacturing - or why screws don't flow
AI for SAP Business One puts the user at the centre
Automated management of production orders
With a focus on production: Versino participates in SMS
Advanced production planning in SAP Business One
