Quantity in inventory transfer

[Yasin Lyyas]

Hi people,

I have a question regarding the inventory transfer. When we requested an inventory transfer, the atp for associated inventory item will be nullified to prevent reservation on this to-be-transferred inventory item. For example, inventory item 1000, has atp/qoh = 10/10. And we request an inventory transfer with quantity 5. The inventory item will split into 2. Inventory item 1000 will have atp/qoh = 5/5 while inventory 1001 (newly auto-created) will have atp/qoh = 0/5. The atp will stay as long as the inventory transfer is not completed.
The problem is:
1. when someone else checks this inventory, he will have no clue why the atp/qoh is 0/5 and there is no order reservation in that inventory item 1001
2. I want to check the inventory balance among "ATP", "QOH", "Reserved quantity" and "Reserved not available quantity". And just pulling out the ATP and QOH directly from inventory item wont guarantee the accuracy due to inventory transfer. I am struggling to get the quantity which "stucked" in inventory transfer

Can someone help me point to how to get the quantity in inventory transfer please? Thanks


Lyyas
Yasin

[Yasin Lyyas]

Sorry, forgot to mention that we are currently using OFBiz version 4.0 and in phase of upgrading it to OFBiz 9.04. I saw in org.ofbiz.product.inventory.InventoryServices, there is a TODO part in the doing inventory transfer code. It says something that need to get inventoryTransferId to put in inventoryitemDetail. This TODO part is still exist in OFBiz 9.04.

Yasin Lyyas wrote

Hi people,

I have a question regarding the inventory transfer. When we requested an inventory transfer, the atp for associated inventory item will be nullified to prevent reservation on this to-be-transferred inventory item. For example, inventory item 1000, has atp/qoh = 10/10. And we request an inventory transfer with quantity 5. The inventory item will split into 2. Inventory item 1000 will have atp/qoh = 5/5 while inventory 1001 (newly auto-created) will have atp/qoh = 0/5. The atp will stay as long as the inventory transfer is not completed.
The problem is:
1. when someone else checks this inventory, he will have no clue why the atp/qoh is 0/5 and there is no order reservation in that inventory item 1001
2. I want to check the inventory balance among "ATP", "QOH", "Reserved quantity" and "Reserved not available quantity". And just pulling out the ATP and QOH directly from inventory item wont guarantee the accuracy due to inventory transfer. I am struggling to get the quantity which "stucked" in inventory transfer

Can someone help me point to how to get the quantity in inventory transfer please? Thanks


Lyyas
Yasin

[BJ Freeman]

Means that no one in the community has considered this a priority to put
 energy in to  it.
if you would like to provide a patch:
http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices

Yasin Lyyas sent the following on 7/9/2009 2:50 AM:

> Sorry, forgot to mention that we are currently using OFBiz version 4.0 and in
> phase of upgrading it to OFBiz 9.04. I saw in
> org.ofbiz.product.inventory.InventoryServices, there is a TODO part in the
> doing inventory transfer code. It says something that need to get
> inventoryTransferId to put in inventoryitemDetail. This TODO part is still
> exist in OFBiz 9.04.
>
>
>
> Yasin Lyyas wrote:
>> Hi people,
>>
>> I have a question regarding the inventory transfer. When we requested an
>> inventory transfer, the atp for associated inventory item will be
>> nullified to prevent reservation on this to-be-transferred inventory item.
>> For example, inventory item 1000, has atp/qoh = 10/10. And we request an
>> inventory transfer with quantity 5. The inventory item will split into 2.
>> Inventory item 1000 will have atp/qoh = 5/5 while inventory 1001 (newly
>> auto-created) will have atp/qoh = 0/5. The atp will stay as long as the
>> inventory transfer is not completed.
>> The problem is:
>> 1. when someone else checks this inventory, he will have no clue why the
>> atp/qoh is 0/5 and there is no order reservation in that inventory item
>> 1001
>> 2. I want to check the inventory balance among "ATP", "QOH", "Reserved
>> quantity" and "Reserved not available quantity". And just pulling out the
>> ATP and QOH directly from inventory item wont guarantee the accuracy due
>> to inventory transfer. I am struggling to get the quantity which "stucked"
>> in inventory transfer
>>
>> Can someone help me point to how to get the quantity in inventory transfer
>> please? Thanks
>>
>>
>> Lyyas
>> Yasin
>>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.