Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Cannot create a record in Ledger Journal table (The record already exists)

Posted on by Microsoft Employee

Good Afternoon,
I am receiving the following error when trying to post a statement.

2335.error.PNG

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! 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Ledger Journal table (The record already exists)

    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.

  • Verified answer
    AXSHAH Profile Picture
    AXSHAH 526 on at
    RE: Cannot create a record in Ledger Journal table (The record already exists)

    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.

  • oldman.logan Profile Picture
    oldman.logan 557 on at
    RE: Cannot create a record in Ledger Journal table (The record already exists)

    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

  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at
    RE: Cannot create a record in Ledger Journal table (The record already exists)

    this is a common issue, you can check this link

    stoneridgesoftware.com/microsoft-dynamics-ax-error-the-record-already-exists

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans