When working with sales orders, we might notice that the “Available Quantity on Sales Order” doesn’t always match the “Available Quantity” listed directly on the Item Record. Rather than pulling the number straight from the Item Record, the system calculates the Available Quantity on Sales Order using a specific formula.
The Available Quantity on Sales Order is computed as follows:
Available Quantity on Sales Order = Available Quantity on the Item Record + Quantity Committed + Quantity Fulfilled
This means the figure we see reflects not just what’s currently available in inventory, but also includes quantities tied up in commitments and fulfillments related to the sales order.
A Practical Example
Imagine we start with an Available Quantity of 20 on the Item Record.
- Creating a Sales Order: We create a sales order for 10 units. The Available Quantity on the Item Record drops to 10, as 10 units are now reserved for the order (this is the “Quantity Committed”). However, the Available Quantity on Sales Order will still show 20. Because it’s calculated as:
- 10 (Available Quantity on the Item Record) + 10 (Quantity Committed) = 20.
- Fulfilling Part of the Order: Next, we fulfill 5 units of that sales order. Now, the Item Record still shows 10 available (since the fulfilled units have already been accounted for), the Quantity Committed drops to 5 (the remaining units still reserved), and the Quantity Fulfilled becomes 5. The Available Quantity on Sales Order remains 20, calculated as:
- 10 (Available Quantity on the Item Record) + 5 (Quantity Committed) + 5 (Quantity Fulfilled) = 20.