Number Series

vijayanderson

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

garak

.... SQL Server Sorting.
Check property "SQL Data Type" on your field in table.

Variable type in Navision will be mapped to SQL Server data type as follows:

Integet --> Integer
Option --> Integer
Code --> Varchar / Integer / Variant
Text --> Varchar
Decimal --> Decimal (38,20)
Date/Time/DateTime --> DateTime
Boolean --> TinyInt
Binary --> Varbinary
BLOB --> Image
DateFormula --> Varchar
TableFilter --> Varbinary
BigInteger --> Bigint
Duration --> BigInt
GUID --> UniqueIdentifier
RecordID --> Varbinary

garak

But note, if you change this property on a field, all other fields with table relations to this field must also be changed, and this is a high cost, don't forgett common updates / upgrades, ServicePacks, hotfixes, etc. ....

Also, if you change the property to "Integer", then you can't use alphanumeric Signs. This is not so good, also better -> variant.

But :-( "Integer" / "Variant" can't handle leading Zeros. so the following recs exists, 1, 01, 00001 so you have, after changing the property 3 recs with the same Primary key. And this is :-(

So VarChar for code is not realy a problem, because it's alphanumeric sotring.

You can also change you numberseries to:
Start: S-000000001
End: S-999999999

Warning:
S-999999800

Regards

kine

As you can see, you have the troubles because wrong series setup. Main rule is to have the series set up to generate numbers beginning with character, followed by enough numbers to cover all possible documents. It means your number was too short, now you have the sorting order problem. Setup the series to have enough space for all documents. Good is to use e.g. two digits from the year to differ the series for each year. Than you have numbers like

S08-000001..S08-999999
S09-000001..S09-999999
S10-000001..S10-999999
S11-000001..S11-999999

and you have enough space to generate the documents. And you know how much documents per year you need and thus how long the number must be...