change invoice numbering

didotadv

I wish I could change the numbering of the invoices
example: I made test invoices and I would like to reset and start from number one
but I can't find the setting how can I do
thank you all

akaffoueric

Hi @didotadv ,

You can't, because it is illegal in all countries to delete, renumber invoices. Your only option is phpmyadmin. You remove the invoice and update autoincrement value. If you have made the invoice paid, you need other changes in transactions table etc. A more simpler way is to backup oc_options and all delete all other tables and use a fresh copy located in install/assets/

I have 2 hours driving, let me know if you need my help to reset all.
Thanks
Eric

didotadv

yes reset i messed up

SurinP3

When migrating to your system, the invoice numbers has to be changed to follow the previous system.
How can I do that?

akaffoueric

Hi,
You can do it with phpmyadmin. Click on oc_invoices, then operation tab and set auto increment to the current invoice number.
Example : 455. The next invoice number will be 456.
Thanks

SurinP3

Great... Thanks