Purchase Module - Creating PO - Server Error: Reference Must be Unique per Company

Question

Having some issues saving this PO.
We are using Odoo to do some very basic purchasing and receiving.  I have about 50 items saved that could be purchased/received and only 2 locations. I built and received 13 PO's for the first location and those went great.
I tried to then build the first PO for the 2nd location, which does happen to have 1 line, which is already been purchased and received at the other location ( but why would that matter anyhow?) But when i build the new PO, with this 1 line

Waleed Ali Mohsen · Accepted Answer

I can reproduce you issue and got the same error as below.
Error [1]
This error raised from constraints in the stock_picking.py
_sql_constraints = [
('name_uniq', 'unique(name, company_id)', 'Reference must be unique per company!'),
] You have two *operation type* and each one has its sequence, that's mean you linked each operation type to different sequence and the sequence prefix is the same *WH/IN/* and your locations create same sequence which already used so you got the error.
Operations [

Workhour Group · Answer

Thanks Waleed. This help me resolve the same error from the POS module. Appreaciate

acafasso@wellingtonenergy.net · Answer

Thanks for your very detailed reply.  I also received a reply direct from Odoo support and this is what they told me, which i tried before doing what you said and i am now able to load Purchase Orders for Location #2.

Will you please
confirm the behavior now as I have increment number to next sequence. The
system tries to create Incoming shipment with number 025/IN/00017 but since
it's already existed in the system it's not possible to use the same sequence
number. The shipment should be genera

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!