AX 2009 : Status for number sequence is populated with used Numbers with Status Free


The status for number sequence list was populated with Numbers which have already been used 3 years ago with Status ‘Free’ and Action ‘None’. As a result there was an error in the Fixed Assets details addition as the number already existed.

Please advice what might be the root cause.

As checked ,

(1) There was no definition group or any special data upload process to enter fixed assets. The only way was using the New option in the Fixed Assets form.

(2) 3 fixed assets groups were using the same number sequence. But AX allows this.

(3) The number sequence had been cleaned up.

I am wondering if it would be wise to enable the database log for the number sequence tables as it will slow down system performance.

Please advice.