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

Această întrebare a fost marcată

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