Number Sequence issue after modifying the format- AX 2009

(0) Share

Report

Posted on by Community Member

I used the SO number sequnce 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

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

M.Aamer on at

Like (0)

Report

Hi Ishak,

Inquiry from the table (SalesTable) how the Sales Order ID displayed in the table, then check Sales Order ID filed size, you can check number sequance status form on the Number Sequance form list button, may be there are some numbers are some numbers are undecided and need to be cleared.

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Amer, thanks for your reply...

In SalesTable also it showing up to SO-9999 (SOs having the previous number sequence format, SO-#### )

But if I search for a newly created SO (SOs having the new number sequence, SO-##### format) it will display.

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

All the sales related table (like SalesTable, SalesLine,CustConfirmJour etc) is showing the same data, only up to SO-9999

Was this reply helpful? Yes No
Verified answer

Soumitra Rakshit 60 on at

Like (0)

Report

It is in ascending order of 1 -- 9 .. Check in the middle in the Sales Order Form where order with number sequence 1 .. is there .. you will find it

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, it is there....

:)

Thanks Soumitra for your reply....

Regards

Was this reply helpful? Yes No
M.Aamer on at

Like (0)

Report

Nice catch Soumitra, I was going to suggest export the sales header to Excel, then tackl it from there.

Have a good day with Dynamics AX :-)

Glade you find it Ishak.

Was this reply helpful? Yes No