Deleted invoice accidently now keeps skipping that number

[matt4]

Is there a way to stop the system from skipping a invoice number?

 

I deleted invoice number 15 and now it's opening on number 16. This isn't good and will send my accountant crazy. Please can someone assist?

 

Sorry its vague been trying for ages.

 

Thanks,

[ckh]

It looks like the invoice numbers are automatically incremented in mysql, so you should be able to use the ALTER TABLE command to change the auto increment value you wish in phpMyAdmin.

 

Something like:

 

ALTER TABLE tblinvoices AUTO_INCREMENT = 15

[WHMCS John]

I'd advise against re-creating an invoice with the same number as a previously deleted invoice.