Your solution did not help at all.
We have tried entering the next number in the sequence but the invoice numbers keep duplicating.
On top of that, we are now getting duplication of invoice numbers from invoices created weeks ago. EG we are up to 6932 but each time we create and invoice the system creates it as 6910. We have also had invoices create backwards, we have had 2 today create as 6909.
We have also noticed that when we change address details for a customer in the Contacts section, it won't update the invoice like the previous system did. We have had to delete invoices and go and recreate the invoice with the same number so that the correct address displays. Wasting our time.
This is ridiculous. When is the issue going to be fixed.