Sponsored Development: Inventory UOMs and UOM Conversion Enhancements

From ADempiere
Revision as of 06:55, 14 August 2007 by Chrisc at (Talk) (→‎UOM Conversion Rates based on Product Attributes and Formulas)

Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Project Team

Coordinator

Functional Specs

Developers

  • to be defined

Review & Testers

Sponsors

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

Requirements

  • 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

Solution Proposals

Issues & Discussion

Support for indirect Conversion Rates

Requierments

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

Solution Proposals

Issues & Discussion

UOM Conversion Rates based on Product Attributes and Formulas

Requierments

  • 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

Solution Proposals

Issues & Discussion

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:

Glossary

  • UOM -> Unit of Measurement
Retrieved from "http://www.adempiere.com/index.php5?title=Sponsored_Development:_Inventory_UOMs_and_UOM_Conversion_Enhancements&oldid=27008"