Reference behaviour: Inventory Batch, Inventory Position and Inventory Quantity (Quantities)with CORRECTION
Essential knowledge
Intended Audience:
Business User
Authors:
Randy Chan, Nandha Balaguru
Changed on:
29 Aug 2025
Overview
Reference behaviour: Inventory Batch, 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.
Let's demonstrate how CORRECTION IQ behave when a new batch inventory upsert is sent to OMS. First, create a new order with 5 units and here is the Fulfilment screen:
The current IP on-hand is 162:
The RESERVED IQ is set to INACTIVE,The ACTIVE SALE IQ is created for -1 unitThe ACTIVE CORRECTION IQ is created for -4 unitsThe IP On hand remains at 162New inventory batch resets LAST_ON_HAND again. Past SALE and CORRECTION records are inactivated because they represent quantities that were already picked and packed — and are no longer part of the available stock. The current LAST_ON_HAND reflects the truly available inventory, which includes available along with actively reserved quantities.
In the nightly batch, the qty should be 162:
The CORRECTION IQ is set to INACTIVE,The SALE IQ is set to INACTIVEThe IP On hand remains at 162
The current IP on-hand is 162:The RESERVED IQ is set to INACTIVE,The ACTIVE SALE IQ is created for -1 unitThe ACTIVE CORRECTION IQ is created for -4 unitsThe IP On hand remains at 162New inventory batch resets LAST_ON_HAND again. Past SALE and CORRECTION records are inactivated because they represent quantities that were already picked and packed — and are no longer part of the available stock. The current LAST_ON_HAND reflects the truly available inventory, which includes available along with actively reserved quantities.In the nightly batch, the qty should be 162:
The CORRECTION IQ is set to INACTIVE,The SALE IQ is set to INACTIVEThe IP On hand remains at 162
