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.
