ADempiere Libero Manufacturing - Unit of Measure UOM Gotcha
The purpose of this post is to help solve a common mistake in ADempiere Libero Manufacturing - using fractions with 'Each' unit of measure UOM.
One common issue that pops up when people start to experiment with ADempiere manufacturing involves the 'Each' unit of measure or UOM. By default, 'Each' has a quantity or standard precision of 0 as defined in the Unit of Measure window. This means the quantity will be rounded to the nearest integer.
This situation causes an issue when you have BOM lines that use a fraction of a single product. If you are cutting pieces (fraction) from a sheet of plastic with UOM=EA to manufacture your product, your BOM cost rollup (Bill of Material & Formula Cost Roll-UP) process will yield a zero cost for that BOM line.
There are two solutions to this issue:
- Option 1: Log in as System Administrator and change Standard Precision field from 0 to 2 in the 'Each' record in the Unit of Measure window. Doing so will give you the ability to specify products down to the hundreds position.
- Option 2: Change the product's UOM from Each to something with a greater Standard Precision. Be aware that ADempiere does not let you change the UOM if you have transaction history. If so, you will need to deactivate your old product, and create a new version with the new UOM.
Over the last year, I have spent much of my time in the Libero ADempiere manufacturing module performing make to stock and make to order manufacturing across multiple distribution centers. Let me know if you would like help establishing your manufacturing process in free, open source ERP.
I hope this helps!!!
ADempiere vs iDempiere vs Openbravo vs Compiere
Please note that ADempiere, iDempiere and Openbravo are forks or copies from Compiere. Therefore, they have similar abilities mentioned above. The biggest difference is that ADempiere and iDempiere are pure open source. There are no features held behind a commercial or paid license.
About Chuck Boecking:
I am an ERP and BI integrator and educator. I believe that open source ERP and BI have achieved mainstream capabilities, and as a result, more companies can create greater efficiency across their organization.
I started using the ADempiere and iDempiere code base in 2003. Back then, it was called Compiere. In 2006, I started my first multi-million dollar installation. Since then, ADempiere has helped me create great success with distribution and manufacturing companies all over the US and Canada.
My vision of success is to find companies that can best use open source ERP and BI to deliver a single, global instance that drives a discontinuous increase in profitability.
I believe that organizations win when they own their technology.