Community: Inventory and MRP mailing list archives

expert-inventory@mail.odoo.com

Re: Quants only allowing whole number quantities

by
Josse Colpaert (jco)
- 02/04/2015 09:29:47
Simply Warehouse > Unit of Measurement (in the Configuration section underneath, you need access to multiple UoM) > in the form view you will see the field rounding

The Decimal Precision is applied on stock moves, purchase orders, sale orders, ...  and is always the same.  But you can have a higher/lower precision on quants according to the UoM.  For example if main uom is kg (0.000001) and you want to deliver in g (0.001) or you want to round to 1.0 for the Units.  

On Wed, Feb 4, 2015 at 3:22 PM, Garth Mathers <gmathers@intriquip.com> wrote:

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 [mailto:jco@openerp.com]
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 <gmathers@intriquip.com> 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

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-inventory-and-mrp-66
Post to: mailto:expert-inventory@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-inventory-and-mrp-66
Post to: mailto:expert-inventory@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe