Hello, I am trying to reset the invoice numbers without reinstalling the system. I have looked at the database, but I can`t figure out how to do it. I have set up the settings to auto-increment (MySQL), starting the invoice from 1, 2, etc. The problem is that when I begin to create invoices for testing, it will auto-increment. In real business, this needs to be reset to 1, as I may have 5 invoices for testing that are deleted, leading to the invoice itself showing number 6 in real business.

Can you please guide me on how to do this? Regards