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

(0) Share

Report

Posted on by Rizwan Idrees

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

All responses (18)

Answers (0)

Cas van de Luijtgaa... 5 on at

Like (0)

Report

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 212 on at

Like (0)

Report

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 10 on at

Like (0)

Report

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 1,798 on at

Like (0)

Report

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 385 on at

Like (0)

Report

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 510 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 3,085 on at

Like (0)

Report

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 601 on at

Like (1)

Report

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 70 on at

Like (0)

Report

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