Number Series

Business Central/NAV User Forum
1

Hi friends

I have a problem in number series, In number series setup, the Number given in for posted Shipment S-001,and the shipment crossed S-999, the number series is properly generating but in list view S-1000 is shown below S-100 and not below S-999. Can someone suggest some solution for it.

Thanks

2

This is an issue with SQL, it does not see it as a number. The only way to avoid this is to have all numbers have the same number of characters. I don’t know of any way to avoid this after the event.

Andrew

3

Hey,

Actually I work with Ax,

I think they are the same, but I’m not sure.

you have two problem:

1- the Sequence is small and it could be finished up.

2- they are sorted in strange way.

OK, here we go

1- the Sequence is small and it could be finished up.

Don’t worry this in not big problem.

You just have to increase the range from the Basic–> Setup → number sequence.

Increase the range and make sure the format S-##### is increase too.

Thats it.

Note: I don’t think you will face this case, but just for your knowledge, if you increase it and generate one record, you can’t decrease it back, because there is some record already.

so you have to delete that record and decrease the number.

2- they are sorted in strange way.

Since it is character, the system will compare the number character by character from left to right .

and you have nothing you can do about it.

e.g.

if we have those numbers

123, 1452, 587, 669, 44, 87, 177, 866, 544

they will be sorted like this

123, 1452, 177, 44, 544, 587, 669, 866, 87

I hope I clerify thing for you.

4

Not sure I understand, personally I make my number series much bigger than 100 to 999 to eliminate worries.

Example/
Start:S000000001 End:S999999999

Oh After re-reading I understand now - you have a sorting problem your view appears as below correct.

1
10
100
2
20
200
etc…