Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

Posted on by 525

Hi - I am facing problem in posting Vendor Invoice Journal, System give following error and Journal becomes locked by system

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

Anybody have expereince or can suggest solution for this problem? We are useing Dynamics AX 2012 with Cumulative update 2.

Thanks

*This post is locked for comments

  • RE: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    We have had the same problem and solved it as follows.

    In the error message the number of the journal and the corresponding table is shown. Check the table to see that the number is already used.  If so,

    go to Organization administration/Common/Number sequences/Number sequences

    Select Number Sequences.

    Check Status List.

    There you will see the entry that's earlier shown in your error message. This is the entrie that AX thinks he must use the next time, but the problem is that it already exists.

    If it's the same entry, select the entry and delete it with ALT-F9.

    Run Manual Cleanup - Current

    The problem should be solved.

  • Suggested answer
    saransh321 Profile Picture
    saransh321 212 on at
    RE: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    Thanks I too resolved this issue but in a different way. I checked whether the stored procedure exists which was positive. I also checked whether the AOS user has access to to this procedure and this too was positive. This problem was encountered for the first time. One thing to note that i received this error after i restored previous week database backup. I Couldn't remove continuous as this was requirement. I Simply restarted the AOS then the DB Server. This resolved my issue.

    Thanks again for you solution.

  • Ruud De Baecke Profile Picture
    Ruud De Baecke 10 on at
    RE: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    run axutil schema command, it will regenerate the stored procedures including getNumInternal

  • Evaldas Profile Picture
    Evaldas 1,798 on at
    RE: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    Thanks NICOLAS GRANJON!!! The problem was this store procedure not updated to AX 2012 R2. You have saved me tons of time ;)

  • Shirl Profile Picture
    Shirl 385 on at
    RE: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    FYI, I had the same problem and the fix I had was updating the subledger journal entry number sequence to not be continuous.

  • Nicolas GRANJON Profile Picture
    Nicolas GRANJON 510 on at
    RE: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    Hi,

    In our case, the problem came from the upgrade from R1 to R2, the stored procedure getNumInternal still had the code from R1. I've replaced the stored proc code by the real code(which includes the new input 'Partition' parameter) and it works !

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    I faced the same issue and fixed it by modifying the number sequence of the

    General Journal Transfer in GL parameter

  • Ahmed Muhammad Alam Profile Picture
    Ahmed Muhammad Alam 3,085 on at
    Re: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    Dear All I have received the same error. In fact I have tried to uncheck the continuous [not feasible for us, because we need automatic number sequence] box and the GetNumInternal stored procedure is also there. Any other solution

  • Suggested answer
    Biju_John Profile Picture
    Biju_John 601 on at
    Re: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    Hi

    Following is the response we got from MS support consultant; i have not personally applied this in any environment. I think its worth giving a shot.

    The cause of for the issue is likely in the SQL stored procedure “getNumInternal”. It might be missing or AOS account has no permissions to execute the procedure.

    Could you please go to SQL Management Studio -> AX database -> Programmability -> Stored Procedures and check if the procedure is present and if AOS account has permissions to execute the procedure?

    You can grant permissions explicitly for the AOS account with this SQL query:

    use MicrosoftDynamicsAX; --replace with actual AX database name

    grant execute on dbo.getNumInternal to [contoso\administrator] --replace with actual AOS domain account

    Please run in TEST environment first and create SQL backup before performing any updates!

    Regards

    John

  • lp 181082 Profile Picture
    lp 181082 70 on at
    Re: Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

    Uncheck the continuous box of number sequence code which you define in GL setup> parameter > number sequence > Subledger Journal entry

    Rabia

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans