[jira] [Commented] (OFBIZ-6620) Issue in reducting AvailableToPromiseTotal when product is marked as defective

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-6620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14791100#comment-14791100 ]

Jacques Le Roux commented on OFBIZ-6620:
----------------------------------------

I think it's worth to add a comment from Sharan on the user ML:
{quote}
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
{quote}

> Issue in reducting AvailableToPromiseTotal when product is marked as defective
> ------------------------------------------------------------------------------
>
>                 Key: OFBIZ-6620
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6620
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>            Reporter: Dhananjay Katre
>            Priority: Minor
>
> I am raising this JIRA request based on email exchange on Sep 2
> ---
> 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.
> -------
> 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.  

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)