Hi Ingo, In this case, in the new record where we updated the mentioned field with -2, will be an update to the ‘QUANTITY_ON_HAND_DIFF’ field? On the same record I mean, and that’s what confuses me from some of the demo data.
Regards, Emad > On 22 Jun 2022, at 7:57 AM, Ingo Wolfmayr <[email protected]> wrote: > > 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
