You’re offline. This is a read only version of the page.
Good Afternoon,
I am receiving the following error when trying to post a statement.
After doing some reading on my own I found out that this might be caused to a Number Sequence limit. How can I proceed to increase this number? Would it be in the SQL table it's self or within AX?
Thank you for any help provided!
*This post is locked for comments
We were getting the same error while users were trying to Create and Post journal entries in AP, AR and GL modules. I was able to resolve this by Compiling and Synchronizing the following tables and form.
Compiled and Synchronized the tables
LedgerJournalTable
LedgerJournalTrans
Compiled the form
Ledgerjournaltable
Everyone was able to create and post journals after this. For one person I had to RESET the Usage Data and Clear CACHE by deleting the *.AUC files in \APPDATA folder.
We had same issue, change the Number sequence for General ledger with max length including constants to 10 only.
In your case: AEV-000000334 must be AEV-000334.
Also if you have multiple legal entities then make sure each legal entity General ledger number sequence have unique format.
Depending on if it is a journal entry in GL, AP or AR, the following are the locations for number sequences:
GL -> Setup -> Parameters - Tab name: Number Sequences
AP -> Setup -> Parameters - Tab name: Number Sequences
AR -> Setup -> Parameters - Tab name: Number Sequences
this is a common issue, you can check this link
stoneridgesoftware.com/microsoft-dynamics-ax-error-the-record-already-exists
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
Zain Mehmood
6
Moderator
Share
Report
All responses (
Answers (
