Get the existing Number Sequence on the Table

(0) Share

Report

Posted on by Coders

HI, I had a problem on getting the existing or created number sequence in Dynamic 365. How to code it on X++??

I have the same question (1)

All responses (17)

Answers (1)

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Your question is not clear. Can you elaborate more?

Are you asking how to create number sequence from scratch?

Thanks,

Girish S.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, As Girish mentioned, your query is not clear. Please provide more information on what you are trying to do (Preferrably with your code/screenshots)

Was this reply helpful? Yes No
Coders 20 on at

Like (0)

Report
Copy link

Link copied!

In the functional side, i created a number sequence in general ledger, after i created that i will used that on product creation. now, i want to get that number sequence using the X++ code. and put it on a variable.

Was this reply helpful? Yes No
Verified answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!
You can use NumberSeq class to get the number.

You must know the EDT name related to number sequence.

NumberSeq numSeq; ttsBegin; numSeq = NumberSeq::newGetNum(NumberSeqReference::findReference(extendedTypeNum(YourEdtName))); tableName.fieldName = numSeq.num(); ttsCommit;

Thanks,

Girish S.

Was this reply helpful? Yes No
Coders 20 on at

Like (0)

Report
Copy link

Link copied!

I only get the one specific number sequence like ChemTest

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

I can't understand. What do you mean by "ChemTest"?

Can you elaborate.

Thanks,

Girish S.

Was this reply helpful? Yes No
Coders 20 on at

Like (0)

Report
Copy link

Link copied!

i got this error

Was this reply helpful? Yes No
Coders 20 on at

Like (0)

Report
Copy link

Link copied!

the is the name of the number sequence i created

Was this reply helpful? Yes No
Suggested answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think you missed some steps while creating custom number sequence.

You need to load the number seqeunce class using runnable class.

After that you need to go to Organization administration >> Number Sequence >> Number Sequence >> Generate (Button on the action pane).

Refer to the below blog.

https://community.dynamics.com/365/financeandoperations/b/nevoitechfinance/posts/custom-number-sequence-in-d365fo

Thanks,

Girish S.

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Also, from the screenshot I can see that you are referring to "NumberSequenceCode" EDT which is a standard one.

Are you creating number sequence for that EDT?

Thanks,

Girish S.

Was this reply helpful? Yes No