Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
stocklottracking
3 Vastaukset
12008 Näkymät
Avatar
TK

We are using lots to track our products. After purchasing a product we receive it and put the lot number that the vendor stated into the lot number field that has to be filled in when validating the receipt. As an example we have product xy with lot number 1234 on stock. If we have another delivery of that product with an identical lot number Odoo refuses to validate the receipt. Error: 'The combination of serial number and product must be unique!'
This seems to be done via a sql_constraint in stock_production_lot.py in the modul "stock" class Class ProductionLot :

_sql_constraints = [('name_ref_inique', 'unique(name, product_id)', 'The combination of serial number and product must be unique!'),]

I tried to comment the lines out but this does not help. There is another error

IntegrityError : dublicate key value violates unique constraint "stock_production_lot_name_ref_uniq"

DETAIL: Key(name, product_id)=(1234, 18) already exist.


Is there a way to remove that constraint and keep the rest of the functionality? We do not want to disable lots and serial number tracking.

Background: In our business it is quite normal that a vendor sells parts with a certain lot not only in one delivery but in several after another. The lot is often stamped into the part and changing the lot number in Odoo (adding another identification number like the receipt number) would confuse our processes.


Avatar
Hylkää
Avatar
faOtools
Paras vastaus

Hi,

you should both comment the line and remove the constraint from Postgre.

Have a look at: https://www.odoo.com/forum/help-1/question/remove-sql-constraints-5431

Alternatively you may redefine this sql contsraint in your Python class:

class stock_production_lot(models.Model):    
    _inherit = "stock.production.lot"
    _sql_constraints = [('name_ref_inique', 'check(1=1)', 'No error'),]
Avatar
Hylkää
Avatar
Ibrahim Boudmir
Paras vastaus

Hi, 
Just remove the contsraint manually from your python file and from the database. 

try this : 
ALTER TABLE Your_table_name DROP CONSTRAINT Your_constraint_name;

Avatar
Hylkää
Avatar
TK
Tekijä Paras vastaus

Thank you for your answers I did not try them because it turned out that we could solve the problem by ticking an option in the settings of the operation "receipt", field "use_existing_lots" in stock.picking.type.

I am glad that I do not have to alter the database by hand.

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
[V13] easiest way to convert non tracking products to Tracking product even if they have stock on hand! Ratkaistu
inventory lot tracking
Avatar
Avatar
Avatar
2
toukok. 20
3923
How to identify a lot/serial as consumed or unconsumed product using only lot_id
stock lot odoo-10
Avatar
0
huhtik. 18
3436
assembly of virtual parts
stock manufacturing tracking
Avatar
Avatar
1
heinäk. 16
4334
production lot number creation
stock tracking production_lot
Avatar
0
maalisk. 15
6617
stock.pack.operation.lot in Odoo11
stock lot odoo9 odoo11
Avatar
0
toukok. 21
2850