Number Sequence Getting Skipped in Ax


We have gone through the number sequence issue that we are facing in Axapta. Below are my findings on the issue, Please suggest how to proceed on this issue.

Continuous:- Select this check box for a continuous sequence.(if this is selected system will generate continues number sequence, which is selected in our Case)

Cleanup - When this option is selected, the number sequence is cleaned up automatically.(this option is selected in Our case)

This option is automatically selected when the number sequence is continuous (it is ticked in our case), and should not be cleared. For continuous number sequences, the next available number from the sequence is used when a transaction is entered. If a number is generated but the transaction fails, automatic cleanup allows the number to be used again.

You can set up a time interval for automatic cleanup in the Interval field. (In Our case Time Interval is set to 24 hours which according to Microsoft is a Best Practice)

Root Cause :-
If a user has a power failure, system failure, or other unexpected failure of the client while a number is being generated, cleanup must be performed manually.

Resolution:-
Click the Cleanup button to manually clean up number sequences, The current number sequence or all number sequences.

This is the link from Microsoft from  your reference.

Comments