web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Number sequeces - best practice

(0) ShareShare
ReportReport
Posted on by 10

Hi, I'm struggling to find best practices regarding number sequences, so I have a few questions I'm hoping someone can answer or provide me with a suitable link for.

1. Some countries have regulations saying that number sequences for transactions that are posted to the ledger must not include duplicates nor gaps. Gaps can be solved by simply using a continuous number sequence, but there is often a risk of duplicates when using the wizard for generation as several sequences get identical formats, or duplicates can be generated when a number sequence goes very high and overlaps another. Is there a convenient way to make sure that no duplicates will be generated or do I need to adjust the number interval manually for all number sequences intended for ledger transactions? Has anyone come across a list saying what number sequences are used for transactions posted to the ledger (as these are typically the ones covered by regulations)?
2. What is the downside of using continuous number sequences?
3. Should the company code be included as a prefix in the number sequence or not? What is best practice and why?
4. Is there something to consider when it comes to length of a number sequence? For example reports that allow a maximum number of characters and will cut the number sequence if it is too long?

I have the same question (0)
  • Suggested answer
    BillurSamdancioglu Profile Picture
    20,521 Most Valuable Professional on at

    Hi,

    In Turkey we have certain requirements for number sequence to be continious. So we use some localizations by to add a field on voucher transaction and update accordingly in the year ends or month ends, depending on the rules.

    If you are ok to have number sequences, you can use ledger parameters parameter to not to allow duplicates.

    As I used to do, I go over all the number sequence parameter and change the number sequence in the parameters to be able to have visuality in number sequence like to add a constant upfront. (you can upload number sequences via Data Management)

    There s no downside to use continious number sequence.

    You do not need to use company code as a prefix. You can use if you require in the report to understand from which company does that transaction come from but it is not a must just a way. You can use data area id for that purpose.

    For number sequence length, you need to be sure that the field you use has the correct length of the number sequence or else number sequence will be cropped.

  • Martin Dráb Profile Picture
    238,782 Most Valuable Professional on at

    1. Duplicates should never occur and they would usually cause the whole process to fail, because number sequences are typically used for unique fields and the database reject records with such duplicates. If you configure conflicting numbers sequences for a single field, it's a bug in your configuration.

    2. The main problem with continuous number sequences is the impact on performance.

    3. It depends on how you want to use the values.

    4. You need to respect the length of data field. If there is a report that can't accept all characters of a field, it's a problem in the report and not in a number sequence.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 386

#3
Adis Profile Picture

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans