Reference behaviour: Inventory Batch, Inventory Position and Inventory Quantity (Quantities)with CORRECTION
Authors:
Randy Chan, Nandha Balaguru
Changed on:
23 Apr 2025
Overview
Reference behaviour: Inventory Batch, 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.
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 unit
The ACTIVE CORRECTION IQ is created for -4 units
The IP On hand remains at 162
New 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 INACTIVE
The IP On hand remains at 162
