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:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
1
回复
667
查看
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
