You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Emad Radwan <er...@gmail.com> on 2022/06/21 15:11:14 UTC
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
Re: Inventory Item Detail
Posted by Emad Radwan <er...@gmail.com>.
Thanks a lot, makes More sense now.
Regards,
Emad
> On 22 Jun 2022, at 12:07 PM, Ingo Wolfmayr <in...@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 <er...@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 <in...@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 <er...@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
>
AW: Inventory Item Detail
Posted by Ingo Wolfmayr <in...@wolfix.at>.
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 <er...@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 <in...@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 <er...@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
Re: Inventory Item Detail
Posted by Emad Radwan <er...@gmail.com>.
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 <in...@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 <er...@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
AW: Inventory Item Detail
Posted by Ingo Wolfmayr <in...@wolfix.at>.
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 <er...@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