Odoo Help

Welcome!

This community 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.

0

Unit of Measure

By
Erastus
on 1/13/15, 6:23 AM 1,122 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

 

your error message cannot be displayed

Vasanth
on 1/13/15, 6:26 AM

what error message?

Emipro Technologies Pvt. Ltd.
on 1/13/15, 6:27 AM
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
Erastus
on 1/13/15, 7:18 AM
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
Erastus
on 1/13/15, 7:18 AM

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

Med Said BARA
on 1/13/15, 8:16 AM
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
Erastus
on 1/13/15, 8:43 AM
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
Erastus
on 1/13/15, 8:45 AM
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
Erastus
on 1/13/15, 9:54 AM

Strange, the UoM mm is not in the UoM list !

Med Said BARA
on 1/13/15, 10:06 AM

With PgAdmin, can you take a look at the product_uom Table to see if mm is created?

Med Said BARA
on 1/13/15, 10:17 AM
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
Erastus
on 1/13/15, 1:55 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 1/13/15, 6:23 AM
Seen: 1122 times
Last updated: 3/16/15, 8:10 AM