Re: Quantity in inventory transfer
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 > -- View this message in context: http://www.nabble.com/Quantity-in-inventory-transfer-tp24407177p24407263.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Quantity in inventory transfer
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 -- View this message in context: http://www.nabble.com/Quantity-in-inventory-transfer-tp24407177p24407177.html Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: add order item - status created
Hi, sorry, I didnt make it clear before. I tried to add new order item to existing Approved order. So, I dont think we can change the status from APPROVED to CREATED, right? Unless we tweak the database or by running changeOrderStatus service. And, if you said that you change the status of the order to CREATED, what is the difference if I add a new order item, then I HOLD the order and APPROVE it. The amount of work are still the same. Lyyas Yasin On Fri, 2008-12-19 at 05:21 -0600, Nikita Shinde wrote: > Hi, > > > >What we did to get a workaround this behavior was by changing the status > of the order to created again so that it would be required to re-approve the > order. > > > > Kind Regards, > > Nikita Shinde > > Amicon Technologies Pvt. Ltd., Mumbai, India. > > India's No.1 OFBiz service provider > > > > > > -Original Message- > From: yasin lyyas [mailto:yasin.ly...@virtualvillage.com] > Sent: Friday, December 19, 2008 4:06 PM > To: user@ofbiz.apache.org > Subject: add order item - status created > > > > Hi all, > > > > when I add a new order item to existing order, the order item status is > > CREATED. Therefore, the result is we cannot pack this order. I cannot > > find anything on the order detail page where I can update the order item > > status. I got a workaround to this behaviour by holding and approving > > the order again. Is this supposed to work this way? I tested on demo > > server, it happens there as well. Thanks for the reply. > > > > > > Lyyas > > Yasin >
add order item - status created
Hi all, when I add a new order item to existing order, the order item status is CREATED. Therefore, the result is we cannot pack this order. I cannot find anything on the order detail page where I can update the order item status. I got a workaround to this behaviour by holding and approving the order again. Is this supposed to work this way? I tested on demo server, it happens there as well. Thanks for the reply. Lyyas Yasin
Packaging Material
Hi all, is there a way to track how many packaging material we use for every parcel, and how many of them are left so we can reorder them again? Thanks, Lyyas Yasin
entity-extend or create a new entity
Hi all, I have a dilemma here with product cost. As we know that we keep the information about product cost in InventoryItem. But, I cannot really use the product cost from InventoryItem, since the cost there is not quite correct for some InventoryItem. Users sometimes typed in a wrong number or that kind of actions. What I need is a "Master product cost" somewhere which is related to Product. So, which way is better, extending the existing entity (Product), or create an entirely new entity to hold Product_id and cost? Any suggestion? Thanks Lyyas Yasin
Re: inventory item status
Hi, thanks for your reply, I have checked it and the problem is clear to me now. Thanks a lot. Lyyas Yasin On Wed, 2008-10-22 at 03:53 -0500, BJ Freeman wrote: > which rev are you using > have you changed anything else that might effect the information > > based on last rev > look at InventoryServices.checkInventoryAvailability > about line 401. > this will tell you the criteria used. > > > yasin lyyas sent the following on 10/22/2008 1:26 AM: > > Hi, > > > > thanks for the reply. The Inventory is a non-serialized inventory. Also, > > we edit something in service to process returned item so that the > > InventoryItem StatusId will be set to null. I know this should not be > > done this way, but it has been done now and its in production server. I > > just need a clarify that, a blank InventoryItem status id will not give > > us problem with a reservation made to this InventoryItem. > > > > > > On Wed, 2008-10-22 at 03:09 -0500, BJ Freeman wrote: > >> there is a > >> INV_NON_SER_STTS group as well > >> as well > >> and if a new InventoryItem is created is should have _NA_ till either > >> one of then INV_NON_SER_STTS or INV_SERIALIZED_STTS are assigned. > >> this is so views that include Status will show. > >> > >> Mridul Pathak sent the following on 10/22/2008 12:32 AM: > >>> AFAIK, Inventory Item Status are used only in case of serialized > >>> inventory, > >>> and not for non-serialized ones. So in case of non-serialized inventory > >>> items you may find blank inventory item status. > > > > yasin lyyas sent the following on 10/20/2008 2:24 AM: > >> Hi all, > >> > >> I have a question here regarding the inventory item status id. If the > >> status id is blank (null), what will happen if there is a reservation > >> made to this inventory item? In our case, we have a returned inventory > >> item. Status ID for this inventory item has been removed ( becomes > >> blank), and it has 10 qoh and atp. When a reservation made to this > >> inventory item, the order becomes a backorder. atp/qoh is 9/10, but in > >> reservation table, it shows the qty not available = 1. > >> > >> Can we not leave the inventory item status blank? > >> > >> Thanks > >> > >> Lyyas > >> Yasin > >> > >> > >> > > > > > >
Re: inventory item status
Hi, thanks for the reply. The Inventory is a non-serialized inventory. Also, we edit something in service to process returned item so that the InventoryItem StatusId will be set to null. I know this should not be done this way, but it has been done now and its in production server. I just need a clarify that, a blank InventoryItem status id will not give us problem with a reservation made to this InventoryItem. On Wed, 2008-10-22 at 03:09 -0500, BJ Freeman wrote: > there is a > INV_NON_SER_STTS group as well > as well > and if a new InventoryItem is created is should have _NA_ till either > one of then INV_NON_SER_STTS or INV_SERIALIZED_STTS are assigned. > this is so views that include Status will show. > > Mridul Pathak sent the following on 10/22/2008 12:32 AM: > > AFAIK, Inventory Item Status are used only in case of serialized inventory, > > and not for non-serialized ones. So in case of non-serialized inventory > > items you may find blank inventory item status. yasin lyyas sent the following on 10/20/2008 2:24 AM: > Hi all, > > I have a question here regarding the inventory item status id. If the > status id is blank (null), what will happen if there is a reservation > made to this inventory item? In our case, we have a returned inventory > item. Status ID for this inventory item has been removed ( becomes > blank), and it has 10 qoh and atp. When a reservation made to this > inventory item, the order becomes a backorder. atp/qoh is 9/10, but in > reservation table, it shows the qty not available = 1. > > Can we not leave the inventory item status blank? > > Thanks > > Lyyas > Yasin > > >
Re: Bug in packing order for product with associations
Thanks for the fix, Jacques. Cheers, Lyyas Yasin - Original Message - From: Jacques Le Roux <[EMAIL PROTECTED]> To: user@ofbiz.apache.org Sent: Sun Oct 19 16:53:12 2008 Subject: Re: Bug in packing order for product with associations Thanks for the report Yasin, This is fixed in revision 706067. Note that the Quick Ship option was working correctly. Jacques From: "Jacques Le Roux" <[EMAIL PROTECTED]> >I will have a look since I did some changes around (made a workaround for a >bug in PDF) recently > > Jacques > > From: "yasin lyyas" <[EMAIL PROTECTED]> >> Hi all, >> >> it seems that there is a bug in packing orders which contain products >> with associations. The quantity of how many products should be packed is >> lacking the multiplication. Try to replicate this process in demo >> worksite: >> 1. Create, finalize and approve an order which contain order item >> GZ-BASKET-PICK, choose the quantity 5 >> 2. Go to packing and check the quantity of component products to be >> packed >> >> The quantity to be packed there only shows 5 for each product component. >> Is it normal or we missed some steps somewhere? >> >> GZ-BASKET-PICK has 3 product components in association table: >> 1. 1 of GZ-1000 >> 2. 2 of GZ-1001 >> 3. 3 of GZ-1004 >> >> The result should be : >> 1. 5 of GZ-1000 >> 2. 10 of GZ-1001 >> 3. 15 of GZ-1004 >> >> Hope I am clear enough to describe the case. Thanks >> >> Lyyas >> Yasin >> >
inventory item status
Hi all, I have a question here regarding the inventory item status id. If the status id is blank (null), what will happen if there is a reservation made to this inventory item? In our case, we have a returned inventory item. Status ID for this inventory item has been removed ( becomes blank), and it has 10 qoh and atp. When a reservation made to this inventory item, the order becomes a backorder. atp/qoh is 9/10, but in reservation table, it shows the qty not available = 1. Can we not leave the inventory item status blank? Thanks Lyyas Yasin
Bug in packing order for product with associations
Hi all, it seems that there is a bug in packing orders which contain products with associations. The quantity of how many products should be packed is lacking the multiplication. Try to replicate this process in demo worksite: 1. Create, finalize and approve an order which contain order item GZ-BASKET-PICK, choose the quantity 5 2. Go to packing and check the quantity of component products to be packed The quantity to be packed there only shows 5 for each product component. Is it normal or we missed some steps somewhere? GZ-BASKET-PICK has 3 product components in association table: 1. 1 of GZ-1000 2. 2 of GZ-1001 3. 3 of GZ-1004 The result should be : 1. 5 of GZ-1000 2. 10 of GZ-1001 3. 15 of GZ-1004 Hope I am clear enough to describe the case. Thanks Lyyas Yasin