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,827 Moderator on at

Like (0)

Report

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

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

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,827 Moderator on at

Like (0)

Report
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

I only get the one specific number sequence like ChemTest

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

Like (0)

Report

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

i got this error

Was this reply helpful? Yes No
Coders 20 on at

Like (0)

Report

the is the name of the number sequence i created

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

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,827 Moderator on at

Like (0)

Report

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