Sales order invoice duplicate

(0) Share

Report

Posted on by udaY-ch

5,157

Hi Folks

We identified a scenario where the sales order invoice has duplicated and used the same invoice number more than once which was used before and it is a manual posting and i dont think summary update is used and yet not sure how this is happened but similar duplicates found in other legal entities. and there is no customization around the invoice posting.

Changing the parameter of continous to Yes would solve the problem, Has anyone faced similar problem and any solution for this issue ?

Thanks

Uday

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Diego Mancassola 412 on at

Like (0)

Report
Copy link

Link copied!

Hello, typically, sales invoices are configured with continuous number sequences precisely to avoid this kind of situation.

When the number sequence is not continuous, gaps and even re-use of numbers can occur in specific scenarios (for example manual posting, aborted postings, or parallel processing across legal entities), even without customizations and without summary update.

For legal and accounting reasons, invoices are normally required to have a unique and strictly sequential number, so setting the invoice number sequence to Continuous = Yes is the recommended and standard approach.

In our experience, enabling continuous numbering resolves duplicate invoice number issues and aligns the system with typical fiscal compliance requirements.

Was this reply helpful? Yes No
udaY-ch 5,157 on at

Like (0)

Report
Copy link

Link copied!

Hi Deigo

Thank you. I just wanted to reconfirm before making a choice of setting the toggle to yes on continous setting.

Thanks

Uday

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 1,188 on at

Like (0)

Report
Copy link

Link copied!

Hello,

As mentioned by Diego you can enable the continuous.

Furthermore, if you want to avoid at 100% this situation, you can even enable the validation check of the invoice number:

Thank you,

Giorgio

Was this reply helpful? Yes No
Suggested answer

H.M.Burhan 275 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can avoid this situation by selecting the Reject duplicate option in Accounts Receivable parameters. If, for any reason, the system assigns the same invoice number to different invoices, you will receive an error. In that case, you can fix the number sequence to prevent this from happening.

Cheers,

Burhan

Was this reply helpful? Yes No
Martin Dráb 238,560 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

I disagree.

Saying that non-continuous number sequences can generate duplicate IDs is simply not true, as far as I know. It would be a critical kernel bug that would cause problems everywhere (because almost all number sequences are non-continuous). By using a continues number sequence, you'll decrease performance and possibly cause other problems, all to avoid the bug that doesn't actually exist.

On the contrary, it's the continues number sequence that can generate duplicate IDs, when it tries to fill gaps and it incorrectly believes that a number wasn't used. Non-continues number sequences don't have this problem.

Check the invoice number used is a localization for a few European countries for cases when you enable Edit invoice ID on sales orders. Therefore it's not applicable to most customers. If you're in one of those countries and you want to always get invoice IDs from the number sequence, you should disable Edit invoice ID on sales orders. If you're not using this localization or you have Edit invoice ID on sales orders disabled, then Check the invoice number used doesn't apply to you either.

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 928 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @udaY-ch,

I agree with @Martin Dráb a non-continuous number sequence is not the root cause here (and it can also have a performance impact). What you’re seeing looks much more like the Customer Invoice number sequence was changed or reset at some point.

Also, to prevent this, the “Reject duplicate invoice numbers” parameter in Accounts receivable should be enabled, as advised by other folks.

I would recommend checking the Customer Invoice number sequence History to see what happened to the sequence.

Under normal, standard manual posting, the system should not behave like this. This typically only happens if the invoice was posted via batch and retried, through an integration, or due to custom code, or if the number sequence was manually modified/reset.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
udaY-ch 5,157 on at

Like (0)

Report
Copy link

Link copied!

Hi Folks

Thank you all for your answers. Check invoice number feature works only for free text invoice and it cannot be used for sales order based invoices. This is for free text invoice

Martin : I did checked the flag "check invoice number used" which is specific to certain EU regions and I am having this issue in US. I thought not to extend the flag to make the functionality global and felt enabling the continous on the number sequence would be a fix but I read there would be implications on the performance when it is being enabled and we have around 15+ legal entities. I have read your old comments on the similar question before but still wanted to check on the community is there any better solution for the problem.

I am also thinking about contacting Mirosoft since this is not happening every day and once in a while and there is no standard option without any cusotmization.

Thanks

Uday

Was this reply helpful? Yes No