The following question was asked on the Ofbiz mailing list, however I believe it’s quite interesting to explore this functionality in Moqui as well, as the use case is quite common in our case as well. If you have some feedback about this case in Moqui, it would be greatly appreciated.
Hi Community,
I need some help understanding how order management and inventory handling
work with Units of Measure (UoM) in OfBiz, specifically regarding UoM
conversions.
I see that UoM can be defined in:
- Product Measures
- Supplier Products
- Prices
- Inventory Items
Could someone explain how OfBiz manages inventory tracking in the facility
when purchasing and selling products using different UoMs?
Here's a practical example:
- Product 1 is defined with the UoM "each".
- I prefer to track inventory for Product 1 in "each".
- I purchase this product in boxes (each box contains 10 pieces).
- I sell this product in different boxes (each box contains 20 pieces).
My current setup:
- Product Measures: each
- Supplier Product UoM: box (10 pieces per box)
- Prices UoM: box2 (20 pieces per box)
- UoM conversions are set in the UoM conversion table.
When making a purchase using the "box" UoM, I noticed OfBiz does not
populate the UoM field in the inventory item. Also OfBiz do not do UoM
conversion when making shipment.
My questions:
1. What is the correct and expected behavior in OfBiz regarding UoM
assignment for inventory items upon receipt? Should the inventory item be
created using "each," "box," or remain blank?
2. What is OfBiz's recommended approach or logic for handling UoM
conversions during goods receipt?
3. Is it possible in OfBiz to enter shipments in a UoM different from the
one defined in Product Measures?
Thank you in advance for your guidance!
Alexander