Number Series

vijayanderson
vijayanderson Member Posts: 207
edited 2008-08-19 in Navision Financials
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

Comments

  • garak
    garak Member Posts: 3,263
    .... 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
    Do you make it right, it works too!
  • garak
    garak Member Posts: 3,263
    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
    Do you make it right, it works too!
  • kine
    kine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories