Sale/Purchase/Invoice/Picking: Constraint Error-Order Reference must be unique per company
Bug #800100 reported by
Meera Trambadia (OpenERP)
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Addons (MOVED TO GITHUB) |
Fix Released
|
Low
|
OpenERP R&D Addons Team 3 | ||
6.0 |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
1.Create a new db and install the multi-company module.
2.Change the user company to Shop1.
3.Create a Sale order and Save the record.
It gives the following error:-
IntegrityError: duplicate key value violates unique constraint "sale_order_
Related branches
lp:~openerp-dev/openobject-addons/trunk-bug-800100-mdi
- DJ Patel (OpenERP) (community): Needs Resubmitting
- Mustufa Rangwala (Open ERP) (community): Needs Fixing
- Purnendu Singh (OpenERP) (community): Approve
- Raphael Collet (OpenERP) (community): Needs Fixing
- qdp (OpenERP): Pending requested
-
Diff: 103 lines (+15/-6)5 files modifiedaccount/account_invoice.py (+3/-0)
mrp/mrp.py (+4/-1)
purchase/purchase.py (+1/-1)
sale/sale.py (+1/-1)
stock/stock.py (+6/-3)
summary: |
- Sale: Constraint Error-Order Reference must be unique + Sale: Constraint Error-Order Reference must be unique per company |
Changed in openobject-addons: | |
status: | Confirmed → In Progress |
summary: |
- Sale: Constraint Error-Order Reference must be unique per company + Sale/Purchase/Invoice/Picking: Constraint Error-Order Reference must be + unique per company |
Changed in openobject-addons: | |
milestone: | none → 6.1 |
To post a comment you must log in.
Hello Meera,
As per I think sale order name field is a sequence field and not a read only field So end user can change.
Now if we trying to create two SO with different company then we can add the related unique prefix (eg: company name /code -sequence).
So the constraint will not block the end user for inserting two different company SO with the same name.
So currently I am setting this issue as an "Opinion" status for more discussion.
Thanks.