Number Sequence Not Updating To Next Value

(0) Share

Report

Posted on by Community Member

Hi all,

I am using this code in order to get the next value of the number sequence associated with the smmActivityNumber:

ns = NumberSeq::newGetNum(smmParameters::numRefActivityNumber());
ns.used();
smmActivityNumber = ns.num();

This code is located inside a loop, so for every loop it should get the next number in the sequence. Unfortunately, this is not the case and it is always getting the first number in the sequence (ABC-00000).

As far as I know, the smmActivityNumber EDT comes out-of-the-box with Microsoft Dynamics AX 2012. I loaded the modules through a job by using the class NumberSeqModuleGeneral and then went to Organization Administration --> Generate.

However, the problem still persists. How can I solve this please? Thanks

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Calling used() before allocating any number (num()) looks suspicious. Wouldn't swapping the calls make any difference?

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

call it as under

NumberSeq::newGetNum(CompanyInfo::numRefActivityNumber()).num();

also remember its part of Basic while you navigate in Organizational administration >> Number sequences.

This number sequence is being used at many places almost in all sort of activities wheher belonging to sales, projects or others

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Martin and Sohaib,

I ommitted one important detail. This happens only in my local environment. On the DEV environment, it works perfectly. So I think it is more related to setup rather than code.

Thanks

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

how you have done setup of number sequence in both systems? is that same w.r.t continuous checked or manual Unchecked?? have you seen this number sequence in Organization Administration for both environments?

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

So what's the setup?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

To tell you the truth, the number sequences in both systems were not set up by me. By any chance, do you know from where the smmActivityNumber number sequence can be set up please? Thanks.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 303,674 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Anthony,

The activity numbers can be setup on the Legal entity form per legal entity. (Organization administration > Setup > Organization > Legal entities.

Check if the number sequence is set to continuous or not. If it is continuous in both environments, it is probably not due to the coding. Then check if the SQL database has all the needed stored procedures to be able to retrieve numbers.

Check my blog for details on this stored procedure and how to create it when needed: kaya-consulting.com/solve-continuous-number-sequence-issue-in-ax-2012-r2

PS when using the newGetNum() method without an optional additional parameter to make a decision later '_makeDecisionLater', the used() method is not needed.

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

you can also run following job before running Wizard to setup sequence

static void LoadNumSeqGenModule(Args _args)

{

NumberSeqModuleGeneral objNumberSeqModuleGeneral = new NumberSeqModuleGeneral();

objNumberSeqModuleGeneral.load();

info("Done");

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your feedback Andre. I will try it out and let you know if it worked. Thanks again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sohaib,

I carried out this step to no avail. I will try out Andre's suggestion and see if it works. Thanks a lot.

Was this reply helpful? Yes No