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 <[email protected]>
Gesendet: Mittwoch, 22. Juni 2022 11:35
An: [email protected]
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 <[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
