ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Jain <ankit.i...@gmail.com>
Subject Re: what is accountingQuantityTotal in InventoryItem entity?
Date Fri, 04 May 2012 16:04:43 GMT
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.patel@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.

Mime
View raw message