Microsoft Dynamics AX (Archived)

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

(0) Share

Report

Posted on by Rizwan Idrees

525

Hi,

I am facing problem while posting Invoice Journal in Account Payables.

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

I don't know what went wrong, We are using Dynamics AX 2012 with cumulative update 2. Kindly guide me if someone knows the solution.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Muhammad Rizwan Idrees on at

Like (0)

Report

The Problem was because system was assigning duplicate Journal Number. It looks like continuous number sequence has some bug in AX 2012, because all sequence number which are continuous in our environment have same problem. As a work around i have disabled continuous check box with sequence numbers but will appreciate if someone can suggest better solution for it.

Was this reply helpful? Yes No
Suggested answer

Pieter Foolen 225 on at

Like (0)

Report

Indeed when you disable the continuous number sequence the problem seems fixed. However, there are several aereas where it is mandatory to use continuous number sequence.

I also encounterd this problem, and by exident I noticed that I was missing the stored procedure "GetNumInternal" on the SQL server datababase.

Restoring this stored procedure from another database solved this problem

Was this reply helpful? Yes No
lp 181082 70 on at

Like (0)

Report

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

Rabia

Was this reply helpful? Yes No
Suggested answer

Ahmed Muhammad Alam 3,089 on at

Like (0)

Report

I have fixed the problem.

I have tried all the above solutions but failed. I have seen one thing just go to the General Journal Parameter and than Number Sequence. For the developers, just check the GeneralJournalEntry table and sort the journalnumber column with desc wise and match next number sequence value with the parameter.

Another thing on the Status Issue, system may record some data. You must delete the data from that screen and Everything will be ok.....

Happy daxing.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

General Journal Transfer in GL parameter

Was this reply helpful? Yes No