BeyondERP.Newsletter
Menu

Setup step on the Number sequences page · Organization administration

Set up Number sequences

Use this page to set up each number sequence's scope, format, reference and number range, one at a time or all at once with the Generate wizard.

Business process
Administer system features
Menu item
NumberSequenceTableListPage
Data entity
NumberSequenceTableEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page where you create and maintain number sequences, which give readable, unique identifiers to master data and transaction records.
What you do hereUse this page to set up each number sequence's scope, format, reference and number range, one at a time or all at once with the Generate wizard.
ExampleFor example, a sales order sequence for company CEU with the constant SO- and four number signs gives numbers like SO-0029.
Number sequences page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Number sequences1 screen

Use this page to set up each number sequence's scope, format, reference and number range, one at a time or all at once with the Generate wizard.

  1. Screen 1

    Check a number sequence

    Go to Organization administration > Number sequences > Number sequences

    1. Find the number sequence code in the list
    2. Read its smallest, largest and next number and its format
    1Number sequence codeAcco_128
    Smallest1
    Largest999999
    Next11
    FormatBEAT-######
    Check a number sequence (zoomed on the outlined fields)
    Show the full screenCheck a number sequence
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Organization administration > Number sequences > Number sequences.
  2. Select Number sequence to create a new one.
  3. In the Number sequence code field, enter a code.
  4. In the Name field, enter a name.
  5. On the Scope parameters FastTab, select the scope and the scope values.
  6. On the Segments FastTab, add and arrange segments to build the format.
  7. On the References FastTab, select the record or document the sequence is for.
  8. On the General FastTab, choose the Manual and Continuous settings and enter the smallest and largest numbers.
  9. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
ScopeDecides which organizations use the sequence: shared, per company, per legal entity or per operating unit.Microsoft Learn
ConstantA segment with fixed letters, numbers or symbols, such as a prefix or separator.Microsoft Learn
AlphanumericA segment that counts up each time a number is used; # stands for digits and & for letters.Microsoft Learn
ReferencesThe record or document type the sequence gives numbers to.Microsoft Learn
ManualWhen set to No, the system creates the numbers itself.Microsoft Learn
SmallestThe lowest number the sequence can use.Microsoft Learn 1Lowest
LargestThe highest number the sequence can use.Microsoft Learn 999999Highest
NextThe next number the sequence will use.Microsoft Learn 11NextRec
ContinuousA continuous sequence never skips numbers, but numbers might not be used in order.Microsoft Learn
PreallocationOn the Performance FastTab, reserves a set quantity of numbers in advance to speed up number use.Microsoft Learn
Number sequence codeThe unique code that identifies the number sequence.Microsoft Learn Acco_128NumberSequence
FormatShows an example of the number format built from the segments.Microsoft Learn BEAT-######

Test checklist

  1. Open a sequence with Company scope (for example Sales order) and note the Next value and Format.
  2. Create a sales order in that company and check the order number matches the format and the Next value.
  3. Switch to another company that uses the same format and create an order: numbering restarts for that company.
  4. For a Shared sequence (for example Purchase requisition), create a record in two companies and check both draw from the one series.
  5. For a continuous sequence, cancel a new record before saving and check the number is reused later rather than skipped.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Number sequencesNon-continuous with Preallocation for every reference, unless a legal or regulatory rule requires a gap-free series (then Continuous for that reference only)Microsoft recommends non-continuous sequences unless there is a regulatory or legal compliance requirement for continuous ones. Preallocation on the Performance FastTab keeps numbers in memory so the system calls the database less often.Should this number sequence be continuous or non-continuous?Making every sequence Continuous 'to be safe'. Continuous sequences cost performance, can reuse cancelled numbers out of order, and need a cleanup job to recover lost numbers.Test: Non-continuous sequence with preallocation issues ordered numbers

Feature management and licence

Feature to turn onEnable continuous number sequence performance improvements (Optional)

Microsoft Learn

Solution architect

5Design impact

Can it be undoneHard to reverse: Scope and format are set per sequence. Numbers already issued stay on posted records, so a later change of scope or format only affects new numbers and leaves mixed numbering in history.
If you change it laterDon't change a non-continuous sequence to continuous later: it won't be truly continuous, can cause duplicate key errors, and continuous sequences are slower. Microsoft Learn
Technical architect

6Technical

Menu itemNumberSequenceTableListPage Checked in Dynamics 365
FormNumberSequenceTableListPage Checked in Dynamics 365
Data entitiesNumberSequenceTableEntityNumber sequence code Microsoft data model NumberSequenceTableV2EntityNumber sequence code V2 Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageNumber sequence: New, Maintain, AdministrationOptionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=NumberSequenceTableListPage
Integrate withNumberSequenceTableEntity data entity Microsoft data model
Everyone

8Sources