The way ClinicOffice works with invoice numbering, is that it simply takes the previous HIGHEST invoice number and then adds +1 to it. Please can you check : what is the largest invoice number in your database and what number is ClinicOffice generating for a new invoice?
If you still can’t get this to work, please send us your database (click here for details) and we’ll have a look for you.