Invoice renumbering


I made a mistake with 2 invoices and i had to delete them (let’s say invoices 10 and 11).
Now i want to continue invoicing again from number 10.
But when i create a new invoice now it starts from number 12.
I know i can change it by hand, but i wan’t it to be automatic, since i might forget to change it sometime.
Is it possible to make some change in the database (probably some auto-numbering value) to make it start from number 10 again ?

Thank you !!

Here are the steps:

  • Restore the deleted invoices
  • Change the invoice numbers to a value you won’t use
  • Delete the invoices
  • Change the counter on /settings/invoice_settings to 10

This was so helpful !!!
Thank you so much.