Resolving "Constraint Error: Invoice Number must be unique per Company!" on Validating a Purchase Invoice?

Question

Constraint Error

Invoice Number must be unique per Company!

From what I can see, the invoice number is unique.

Chris TRINGHAM · Accepted Answer

In version 11 go to *Accounting->Configuration->Accounting->Journals* and select the document type.  Then under the "Journal Entries" tab you should be able to increase the "Next number" so it's not a duplicate.

Malia · Answer

Hello Friends,
For example, when you validate invoice and this error occurs then follow this step.
First, you have to click debug mode then Go to Accounting -> Journal (customer invoice journal) -> Next number (INV sequence). Click it. you will see sequence that is your sequence size and from to date with next number   table. So, look that table, there is from when to when date limit and limited sequence numbers. You have to change there for your error.
Thank you

Patrick Kyei · Answer

You can use OCA Renumbering module. After installation just run it. An dthe problem is solved.

Dhaval Ashiyani (dhh) · Answer

Check Vendor Bills -> Other Info -> Journal -> Entry sequence.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
"Validate" button missing on invoices for users with Only Own Documents rights invoice validate	4 huhtik. 25	1198
Access error You do not have the access rights to post an invoice. invoice error	0 maalisk. 24	1716
purchase invoice creation error ODOO CE 14 purchase invoice	1 heinäk. 21	2876
Cannot create an invoice after Stripe paiement : "record does not exist..." invoice error	0 lokak. 17	4334
Odoo 8: Validating invoice with different quantity and/or unit price from the purchase order; is this a case for blanket order? purchase invoice validate invoicing purchase_order	2 lokak. 16	5930

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!