Welcome!

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

Register
5

OpenERP V7 : Product Serial Number

By
r.openerp
on 3/15/13, 2:28 PM8608 views

Hi, We are looking for implementing the OpenERP v7 in our business.

How to use the Serial Number in OpenERP 7

Our business is based on products with serial number, each one have a unique serial number even if it's the same product

Here is a use case :

We Buy 10 computers IBM-ThinkPad-T430 each one have a unique Serial Number We Stock theme We Sale 5 computers with the serial number in Point of sales (POS) -> So in the POS Order/Receipt we must have 5 lines of the same product with different Serial Number

We need to track each product with his serial number

I started use it in picking order but i get error when clicking on the split icon

Any idea how to use?

thanks in advance

what error?

Davide Corio
on 3/15/13, 2:40 PM

4
Fabrice Henrion (fhe)
On 3/15/13, 8:38 PM

OpenERP 7 doesn't support serialization at the product level, only at the lot level. The only workaround is to create lots with only 1 item in them. It is time-consuming if you have a lot of serials.


Thanks, That is the only way, by traking whith lot, I get a new error : In delivery order I create a line to deliver a prodcut, i go to split listbox in order to choose the right product serial number to deliver, when selecting a serial number i get these error : these is the most importante lines :

r.openerp
on 3/18/13, 6:17 AM

File "/home/odoo/runbot/static/openerp-dev-7-0-6503/server/openerp/addons/stock/stock.py", line 1813, in onchange_lot_id product_uom = product_obj.browse(cr, uid, product_id, context=ctx).uom_id File "/home/odoo/runbot/static/openerp-dev-7-0-6503/server/openerp/osv/orm.py", line 484, in __getattr__ return self[name] ...... ProgrammingError: operator does not exist: integer = boolean LINE 1: ...d FROM "product_product" WHERE product_product.id IN (false)... HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

r.openerp
on 3/18/13, 6:20 AM

I wonder if 'Serial Number' in 7.0 needs to be renamed back to 'Lot Number'?

Ursa Information Systems, Ray Carnes
on 3/28/13, 6:24 PM
Fabrice Henrion (fhe)
on 3/28/13, 11:44 PM

2
Sebastien beau
On 6/8/13, 3:04 PM

Hi my co-worker have port the product_serial some day ago you can find it on the project "OpenERP Stock And Logistic - Flows" in launchpad "launchpad.net/stock-logistic-flows" (sorry I can no add the link because my karma is unsufficient)

We use it since V5. Try it and if you have some question ask my help.

See you


Hi Sebastien, We have been using the product_serial which works like a charm in some situations. However, there is a point to take into account before choosing this option. We found that it was not suitable when you need to receive / ship large quantities of products because it will generate one stock move line for each unit. It is the case of phone cards distributor. When facing the problem, we used a concept of Range (of serial numbers) on the stock move. We create serial numbers (production lot) automatically at reception, each serial number (production lot) is still created.

Trobz, Jean-Charles Drubay
on 6/9/13, 11:00 PM

Hi..

You need to go to the product page. In the Sales tab (if there is none, click can be sold option) select a packaging information. If there is one click on it. If none, click add an item at the bottom. Adjust the needed fields. Change the quantity in the package to 0 for to keep the large quantities as the logistical unit acting as one. When you are receiving you will see that it keeps the items together not seperate.

Also we have developed another module on top of this using serial numbers with barcodes.

7Gates Interactive Technologies, Erdem Uney
on 8/27/13, 11:19 PM

Hi Sebastien, is it possible it allow multiple instance of a serial number by product ? I was able to have 3 product with the same serial number ?

Savoir-Faire Linux, Philippe Latouche
on 12/5/13, 12:21 PM

0
ifan kang
On 2/25/15, 6:05 AM

Hi I looking for  how to use serial number in Odoo.

Our product is mobile device. Each product has 1 serial number and 2 imei number (or 1 imei number).

We need to track each product with his serial number or imei

I had try module wrote by Cesar Lopez in Odoo and mobile data management by Vertel from apps.openerp.com

change the import path but get error when installing 

File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\modules\registry.py", line 101, in __getitem__ KeyError: 'stock.picking.in'

Please help me 

Thanks before

Traceback (most recent call last): File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\http.py", line 530, in _handle_exception File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\http.py", line 567, in dispatch File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\http.py", line 303, in _call_function File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\service\model.py", line 113, in wrapper File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\http.py", line 300, in checked_call File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\http.py", line 796, in __call__ File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\http.py", line 396, in response_wrap File "C:\Program Files (x86)\Odoo 8.0-20150213\server\openerp\addons\web\controllers\main.py", line 953, in call_button File "C:\Program Files (x86)\Odoo 8.0-20150213\server\openerp\addons\web\controllers\main.py", line 941, in _call_kw File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\api.py", line 241, in wrapper File "C:\Program Files (x86)\Odoo 8.0-20150213\server\openerp\addons\base\module\module.py", line 450, in button_immediate_install File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\api.py", line 241, in wrapper File "C:\Program Files (x86)\Odoo 8.0-20150213\server\openerp\addons\base\module\module.py", line 498, in _button_immediate_function File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\modules\registry.py", line 366, in new File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\modules\loading.py", line 355, in load_modules File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\modules\loading.py", line 255, in load_marked_modules File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\modules\loading.py", line 152, in load_module_graph File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\modules\registry.py", line 162, in load File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\models.py", line 591, in _build_model File "C:\Program Files (x86)\Odoo 8.0-20150213\server\.\openerp\modules\registry.py", line 101, in __getitem__ KeyError: 'stock.picking.in'



0
Cesar Lopez Aguillon
On 5/15/14, 6:14 PM

Hello, i wrote this module, maybe you find it useful.

https://launchpad.net/openerp-serial-number

Best regards,

 

Cesar Lopez



0
Bla lasldasd
On 8/8/14, 4:06 AM

The error have been fixed in the last brunch in runbot platform, now the split works but you need to refresh the screen to get the list of product splited (in V6 it's refreshed automatically after closing the split wizard ), thank you


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

5 follower(s)

Stats

Asked: 3/15/13, 2:28 PM
Seen: 8608 times
Last updated: 3/23/15, 12:59 AM