Number Sequence issue after modifying the format- AX 2009

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Verified) This post has 1 verified solution | 7 Replies | 3 Followers

Male
153 Posts
1,490 Points
Joined: 2011-5-5
Last Online:
2013-6-19 10:20
Location: Riyadh-Saudi Arabia
Ishak Kallil posted on 2012-10-20 14:18

I used the number sequnce for Sales Order with the format of SO-#### (4 digit,Smallest 1 and Highest 9999) and when it reached at maximum(9999) I changed the format as SO-##### (5 Digit, highest 99999). But in SO form it is showing Sales Orders upto SO-9999, not newly created after changing the number sequence. But if I search manually/individually (eg SO-10075 ) it will display.

How can I solve this issue?

Regards

 

Ishak Kallil

Solution (Verified) Verified Solution

Male
153 Posts
1,490 Points
Joined: 2011-5-5
Last Online:
2013-6-19 10:20
Location: Riyadh-Saudi Arabia
Solution (Verified) Ishak Kallil replied on 2012-10-22 10:14
Verified by Ishak Kallil

No need to restart, it is there....

I got it, It is in ascending order of 1 -- 9 ,middle in the Sales Order Form where order with number sequence 1 .. is there.

ie. SO-0001

      .

      .

     SO-0999

     SO-1000

     SO-10001

     SO-10002

      .

      .

      .

      .

     SO-2000  

       .

       .

       .

     SO-9999

 

 

Regards

  

 

Ishak Kallil

All Replies

Male
1,059 Posts
18,155 Points
Joined: 2011-9-5
Last Online:
2013-6-18 17:51
Location: India
Pranav Kumar replied on 2012-10-20 14:33

Hi,

Try to synchronize database. Also, did you updated next number in number series when it was updated?

Pranav... 

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

Male
153 Posts
1,490 Points
Joined: 2011-5-5
Last Online:
2013-6-19 10:20
Location: Riyadh-Saudi Arabia
Ishak Kallil replied on 2012-10-20 14:48

Hi Pranav, thanks for your reply

The next number was showing 10,000 when it reached 9999, so I didnt change anything.After modified number sequence I synchronized the DB but no effects. AOT table browser also showing same, only upto SO-9999.

 

Regards,

 

Ishak Kallil

Male
153 Posts
1,490 Points
Joined: 2011-5-5
Last Online:
2013-6-19 10:20
Location: Riyadh-Saudi Arabia
Ishak Kallil replied on 2012-10-20 14:56

If we search SO individually we can see all the enterd Sales Orders from form as well as AOT table browser.

 

Regards

 

Ishak Kallil

Male
1,059 Posts
18,155 Points
Joined: 2011-9-5
Last Online:
2013-6-18 17:51
Location: India
Pranav Kumar replied on 2012-10-20 15:38

Technical person can help you on this? Have you shown this issue to a developer?

Pranav...

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

Male
153 Posts
1,490 Points
Joined: 2011-5-5
Last Online:
2013-6-19 10:20
Location: Riyadh-Saudi Arabia
Ishak Kallil replied on 2012-10-21 10:02

Any other comments/clue/suggestions???

 

Regards

 

Ishak Kallil

29 Posts
250 Points
Joined: 2011-7-19
Last Online:
2013-3-6 5:05
Ayoub replied on 2012-10-22 8:01

Restart the AOS.

Male
153 Posts
1,490 Points
Joined: 2011-5-5
Last Online:
2013-6-19 10:20
Location: Riyadh-Saudi Arabia
Solution (Verified) Ishak Kallil replied on 2012-10-22 10:14
Verified by Ishak Kallil

No need to restart, it is there....

I got it, It is in ascending order of 1 -- 9 ,middle in the Sales Order Form where order with number sequence 1 .. is there.

ie. SO-0001

      .

      .

     SO-0999

     SO-1000

     SO-10001

     SO-10002

      .

      .

      .

      .

     SO-2000  

       .

       .

       .

     SO-9999

 

 

Regards

  

 

Ishak Kallil

Page 1 of 1 (8 items) | Get this RSS feed | Bookmark and Share