I created a unit of measure for mm in the following
cm Length / Distance
Day(s) Working Time
Dozen(s) Unit
fl oz Volume
foot(ft) Length / Distance
g Weight
gal(s) Volume
Hour(s) Working Time
inch(es) Length / Distance
kg Weight
km Length / Distance
lb(s) Weight
Liter(s) Volume
m Length / Distance
mile(s) Length / Distance
mm Length / Distance
However when I import the data I get the following error message:
No matching record found for external id 'mm' in field 'Purchase Unit of Measure' at row 2
- No matching record found for external id 'mm' in field 'Purchase Unit of Measure' at row 3
It display the table without the created mm
Complete ID Display Name Model Name Record ID
product.product_uom_cm cm product.uom 10
What I have done is to duplicae cm and then modified the new measurement. I would have thopught that this would have been created in the data base.
Can some one please help me.
Tnx
your error message cannot be displayed
what error message?
I did not see the screen shots did not upload so I entered the data manually.
your error message cannot be displayed
--vasanth
Sent by Odoo S.A. using Odoo about Forum Post Unit of Measure
I did not see the screen shots did not upload so I entered the data manually.
what error message?
Sent by Odoo S.A. using Odoo about Forum Post Unit of Measure
Try to (re)create this unit (mm) without duplication
I deleted the previous one.
Recreated it it had no errors when I created it.
This is the error:
at row 2
<img src="cid:part3.07040101.03020506@connect-at.net" alt="">
You can see it does exist:
<img src="cid:part4.00040003.06020205@connect-at.net" alt="">On 2015-01-13 03:16 PM, Med Said BARA wrote:
Try to (re)create this unit (mm) without duplication
--Med Said BARA
Sent by Odoo Inc. using Odoo about Forum Post Unit of Measure
Try to (re)create this unit (mm) without duplication
--Med Said BARA
Sent by Odoo Inc. using Odoo about Forum Post Unit of Measure
I tried with the full name:
at row 2
When looking at the table mm is not in the table:
<img src="cid:part3.04040008.06070209@connect-at.net" alt="">
Try to (re)create this unit (mm) without duplication
--Med Said BARA
Sent by Odoo Inc. using Odoo about Forum Post Unit of Measure
Strange, the UoM mm is not in the UoM list !
With PgAdmin, can you take a look at the product_uom Table to see if mm is created?
id | create_date | write_uid | active | write_date | uom_type | create_uid | name | rounding | factor | category_id
----+----------------------------+-----------+--------+----------------------------+-----------+------------+----------+----------+-----------------------+------------
-
1 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | reference | 1 | Unit(s) | 1.0 | 1.0 | 1
2 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | bigger | 1 | Dozen(s) | 0.01 | 0.08333333333333333 | 1
3 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | reference | 1 | kg | 0.001 | 1.0 | 2
4 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | g | 0.01 | 1000.0 | 2
5 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | Hour(s) | 0.01 | 8.0 | 3
6 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | reference | 1 | Day(s) | 0.01 | 1.0 | 3
7 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | bigger | 1 | t | 0.01 | 0.001 | 2
8 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | reference | 1 | m | 0.01 | 1.0 | 4
9 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | bigger | 1 | km | 0.01 | 0.001 | 4
10 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | cm | 0.01 | 100.0 | 4
11 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | reference | 1 | Liter(s) | 0.01 | 1.0 | 5
12 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | lb(s) | 0.01 | 2.20462 | 2
13 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | oz(s) | 0.01 | 35.274 | 2
14 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | inch(es) | 0.01 | 39.3701 | 4
15 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | foot(ft) | 0.01 | 3.28084 | 4
16 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | bigger | 1 | mile(s) | 0.01 | 0.0006213727366498068 | 4
17 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | fl oz | 0.01 | 33.814 | 5
18 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | smaller | 1 | qt | 0.01 | 1.05669 | 5
19 | 2014-12-28 07:25:01.704621 | 1 | t | 2014-12-28 07:25:01.704621 | bigger | 1 | gal(s) | 0.01 | 0.26417217685798894 | 5
23 | 2015-01-13 13:30:35.476722 | 1 | t | 2015-01-13 13:30:35.476722 | smaller | 1 | mm | 0.01 | 1000.0 | 4
(20 rows)
Regards
With PgAdmin, can you take a look at the product_uom Table to see if mm is created?
--Med Said BARA
Sent by Odoo Inc. using Odoo about Forum Post Unit of Measure