Hi Deval, As much I understand your requirement, your order is placed from some external application and you want to manage inventory in ofbiz, for InventoryItem history we use InventoryItemDetail, instead of creating InventoryItem create InventoryItemDetail record and the service getInventoryAvailableByFacility will give you exact ATP and QOH.
As you mentioned you are getting ProductId, FacilityId, then you can easily create a InventoryItemDetail for that product's inventory with orderId, orderItemSeqId info. HTH Regards, Ankit Jain On Fri, May 4, 2012 at 7:45 PM, devalpatel <deval.pa...@netweb.biz> wrote: > Thanks for your reply Jacopo ... > > My problem is related to deducting the inventory quantity. > > Whenever an inventory in received in respective warehouse a new record is > generated in the "InventoryItem". > However i am concerned with the total of the respective product's inventory > in the particular warehouse. because i have to send the ATP & QOH for the > product X from facility Y to the external application. > > I am able to send the total ATP & QTP of product using > "getInventoryAvailableByFacility" service in ofBiz. > > But, the problem is, when the order is generated in the external app. i have > to deduct the inventory in ofBiz based on the ordered quantity in the > external app. So, there are multiple records of inventory in the > "InventoryItem" entity for one product in one facility. So, which record > needs to be updated in "InventoryItem" ????? because i just received ATP & > OQH, productid & facilityid from external app...... > So, should i generate a new record in the "InventoryItem" withy MINUS > quantity..... or any other way..... > > E.G.- InventotyItem > InvID ProdId facilityID ATP > 10000 p1 F1 10 > 10001 p1 F1 15 > 10002 p1 F1 10 > > So, Total ATP = 35(send to external app this prod) > > I have to deduct quantity 12 based on the order in external app. so, how i > manage that ????? > Generate a new record as shown below : > 10003 p1 F1 -12 > > Please confirm/advice/give solution to deduct inventory based on order in > ofBiz............ > > > Regards, > DEVAL > > > > > > > > > > > > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/what-is-accountingQuantityTotal-in-InventoryItem-entity-tp4608258p4608724.html > Sent from the OFBiz - User mailing list archive at Nabble.com.