Number Series

Reply

rv_vijayan Posted: 08-19-2008 9:07

rated by 0 users

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

Reply

Andrew Cooper replied on 08-19-2008 9:21

rated by 0 users

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

Reply

Mohammad Sallout replied on 08-19-2008 13:33

 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.

Reply

Savatage replied on 08-19-2008 21:36

rated by 0 users

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....

In Chart of Accounts the G/L accounts was sorted like 1, 11, 111, 1111 etc. Hmm .. this problem was solved by changing the SQL
Data Type property for Table 15 "G/L Account":Field 1 "No." and Table 17 "G/L entry":Field 3 "G/L Account No" to Integer.

Have you tried to use Variant instead of Integer?