Odoo Help


How to ensure serial number is unique?

David Dean
on 9/3/13, 6:04 PM 1,311 views

Is there any way of making serial numbers:

1 - Unique 2 - Constrained, e.g. only an integer of a set number of digits

My product serial numbers are always a set number of digits and are unique per manufactured product, so OpenERP needs to help enforce that when warehouse users are entering the serial numbers.



Abhishek H Menon
On 9/9/13, 10:36 AM

if we want to specify an attribute as an unique attribute in openerp, we have to use _sql_constraints dictionary, we have to give the unique rule in that dictionary.

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


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/3/13, 6:04 PM
Seen: 1311 times
Last updated: 3/16/15, 8:10 AM