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

["james yong (JIRA)" <ji...@apache.org>]

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

james yong commented on OFBIZ-6620:
-----------------------------------

Just to mention that I changed the status of a non-serialized item to 'defective' and didn't see any new records to the Inventory Item Detail table. 

> 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
>            Assignee: Divesh Dutta
>            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)