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
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
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
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden