Sponsored Development: Inventory UOMs and UOM Conversion Enhancements
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
Contents
- 1 Project Team
- 2 Requirements
- 3 Why
- 4 Requirements - First Draft:
- 4.1 Conversion Rates on different Levels
- 4.2 Support for indirect Conversion Rates
- 4.3 UOM Conversion Rates based on Product Attributes and Formulas
- 4.4 Support for three UOMs per Product Inventory Value
- 4.5 Support for Pricelist UOMs
- 4.6 Storage UOMs not always the smallest UOM
- 4.7 Groups of UOMs
- 4.8 Integration of physical standard UOMs
- 5 Links
- 6 Glossary
Project Team
Coordinator
Functional Specs
- Christian Cerny (freecom gmbh) and Team
- please add your name here
Developers
- to be defined
Review & Testers
- Christian Cerny (freecom gmbh)
- Stefan Kuthan (freecom gmbh)
- please add your name here
Sponsors
- [freecom gmbh]
- please add your name here
Requirements
Why
- Inventory UOMs and UOM Conversions is are limiting at the moment:
- only one uom per product
- conversion rate only per product
- conversion rate needs to be entered in both directions
- no price UOM
- storage UOM needs to be the smallest UOM
- ...
- Extremly important in complex manufacturing
Requirements - First Draft:
Conversion Rates on different Levels
- System Wide
- e.g. km -> m -> mm
- Product Group
- e.g. conversion based on the "specific weight" of a material of a product group
- Product
- e.g. weight of a specific product
- Lot
- e.g. product weight differs slightly per lot
- Handling Unit (we don't have handling units anyway at the moment;-)
- e.g. product differce slightly per handling unit
- Material Receipt Level
- see meat example from Trifon:
- https://sourceforge.net/forum/message.php?msg_id=4464250
Solution Proposals
Support for indirect Conversion Rates
e.g. if the conversion rates from mm -> m and the conversion rates from m -> km are available the system should be able to convert mm -> km and the other way
UOM Conversion Rates based on Product Attributes and Formulas
- Example:
- A printing company orders sheets of paper on pallets.
- The paper comes on a pallet with a label: 1000 kg, size: 700x1000 mm, Grammage: 80g/m2
- For further processing the company needs to know the rough number of sheets on the pallet
- Calculation would be like this:
- Weight of one Sheet: 700 mm * 1000 mm * 80 g = 56 g
- It should be possible to have formulas per ProductAttributeSet (?) which calulates the new conversion rate when the Attribute for this product is changed and updates the conversion rate for this product.
- The product Attributes would be:
- GRAMMAGE: 80 g
- SIZE_LENGTH: 700 mm
- SIZE_WIDTH: 1000 mm
Support for three UOMs per Product Inventory Value
at the Moment Inventory is only tracked for one UOM.
- first/Master UOM:
- Storage or Stock Keeping Unit (SKU) of a Product.
- Leading UOM for this product (Costing)
- e.g. liters of beer
- 2nd/3rd UOM:
- e.g. additional Inventory UOM
- e.g. beer cans
- e.g. Replenishment UOM - MRP relevant
- e.g. cartons of beer cans)
details to be added
Support for Pricelist UOMs
- Price UOMs
- It should be possible to have a price list (sales, purchasing) in a different UOM, than the storage UOMs.
Storage UOMs not always the smallest UOM
- There is no general reason for this limitation
- needs to be discussed further
Groups of UOMs
- Definition of UOM Groups
- Can be assigned to Product or ProductGroup as allowed Sales/Purchasing/other UOM Group
example to be added
Integration of physical standard UOMs
- Standard UOMs (e.g. SI UOMs) and there Conversion Rates should be available in the system
example to be added
Links
Discussion in Forum: https://sourceforge.net/forum/forum.php?thread_id=1797716&forum_id=611158
Related Trackers:
- [Add C_UOM_ID to MProductPrice]
- [Issue when you need buy with um minor that stoked]
- [Improvements to Sales/Purchase]
Glossary
- UOM -> Unit of Measurement