Accessing Number Sequences from x++

(0) Share

Report

Posted on by smore

I have seen multiple examples like:

SalesParameters::numRefSalesId()
CustParameters::numRefCustAccount()
HrmParameters::numRefJournalNum()

But how can I convert a name in the UI into x++ ?

What is the Parameter for <Tes_100 ?

What is the Parameter for <Tes_105 ?

I have the same question (0)

All responses (16)

Answers (2)

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Smore,

Do you want to understand how number sequence <Tes_100 or <Tes_105 used in the system?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

It depends on how you set up your parameters. If you have set up SalesParameters in a way that <Tes_105 is used as Sales order number, then SalesParameters::numRefSalesId() would return that sequence.

If you haven't used this sequence in any parameters, you of course can't get it via any parameter.

So, in Number sequences form you define the number sequences. In the parameters forms you define what number sequence is used for specific purpose, such as Sales order number.

Is it now clear?

Was this reply helpful? Yes No
smore 90 on at

Like (0)

Report

Not 100%.

Here is the Sales parameters UI:

I don't see numRefSalesId in the UI....

How do I match up the Reference in the UI "Relation journal ID" into an x++ numRefXXXX ?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

You are looking at Sales and Marketing parameters but actually SalesParameters table is Accounts Receivable parameters in the UI.

Was this reply helpful? Yes No
smore 90 on at

Like (0)

Report

How is one supposed to know that ?

I am really trying to figure out the "Project budget ID". By learning how all these things connect I was hoping the find the correct answer myself.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

And how to match these things, look at NumberSeqModule* classes. In LoadModule you see the extended data types that are used in parameters of each module.

docs.microsoft.com/.../number-sequence-framework

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

"How is one supposed to know that ?"

Look at label of SalesParameters table.

Anyway many things in D365FO are not easy to figure out when you do it for the first time. Having a mentor, and being good at web searches are important.

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi Smore,

Usually, all number sequences are linked to certain EDT. If you want to find number sequence and related method (if it exists) you need

1. Identify EDT (in case of "Project budget ID" it's ProjBudgetId)

2. Find EDT in AOT

3. Find EDT references and look for numRef* method and NumberSeqModule classes (it will help you identify function module where number sequence is used).

Was this reply helpful? Yes No
smore 90 on at

Like (0)

Report

When using the editor, it looks like my choice is valid:

But when I compile, I get the following error:

If ProjParameters does not have that field, then why is the IDE showing that as a valid option ?

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi Smore,

You probably forgot to add brackets ( ProjParameters::numRefProjBudgetId() )

Was this reply helpful? Yes No