Identifying the Sequence from Number Sequence Group id

(0) Share

Report

Posted on by Community Member

I am experimenting with the Number Sequence framework, and I have created a form to select a Number Sequence Group from those available in the NUMBERSEQUENCEGROUP table. When I select a group, then I have its group-id in a string variable.

How can I use the group-id (string) using X++ code to identify the corresponding sequence for a given area and reference? I need to use the sequence in order to get numbers using the NumberSeq::newGetNum() method.

I am not familiar with the concepts and I also wonder what the area and reference parameters practically are; is there a table to look for their available values and how can I use them in this context?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

greengrimms 1,400 on at

Like (0)

Report

Hi Yiannis,

Reference parameter is basically where you configured the number sequence. So for example, in Accounts receivable parameters, you have a section that references the number sequences configurations for AR. That would be where you'd get the Reference parameter.

The NumberSeqReference::findReference() might also aid you in this.

The area field is coming from NumberSequenceGroupRef table, which you'll use in order to get the desired NumberSequence:

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Danilo; your feedback is very useful to understand better these tables relationships and the Reference part.

Regarding the area field, I am interesting in particular for the Accounts payable area.

Which NumberSequenceGroupRef table field describes the area? I can see only the following fields there: [NUMBERSEQUENCEDATATYPE],[NUMBERSEQUENCEGROUPID],[NUMBERSEQUENCEID],[NUMBERSEQUENCESCOPE],[RECVERSION],[PARTITION],[RECID].

Was this reply helpful? Yes No