Inventory Status Update - not changing the available to promise quantity

[Dhananjay Katre]

Hello,

I have a record in inventory_item table (InventoryItem entity)  for a product ID say 1001.  The available to promise quantity is 10.

Now, say, I change the statusId of the inventory item to Defective (non-serialized), I expect the available to promise quantity to fall down to 0 since now I have updated the status ID of the inventory to defective. 

However, the available to promise quantity is not getting decreased. Am I missing something or is my understanding wrong?

[Sharan-F]

Hi

I did a quick test based on what you have mentioned. You are right in that the ATP/QOH in the Inventory Item itself doesn't change (maybe because you still have the same number of product items even though they are defective...)

However on the if you go and look at the ATP and QOH from the Inventory screen in Facility Manager for that product same then it should show the both ATP and QOH quantities for the product as zero.

Also entering a Sales Order for that same product will show that the product needs to be backordered because there is zero available in stock. So I think the functionality is working correctly when you modify the Inventory Item status to be Defective (i.e.none of the items from it are available).

Hope this helps.

Thanks
Sharan

[Dhananjay Katre]

Hello Sharan,

Thanks for the reply. I tested it as the way you suggested and it is working. 

Since there are two fields quantityOnHandTotal and availableToPromiseTotal on the InventoryItem record, in scenarios such as defective product, I would think that quantityOnHandTotal will still show whatever quantity (for eg 10) and availableToPromiseTotal for that InventoryItem to be 0 if all 10 inventory items are defective.  That was what I had in mind when I asked the question.

Anyway, thanks for getting my doubt solved. 

On Tue, Sep 1, 2015 at 8:52 PM, Sharan-F <[hidden email]> wrote:

Hi

I did a quick test based on what you have mentioned. You are right in that
the ATP/QOH in the Inventory Item itself doesn't change (maybe because you
still have the same number of product items even though they are
defective...)

However on the if you go and look at the ATP and QOH from the Inventory
screen in Facility Manager for that product same then it should show the
both ATP and QOH quantities for the product as zero.

Also entering a Sales Order for that same product will show that the product
needs to be backordered because there is zero available in stock. So I think
the functionality is working correctly when you modify the Inventory Item
status to be Defective (i.e.none of the items from it are available).

Hope this helps.

Thanks
Sharan



--
View this message in context: http://ofbiz.135035.n4.nabble.com/Inventory-Status-Update-not-changing-the-available-to-promise-quantity-tp4671743p4671789.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

[Sharan-F]

Hi Dhananjay

Looking at it again I think you are right.The quantity on hand should be the same because this is just tells you how many of the product you have whatever the status. The ATP should be zero because you can't promise any of the defective products. So now, yes I do think it is a minor bug.

I did some extra testing using the inventory item variances (at the bottom of the inventory item screen) where you can adjust the ATP and QOH .e.g. I put in a -8 variance on the ATP and a zero variance on the QOH to get a ATP = 0 and QOH=8.

I'd suggest you take a look through our Jira Issue tracker just in case this issue has been previously reported but if not the please create a new Jira Issue for it.

Thanks
Sharan

[Jacques Le Roux]

Hi,

Has a Jira issue created for this?

Thanks

Jacques

Le 02/09/2015 09:49, Sharan-F a écrit :

> Hi Dhananjay
>
> Looking at it again I think you are right.The quantity on hand should be the
> same because this is just tells you how many of the product you have
> whatever the status. The ATP should be zero because you can't promise any of
> the defective products. So now, yes I do think it is a minor bug.
>
> I did some extra testing using the inventory item variances (at the bottom
> of the inventory item screen) where you can adjust the ATP and QOH .e.g. I
> put in a -8 variance on the ATP and a zero variance on the QOH to get a ATP
> = 0 and QOH=8.
>
> I'd suggest you take a look through our Jira Issue tracker just in case this
> issue has been previously reported but if not the please create a new Jira
> Issue for it.
>
> Thanks
> Sharan
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Inventory-Status-Update-not-changing-the-available-to-promise-quantity-tp4671743p4671803.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Dhananjay Katre]

Hello Jacques,

Sorry for late reply. I was on leave.

I have raised a JIRA request for the same - OFBIZ-6620

Regards,
Dhananjay Katre
Director and Cofounder
vnnogile Solutions Private Limited

On Sun, Sep 13, 2015 at 8:18 PM, Jacques Le Roux <
[hidden email]> wrote:

> Hi,
>
> Has a Jira issue created for this?
>
> Thanks
>
> Jacques
>
> Le 02/09/2015 09:49, Sharan-F a écrit :
>
>> Hi Dhananjay
>>
>> Looking at it again I think you are right.The quantity on hand should be
>> the
>> same because this is just tells you how many of the product you have
>> whatever the status. The ATP should be zero because you can't promise any
>> of
>> the defective products. So now, yes I do think it is a minor bug.
>>
>> I did some extra testing using the inventory item variances (at the bottom
>> of the inventory item screen) where you can adjust the ATP and QOH .e.g. I
>> put in a -8 variance on the ATP and a zero variance on the QOH to get a
>> ATP
>> = 0 and QOH=8.
>>
>> I'd suggest you take a look through our Jira Issue tracker just in case
>> this
>> issue has been previously reported but if not the please create a new Jira
>> Issue for it.
>>
>> Thanks
>> Sharan
>>
>>
>>
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/Inventory-Status-Update-not-changing-the-available-to-promise-quantity-tp4671743p4671803.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>

[Jacques Le Roux]

Thanks Dhananjay!

Jacques

Le 16/09/2015 05:54, Dhananjay Katre a écrit :

> Hello Jacques,
>
> Sorry for late reply. I was on leave.
>
> I have raised a JIRA request for the same - OFBIZ-6620
>
> Regards,
> Dhananjay Katre
> Director and Cofounder
> vnnogile Solutions Private Limited
>
> On Sun, Sep 13, 2015 at 8:18 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> Hi,
>>
>> Has a Jira issue created for this?
>>
>> Thanks
>>
>> Jacques
>>
>> Le 02/09/2015 09:49, Sharan-F a écrit :
>>
>>> Hi Dhananjay
>>>
>>> Looking at it again I think you are right.The quantity on hand should be
>>> the
>>> same because this is just tells you how many of the product you have
>>> whatever the status. The ATP should be zero because you can't promise any
>>> of
>>> the defective products. So now, yes I do think it is a minor bug.
>>>
>>> I did some extra testing using the inventory item variances (at the bottom
>>> of the inventory item screen) where you can adjust the ATP and QOH .e.g. I
>>> put in a -8 variance on the ATP and a zero variance on the QOH to get a
>>> ATP
>>> = 0 and QOH=8.
>>>
>>> I'd suggest you take a look through our Jira Issue tracker just in case
>>> this
>>> issue has been previously reported but if not the please create a new Jira
>>> Issue for it.
>>>
>>> Thanks
>>> Sharan
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://ofbiz.135035.n4.nabble.com/Inventory-Status-Update-not-changing-the-available-to-promise-quantity-tp4671743p4671803.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>