Inventory Quantity Basis
Inventory Quantity Basis selects the SYSPRO value or formula CyberStore uses as the starting point for storefront availability. Configure it in Site Manager > Catalog Configuration > Quantity Settings.
| Basis | SYSPRO calculation |
|---|---|
| On Hand | QtyOnHand |
| Available | AvailableQty |
| Future Free | (QtyOnHand + QtyInInspection + QtyInTransit + QtyOnOrder) - (AllocatedQty + QtyAllocatedWip) |
| Unallocated | AvailableQty - QtyAllocatedWip |
On Hand represents the physical on-hand quantity. Available uses the availability already calculated by SYSPRO. Future Free includes expected inspection, transit, and purchase-order quantities before subtracting allocations. Unallocated further removes work-in-process allocations from Available Quantity.
How the basis becomes storefront availability
The selected basis is not necessarily the number a shopper can order. CyberStore next:
- Limits the queried warehouses according to web-operator access and the configured warehouse scope.
- Applies prevailing Customer or item warehouse logic when selected.
- Subtracts the applicable inventory buffer.
- Subtracts quantities reserved by the configured in-progress allocation basis.
- Applies item limitation, back-order, and ATP rules.
Prevailing Customer and item warehouse logic applies to all four quantity bases. For the complete calculation and examples, see Calculating Item Inventory Quantity.
Inventory Quantity Basis describes present inventory availability. ATP is a date-based projection and can differ substantially from the current inventory number.