Number Sequence issue after modifying the format- AX 2009

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

Hi,

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

Pranav…

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,

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

Regards

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

Pranav…

Any other comments/clue/suggestions???

Regards

Restart the AOS.

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