I am getting a validation error "Reference must be unique per company" when i try to complete a sale
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
637
Views
Hi,
The error occurs when the reference('name' field) is set to a value already existing in the same company. To resolve this, activate Developer Mode in Odoo and navigate to Settings > Technical > Sequences & Identifiers > Sequences. Identify the sequence related to the operation causing the conflict (e.g., delivery orders or invoices). Edit the sequence, and set the Next Number to a value higher than the last used number. You can determine the last used number by searching the corresponding records in 'Inventory > Operations > Transfers > Deliveries' or 'Accounting > Customers > Invoices'. For example, if the last used delivery order reference is "WH/OUT/0005," set the Next Number in the sequence to 6. Save the changes and try confirming the sale order again.
Hope it helps
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up