Plaza 365
Plaza 365

No results found for your search

RegisterLog in

4

Import Number Sequences via Data Entity

Visit article

#creation

#dataentity

#export

#numbersequences

#syntax

Dynamics 365 Finance

Category

Sep 9, 2023

Published date

Text

Article Type

AI Summary

  • Number sequences are used to generate unique identifiers for master data records and transaction records in Microsoft business applications like Dynamics 365 Finance and Dynamics 365 Sales.
  • The 'SequenceTables' and 'SequenceV2Tables' data entities can be used to import or migrate number sequences between environments.
  • The 'Format' column in the Number Sequences section of Organization Administration displays the dynamic portion of the number sequence, indicated by the # symbol.
  • The 'Segments' section within each number sequence contains the different parts of the sequence, which can be complex to create or update in a data entity.
  • When exporting number sequences via a data entity, the 'AnnotatedFormat' column stores the 'Segments' data in a complex formatting.
  • The JSON returned from the SequenceTables entity includes tabs and new lines that exist in the exported Excel file.
  • The best way to mass create custom number sequences is to manually create an example of each sequence type and use the output from the Data Management Framework export or the data entity as a template.
  • A file with different number sequence formats and their associated AnnotatedFormat patterns is provided for reference.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.