Reset invoice number

💬 General Discussion
1

Hello,

starting the new year I need to reset the invoice number and start again with the number 1

Any idea?

thanks.

2

Hi there,

That Invoice number is unique, and from the system’s perspective should not be ‘reset’. In the system it will always check the last invoice number from the database and add a 1 to it.

What I could suggest is that you create a new Ref/Invoice Number that you can then create your own logic to it i.e. have the NUMBER-YEAR which you can calculate the latest number from a particular year. This would mean that invoices will be easily searchable (since the invoice number will be unique) and still be able to show you its order of the year i.e. 8-2016

3

Hey AshleyNic,

thanks for your answer, finally I’ve created a dummy invoice and from the database I’ve changed the invoice number to a new one (16000 - year plus three 0)

after deleting the dummy invoice the first one of the year was 16001 so I think we can start working :slight_smile:

4

Glad you found a solution :slight_smile:

5

Hello,

thanks for this hint. It actually worked the same for cases: Duplicating the last entry in the database and manualy renumbering made the next case number to show up exactly as expected. Thank you.

Regards