Invoice Numbers - how to keep them sequential?
Our invoice numbers are jumping around and I have to create a fake invoice with a proper invoice number and save it then delete it to get the "auto" invoice number back on track.
We get off-track because members of our team change an invoice number intentionally or accidentally and then the new sequence restarts from that number. Is there a way to allow over-rides for individual invoices or estimates, for example, but resumes the next number in the primary sequence with the invoice that follows?
For example if our invoice numbers are sequentially 567, 568, 569 but one of our team members saves an invoice as 570s because they want to label that one differently, then the next invoice number is 571s, 572s, etc. until we save a dummy invoice as 573, then delete it and the following invoice will auto-populate as 574. So, we skipped one but we are back on track with auto-sequential invoice numbers.
Is it possible to set the program so that if someone saves a random invoice number that is different, like 570s, that the next auto-generated invoice number would be 570 (what would have been expected after 569)?
Thank you!

