Not able to create any entry in ax in all modules

(0) Share

Report

Posted on by Community Member

When we try to create Purchase order, journal or any item in ax it is not allowing to create. Cannot create a record in table(standard) errr is shown .

We tried to update the NEXVAL in the table SYSTEMSEQUENCES with the MAX(RecID) from the corresponding table. Now, it allowd to Create once, when we create the next time, it throws same error. Now, when we checked the SYSTEMSEQUENCES table, it was not incremented there.

Also, we tried Full Compile, Synchronize and AOS restart. ALso, cache cleaning and usage data reset.

Please help.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi AX Developer,

Have you checked your role assigned and whether you have sufficient rights to create a PO or journal?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

This hapens even for System administrator and for all entries , not only PO

Was this reply helpful? Yes No
Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you provide the table name where you are getting this error.

Was this reply helpful? Yes No
Rati Sharabidze 612 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are you sure that you need to update the recid? Maybe another table is restricting to create data. There can be many reasons. Can you share the code where it is popped? The best solution would be to debug it which can only be done by you. Put a break point in the validateWrite method to see the issue.

Best regards

Was this reply helpful? Yes No
Suggested answer

Heinz Schweda 1,367 on at

Like (0)

Report
Copy link

Link copied!

Hello, check your Stored procedures on SQL-Server. I had a similar problem a long time ago, where the stored procedure getNumInternal was missing.

See also community.dynamics.com/.../70737

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Getnuminterval stored procedure is there Heinz..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Chaitanya

For journals ledgerjournaltable , and also no customization is done . All standard table where record had to be added. The record id for the tables are not incremented. Systemsequence table is not updating with nexval so the error occured

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please try the workaround specified at the following links:

(Cannot create a record in tablename. The record already exists. / Get new recid for a table)

community.dynamics.com/.../cannot-create-a-record-in-tablename-the-record-already-exists-get-new-recid-for-a-table

(Microsoft Dynamics AX Error: The Record Already Exists)
https://stoneridgesoftware.com/microsoft-dynamics-ax-error-the-record-already-exists/

(Misleading "The record already exists" message)

mybhat.blogspot.it/.../misleading-record-already-exists-message.html

Was this reply helpful? Yes No