Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
While importing BoM records in chunks of 1,000, everything was going along swimmingly, until about record 10,000. At that point, I received this error:
new row for relation "mrp_bom" violates check constraint "mrp_bom_bom_qty_zero" DETAIL: Failing row contains (18480, 1, 2014-07-18 17:53:15.396004, 2014-07-18 17:53:15.396004, 1, null, null, 1, null, null, 0.000, null, 1, t, 0, HDL081, null, 1, null, 29253, 2928, null, normal). at row 33
Looking at my import file, I can't find any difference between the offending record and any others. There is a non-zero value (0.0004) in the column for quantity required, so I'm thinking that maybe the error is in something that OpenERP is filling in automagically? Or perhaps there is some sort of rounding applied by OpenERP, and since the value is so small, it considers it zero?
It does appear that the value of 0.0004 was rounded to 0.000. See the 5th value before the part name "HDL081" in the error. After some googling, I have seen multiple posts that say to to go "Settings-->Technical-->Database-->Decimal Accuracy", but that option wasn't present when I looked. Turns out that you have to go into the User permissions settings and enable the "Technical Features" option first, then you will be able to set decimal precision.
Hope this helps someone else with the same problem!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/18/14, 2:36 PM|
|Seen: 1348 times|
|Last updated: 3/16/15, 8:10 AM|