Thanks a lot, makes More sense now. Regards, Emad
> On 22 Jun 2022, at 12:07 PM, Ingo Wolfmayr <ingo.wolfm...@wolfix.at> wrote: > > Here is an example copied from the InventoryItemDetail entity: 100 income, 2 > sold > > Inventory Item ID Inventory Item Detail Seq ID Effektives Datum > Quantity On Hand Diff Available To Promise Diff Accounting Quantity > Diff Unit Cost Order ID Order Item Seq ID Ship > Group Seq ID Shipment ID Shipment Item Seq ID Return ID > Return Item Seq ID Work Effort ID Fixed Asset ID Maint Hist Seq ID > Item Issuance ID Receipt ID > 1. 10060 10050 2022-06-21 11:14:59.578 100 100 0 > 0 > 10030 > 2. 10060 10051 2022-06-21 11:15:00.172 0 0 100 > > > 3. 10060 10056 2022-06-21 11:39:23.352 0 -1 0 > WSWSO10110 00002 > > 4. 10060 10057 2022-06-21 11:39:24.021 0 -1 0 > WSWSO10110 00001 > > 5. 10060 10059 2022-06-22 12:00:04.719 0 0 -1 > > > 6. 10060 10060 2022-06-22 12:00:04.415 -1 0 0 > WSWSO10110 00001 00001 10035 00001 > 10015 > 7. 10060 10063 2022-06-22 12:00:04.913 0 0 -1 > > > 8. 10060 10064 2022-06-22 12:00:04.908 -1 0 0 > WSWSO10110 00002 00001 10035 00002 > 10017 > > 1. shows an income of quantity 100. QOH & ATP > 2. adds the Accounting Quantity - in this case 100 > 3., 4. are the order reservations. > 5., 6. removing inventory quantity 1 --> shipping - physical stock removed, > removed from accounting > 4., 8. removing inventory quantity 1 --> shipping - physical stock removed, > removed from accounting > > Best regards, > Ingo > > -----Ursprüngliche Nachricht----- > Von: Emad Radwan <eradwan1...@gmail.com> > Gesendet: Mittwoch, 22. Juni 2022 11:35 > An: user@ofbiz.apache.org > Betreff: Re: Inventory Item Detail > > 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 <ingo.wolfm...@wolfix.at> 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 <eradwan1...@gmail.com> >> Gesendet: Dienstag, 21. Juni 2022 17:11 >> An: user@ofbiz.apache.org >> 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 >