Community: Inventory and MRP mailing list archives


RE: Quants only allowing whole number quantities

Garth Mathers
- 02/04/2015 09:21:41

Hello Jos


How do I set the Product UOM rounding?


I have tried going to Settings > Technical > Database Structure > Decimal Accuracy and have the “Product Unit of Measure” set to 4 instead of the default setting of 3. I have also tried setting this to 0.1, but this field will only accept integers. I have also tried setting this value to (-1) and it saves OK but then throws an error when I try to “Start Inventory” on a new Inventory Adjustment.


What am I missing? Thanks!


<img width="406" height="425" id="Picture_x0020_1" src="cid:image002.jpg@01D04053.970BA390">


Kind regards,


Garth Mathers


From: Jos Colpaert []
Sent: Wednesday, February 4, 2015 2:07 AM
To: Community: Inventory and MRP
Subject: Re: Quants only allowing whole number quantities


Of course, but it is using the rounding as you said on the product uom.  For 4 decimal places, you need a rounding of 0.0001. 


On Wed, Feb 4, 2015 at 6:46 AM, Garth Mathers <> wrote:

I am trying to use the Inventory Adjustment feature in Odoo v8. If I set the “Real Quantity” with a decimal value like 4.5 or 1.6, the Stock Move is created with decimal value but the Quant is created with the quantity rounded to the nearest whole number. And this means that the value of the quant is also wrong because it uses the cost price * the rounded quantity.


I have tried adjusting the decimal accuracy for the Product Unit of Measure to 4 and rebooting the server but I still get the same result.


Is it possible to configure Odoo to use decimal quantities on quants?


Kind regards,


Garth Mathers

Post to: