Finance | Project Operations, Human Resources, ...

Duplicate voucher numbers generated in General Journal

(2) Share

Report

Posted on by Saalim Ansari

627

Hello Community,

We are facing an issue with a General Journal voucher number sequence in D365FO.

Setup:

Continuous = Yes
Preallocation = Yes (5 numbers)
Automatic cleanup = Yes

Issue:

When posting General Journals, we observed that voucher numbers already used and posted (e.g., XXX000000518) are being reissued again after some months.
On posting, system throws the error: “This voucher is already posted on X date.”
On running the “Check voucher series” report, shortages and gaps appear.

Investigation:

It looks like numbers that were already consumed (posted in General Journal) are still marked as Free in the Number Sequence status table. This means the number sequence tracking is out of sync with the actual voucher usage. So when the system allocates numbers again, it incorrectly thinks these vouchers are available, even though they already exist in transactions.
This mismatch seems to occur when Continuous + Preallocation are used together.

Categories:

Dynamics 365 Finance

Dynamics 365 Fraud Protection

Dynamics 365 Human Resources

Microsoft Dynamics SL

Microsoft Dynamics GP

Microsoft Dynamics AX

Dynamics 365 Project Operations

Dynamics 365 Project Service Automation

Dynamics 365 Intelligent Order Management

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Sagar121 327 on at

Like (1)

Report

Duplicate voucher numbers generated in General Journal

Hi,

Can you please run the clean-up and then check the report again/ do posting again? I would recommend trying this first in an identical Non-Prod database.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 216 on at

Like (0)

Report

Duplicate voucher numbers generated in General Journal

Hi Saalim,

This issue is occurring because of the combination of Continuous + Preallocation, which is not recommended by Microsoft.

When both are enabled, the NumberSequenceStatus table can sometimes get out of sync with the actual voucher usage. This causes numbers that were already posted to remain marked as “free,” and later, the system tries to reissue them, leading to the duplicate voucher error. I recommend disabling preallocation for continuous sequences would resolve your issue.

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

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
André Arnaud de Cal... 297,316 Super User 2025 Season 2 on at

Like (0)

Report

Duplicate voucher numbers generated in General Journal

Hi Saalim,

I haven't seen this in a while. As mentioned by Giorgio, can you try to disable the pre-allocation?

Can you also tell us if there is a customization for creating the journal lines? Do you allow for manual override of numbers to a lower or higher number?

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 728 on at

Like (0)

Report

Duplicate voucher numbers generated in General Journal

Hello,

Please try the following two actions to resolve this issue:

-In the journal, enable the flag to allocate the voucher during posting.

-In the sequence number setup, disable the Preallocation option.

Additionally, under General ledger parameters > General, you can choose to activate a validation to check for duplicate entries during posting.

Thank you,
Giorgio

Was this reply helpful? Yes No