This question has been flagged
5961 Views

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

Get all possible values

(606 more)

  • No matching record found for external id 'mm' in field 'Purchase Unit of Measure' at row 3

    Get all possible values

 

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

 

Avatar
Discard

your error message cannot be displayed

Sorry,

I did not see the screen shots did not upload so I entered the data manually.

On 2015-01-13 01:26 PM, vasanth wrote:
<blockquote cite="mid:1421148389.108205080032349.479616764590278-openerp-72987-forum.post@accounts.odoo.com" type="cite">

your error message cannot be displayed

--
vasanth
Sent by Odoo S.A. using Odoo about Forum Post Unit of Measure
Sorry,

I did not see the screen shots did not upload so I entered the data manually.
On 2015-01-13 01:27 PM, Emipro Technologies Pvt. Ltd. wrote:
<blockquote cite="mid:1421148460.651072025299072.048808896556879-openerp-72987-forum.post@accounts.odoo.com" type="cite">

what error message?

Emipro Technologies is best in Odoo & eCommerce Application development based outsourcing software firm. We deliver any kind of complex solutions in the domain of Odoo and eCommerce to customers accross the globe. Being in IT business since 2011, We have a strong team of skilled experienced IT experts.Our customers are companies of all sizes ranging from startups to large enterprises who realize that they need a professional internet solution to generate revenue streams, establish communication channels or streamline business operations.

Our Services in Odoo includes,
  • Installation
  • Customization
  • Configuration
  • Software Training
  • After Sale Support
  • Maintenance
  • Consulting
Contact info@emiprotechnologies.com for any kind of queries in Odoo. Visit www.emiprotechnologies.com for more details.




 

Sent by Odoo S.A. using Odoo about Forum Post Unit of Measure

Try to (re)create this unit (mm) without duplication

Hi,

I deleted the previous one.
Recreated it it had no errors when I created it.


This is the error:
No matching record found for external id 'mm' in field 'Purchase Unit of Measure' at row 2 (606 more)

<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:
<blockquote cite="mid:1421155013.533305883407593.663369681020892-openerp-72987-forum.post@accounts.odoo.com" type="cite">

Try to (re)create this unit (mm) without duplication

--
Med Said BARA
Sent by Odoo Inc. using Odoo about Forum Post Unit of Measure
This is what the file looks like:

<td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True <td sdnum="7177;0;@" align="left">True
default_code Name description_sale list_price sale_price create_date sale_ok Active uom_po_id/id type purchase_ok uos_coeff mes_type
COMPBCSG Bracket Catch Sliding gate Bracket Catch Sliding gate 43.45 43.45 9/27/2014 8:06:00 mm Stockable Product1 fixed
COMPBCV Bracket Corner Vertical Bracket Corner Vertical 3.61 3.61 9/27/2014 8:06:00 mm Stockable Product1 fixed
COMPBH Bracket Palisade Swivel Horizonta Bracket Palisade Swivel Horizonta 2.57 2.57 9/27/2014 8:06:00 mm Stockable Product1 fixed
COMPBP150 Base Plate 150 x 150mm Base Plate 150 x 150mm 15.08 15.08 9/27/2014 8:06:00 mm Stockable Product1 fixed
COMPBV Bracket Palisade Swivel Vertical Bracket Palisade Swivel Vertical 6.46 6.46 9/27/2014 8:06:00 mm Stockable Product1 fixed



On 2015-01-13 03:16 PM, Med Said BARA wrote:
<blockquote cite="mid:1421155013.533305883407593.663369681020892-openerp-72987-forum.post@accounts.odoo.com" type="cite">

Try to (re)create this unit (mm) without duplication

--
Med Said BARA
Sent by Odoo Inc. using Odoo about Forum Post Unit of Measure
Hi,

I tried with the full name:
No matching record found for external id 'product.product_uom_mm' in field 'Purchase Unit of Measure' at row 2 (606 more)


When looking at the table mm is not in the table:

<img src="cid:part3.04040008.06070209@connect-at.net" alt="">
On 2015-01-13 03:16 PM, Med Said BARA wrote:
<blockquote cite="mid:1421155013.533305883407593.663369681020892-openerp-72987-forum.post@accounts.odoo.com" type="cite">

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?

palisadeword=# select * from product_uom;
 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


On 2015-01-13 05:17 PM, Med Said BARA wrote:
<blockquote cite="mid:1421162239.364713907241821.300817955884232-openerp-72987-forum.post@accounts.odoo.com" type="cite">

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