You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Dhananjay Katre <dh...@vnnogile.com> on 2015/09/01 08:32:28 UTC

Inventory Status Update - not changing the available to promise quantity

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?


Regards,
Dhananjay Katre
Director and Cofounder
vnnogile Solutions Private Limited

[image: Inline image 1]

Re: Inventory Status Update - not changing the available to promise quantity

Posted by Jacques Le Roux <ja...@les7arts.com>.

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 <
> jacques.le.roux@les7arts.com> 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.
>>>
>>>

Re: Inventory Status Update - not changing the available to promise quantity

Posted by Dhananjay Katre <dh...@vnnogile.com>.

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 <
jacques.le.roux@les7arts.com> 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.
>>
>>

Re: Inventory Status Update - not changing the available to promise quantity

Posted by Jacques Le Roux <ja...@les7arts.com>.

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.
>

Re: Inventory Status Update - not changing the available to promise quantity

Posted by Sharan-F <sh...@gmail.com>.

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.

Re: Inventory Status Update - not changing the available to promise quantity

Posted by Dhananjay Katre <dh...@vnnogile.com>.

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.

Regards,
Dhananjay Katre
Director and Cofounder
vnnogile Solutions Private Limited
[image: Inline image 1]

On Tue, Sep 1, 2015 at 8:52 PM, Sharan-F <sh...@gmail.com> 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.
>

Re: Inventory Status Update - not changing the available to promise quantity

Posted by Sharan-F <sh...@gmail.com>.

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.