Reference behaviour: Inventory Batch, Inventory Position and Inventory Quantity (Quantities) with DELTA
Essential knowledge
Intended Audience:
Business User
Authors:
Nandha Balaguru, Randy Chan
Changed on:
29 Aug 2025
Overview
Reference behaviour: Batch Inventory, Inventory Position and Inventory Quantity (Quantities) with CORRECTIONKey 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 unitsTwo ACTIVE RESERVED with -7 and -2 unitsThe 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.
An ACTIVE DELTA with -10 unitsTwo ACTIVE RESERVED with -7 and -2 unitsThe 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.
