Reference behaviour: Inventory Batch, Inventory Position and Inventory Quantity (Quantities) with DELTA
Essential knowledge
Authors:
Nandha Balaguru, Randy Chan
Changed on:
22 Apr 2025
Overview
Reference behaviour: Batch Inventory, Inventory Position and Inventory Quantity (Quantities) with CORRECTION
Key points
- This article will give a good understanding of Last On Hand and how OMS calculates the Inventory On Hand quantity.
- Covers how inventory quantity values are handled during the batch process.
- For the Virtual Catalogue and Virtual Positions, please refer to the training articles.
DELTA transaction represents an immediate deduction from inventory, distinct from reservation processes, such as a direct sale in a store through a Point of Sale (POS) system.
An ACTIVE DELTA with -10 units
Two ACTIVE RESERVED with -7 and -2 units
The current IP on-hand is 143 while the LAST_on_HAND IQ is 162
New inventory batch resets LAST_ON_HAND to 153.
All prior DELTA records are inactivated since the batch load reestablishes the system’s understanding of actual stock. Previous SALE and CORRECTION records are also handled if present.
