[
https://issues.apache.org/jira/browse/OFBIZ-6620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14877147#comment-14877147
]
Divesh Dutta commented on OFBIZ-6620:
-------------------------------------
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)
