Finance | Project Operations, Human Resources, ...

Duplicate number sequence error

(1) Share

Report

Posted on by MuthukumaranAX

2,903

Hi Experts,

We have been experiencing frequent "Number sequence duplicate" issues while posting journal entries, packing slip, and invoices.

We identified that this issue is caused due to number seq locking, as a fix we manually clear the locked seq to unblock the user.

Has anyone faced similar issue?

Any suggestion/recommendation would be great help.

Thanks in advance

Categories:

Microsoft Dynamics AX

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

Like (1)

Report

Hi Muthukumaran,

I do assume you get an error stating that a number sequence is already in use?

Can you tell how the journals are entered in this environment? Is it using a custom import there might be a bug in the X++ coding. When a journal line is created, used vouchers should not appear in the status list of the number sequence. Only when lines get deleted, an unused number will be put in the status list. In case after an import the used voucher numbers in a journal are also in the list, the developer made a mistake on how to fetch number sequences.

Was this reply helpful? Yes No
MuthukumaranAX 2,903 on at

Like (1)

Report

Hi Andre,

Thanks for your response.

The journals are created manually and not through X++ code. even then we see lot of time the number sequences are blocked in the list and we had to clear the same every time to unblock the user. this is happening a lot in the recent times.

any suggestion on how to understand this issue ?

Thanks in advance

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 983 on at

Like (1)

Report

Yes, I had the same issue, and in my case, I leaverage a couple of things to avoid this:

- In my case, I deactivate the pre-allocation feature to avoid that:

- you can allocate the voucher during the posting:

- you can schedule an auto-clean in the bath process (if the option show upper are not activeted):

Thank you,

Giorgio

Was this reply helpful? Yes No