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

["Divesh Dutta (JIRA)" <ji...@apache.org>]

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

Divesh Dutta edited comment on OFBIZ-6620 at 9/19/15 3:05 PM:
--------------------------------------------------------------

In my opinion system is working as expected and this is not a bug. System calculates ATP and QOH using service getProductInventoryAvailable. This service automatically takes care of defective inventory and never accounts defective inventory when it calculates ATP and QOH. 

We generally always try to reuse OFBiz service for all the business rules/calculations and calculating ATP and QOH of product is also a business calculation. So getProductInventoryAvailable should be always used when ever you need to know ATP and QOH of product (either you show it to customer or for any other business decision.) 

And getProductInventoryAvailable is already returns right ATP and QOH for a product . So I am not getting what is bug here. Why it needs to be reduced from InventoryItem table ?

Also to ask specifically I would like to know, which business process is breaking in OFBiz  because of this issue? 




was (Author: diveshdut):
In my opinion system is working as expected and this is not a bug. System calculates ATP and QOH using service getProductInventoryAvailable. This service automatically takes care of defective inventory and never accounts defective inventory when it calculates ATP and QOH. 

We generally always try to reuse OFBiz service for all the business rules/calculations and calculating ATP and QOH of product is also a business calculation. So getProductInventoryAvailable should be always used when ever you need to know ATP and QOH of product (either you show it to customer or for any other reason.) 

And getProductInventoryAvailable is already returns right ATP and QOH for a product . So I am not getting what is bug here. Why it needs to be reduced from InventoryItem table ?

Also to ask specifically I would like to know, which business process is breaking in OFBiz  because of this issue? 



> 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: Jacques Le Roux
>            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)