Hi Emad, when the initial record is done (for example adding product inventory with quantity 10 for productId "demoproduc"t) the inventory item gets +10 QUANTITY_ON_HAND_DIFF +10 AVAILABLE_TO_PROMISE_DIFF’
If a customer creates an order, adding quantity 2 from demoproduct an inventory item detail with AVAILABLE_TO_PROMISE_DIFF -2 is created. The inventory is reserved for that order. The result: ATP: 8 - available to promise QOH: 10 - physical stock This is just one simple case for inventory change. Does this answer your question? Best regards, Ingo -----Ursprüngliche Nachricht----- Von: Emad Radwan <[email protected]> Gesendet: Dienstag, 21. Juni 2022 17:11 An: [email protected] Betreff: Inventory Item Detail Hello Community, I need your help please understanding the logic used while adding records to the subject table as demo data is not giving enough insight regarding the same. Usually, we’ll have one initial record added with every ‘inventory_item’ and fields ‘QUANTITY_ON_HAND_DIFF’ and ‘AVAILABLE_TO_PROMISE_DIFF’ have the same value. My question is how subsequent records on the same inventory item affect the values of the mentioned fields? Regards, Emad
