How to generate noSeries with A,B,C....,a,b,c...

justeryu
justeryu Member Posts: 13
edited 2010-08-07 in NAV/Navision Classic Client
hello guys ,

How to generate noSeries with A,B,C....Z,a,b,c...,z

ex:
SO No.
_______________
SO123A
SO123B
SO123C
.....
SO123Z
SO123a
SO123b
.....
SO123z

Appreciate anyone who can help me!

JY

Answers

  • thankesh
    thankesh Member Posts: 170
    justeryu wrote:

    How to generate noSeries with A,B,C....Z,a,b,c...,z

    ex:
    SO No.
    _______________
    SO123A
    SO123B
    SO123C
    .....
    SO123Z
    SO123a
    SO123b
    .....
    SO123z

    Hi Justeryu,


    May I know why do you need this kind of no. series? In NAV, we can do increment only by integer. So, I do not have any idea about incrementing via char (alphabets). And increment should be done by using integers alone.

    What would you do if all the 26 chars (alphabets) i.e) SO123z has been finished? How would you do the next level of increment after SO123z? [-X
    With warm regards,

    Thankesh

    ***Learn to lead***
  • justeryu
    justeryu Member Posts: 13
    thankesh wrote:
    justeryu wrote:

    How to generate noSeries with A,B,C....Z,a,b,c...,z

    ex:
    SO No.
    _______________
    SO123A
    SO123B
    SO123C
    .....
    SO123Z
    SO123a
    SO123b
    .....
    SO123z

    Hi Justeryu,


    May I know why do you need this kind of no. series? In NAV, we can do increment only by integer. So, I do not have any idea about incrementing via char (alphabets). And increment should be done by using integers alone.

    What would you do if all the 26 chars (alphabets) i.e) SO123z has been finished? How would you do the next level of increment after SO123z? [-X

    Well, it will be back to whatever+A again!
    all i need is a group with 52 items starting from whatever+A to whatever+z.
    Thanks,thankesh.

    JY
  • ufuk
    ufuk Member Posts: 514
    Increment is done only in numeric part. Possible solutions are using relationships (not seem feasible in your case) or modification in code. (really worth it?)

    Meanwhile I didn't understand exactly what you really want by saying grouping items? If you want to group a total of 52 Item use a structure starting with A01 then ends with A56, B01..B56 etc...
    Ufuk Asci
    Pargesoft
  • Savatage
    Savatage Member Posts: 7,142
    perhaps you can play this this:
    viewtopic.php?f=5&t=14078

    you'll have to add something like

    noseries := noseries+t;

    test & good luck
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • justeryu
    justeryu Member Posts: 13
    Savatage wrote:
    perhaps you can play this this:
    viewtopic.php?f=5&t=14078

    you'll have to add something like

    noseries := noseries+t;

    test & good luck

    Hi,Savatage

    It solved my question!

    Thank you so much.

    JY

Categories