Create ascendent number string

Need help Database
1

Hei quick question

I m creating tax invoicing and I have to specify internally each invoice the number of the invoice during the year.

Now my question is: how do I write automatically the number of the invoice in a automatic ascendant way?

Invoice number: 1
Invoice number: 2
Invoice number: 3
and so on… I ve only seen the “create random string” funtionality…

2

Hoo boy. Start here: How to achieve Unique, Sequential Numbers Reliably? - #57 by morgan… and READ THIS ENTIRE THREAD.

3

Pro-tip: There is no reason for you to do this.

4

Until you have a law requiring progressive consecutive numbers :laughing:

1 Like
5

Hei @keith thanks for the answer
What do you mean there is no need to do this?

6

Hei @dorilama
you are right they do not have to be consecutive. But has to be progressive within the year.
So was thinking that was easy to do but it seems it s not.

How would you approach then with progressive numbers then ?

7

The post Keith suggested goes deep into this matter.
As for invoices, if you don’t need consecutive numbers and the frequency at which you create them allows you, a common workaround is using the current date up to the resolution you require.
For example: daily invoices 20230301, 20230305, 20230315 ecc.