Unable to get next number in the sequence

(0) Share

Report

Posted on by Sureshnatababu

905

Hi All

I am trying to manually create the UserRequest object from the X++ code. However, I am unable to get the next sequence number for the "RequestId" field. I checked the Human resource setup parameters and found that it is using "Basi_3" sequence. Please find the below code and let me know why it is not working.

NumberSequenceTable numt;
NumberSequenceReference numR;

select numt
where numt.NumberSequence=='Basi_3';

select numR
where numR.NumberSequenceId==numt.RecId;

ttsbegin;
num = NumberSeq::newGetNum(numR);
info(num.num());
ttscommit;

Regards

Suresh

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

What's your version of AX? You have to deal with things like scopes in AX 2012.

And what exactly happens? Do you get any error? Are all records found? What happens inside newGetNum()? We can't do the debugging for you...

Was this reply helpful? Yes No
Sureshnatababu 905 on at

Like (0)

Report

Sorry for not putting this clearly..I am working in AX 2012 and the number sequence is in the shared scope. The newGetNum() is returning the sequence number starting from zero again , But if I look into the UserRequest form where this sequence is used, the sequence number has gone way ahead.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

try following code

NumberSequenceTable numt;

NumberSequenceReference numR;

NumberSeq num

select numt

where numt.NumberSequence=='Basi_3';

select numR

where numR.NumberSequenceId==numt.RecId;

num = NumberSeq::newGetNum(numR);

num.parmMakeDecisionLater(true);

info(num.num());

you need to add additional line of code

num.parmMakeDecisionLater(true);

please verify and let me know if this helps you.

Was this reply helpful? Yes No
Sureshnatababu 905 on at

Like (0)

Report

Nitesh,

Thanks for your reply. It doesn't work either. If I go and look into this sequence in the AX thick client, I find the next sequence value as 18 but if I run the code I am getting the value as 4. Is there any other way to get the next sequence number from a shared scope?

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

Like (0)

Report

You can simplify your code by using NumberSeq::newGetNumFromCode(). Pass the number sequence code and the scope into it. Verify the next number in the debugger - that guarantees that you're checking the same number sequence. Don't care too much about what's already in the table; it doesn't necessarily have to correspond to the number sequence.

Was this reply helpful? Yes No
Sureshnatababu 905 on at

Like (0)

Report

Thanks. What I finally found is that it is something to do with my current environment. I tried the same code in another environment and it worked. Thanks for all your help.

Was this reply helpful? Yes No

Community site session details

Unable to get next number in the sequence

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Unable to get next number in the sequence

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates