web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot create a record...
Microsoft Dynamics AX (Archived)

Cannot create a record in Inventory transactions (InventTrans). The record already exists.

(1) ShareShare
ReportReport
Posted on by Roshani 20

Hi All,

Below I have briefly explained problem and its solution so that it might help someone out there. Please do update your comments/feedback, if someone find it helpful.

Problem:

We faced an un-desired behavior in AX 2012, it started throwing "Cannot create a record in Inventory transactions (InventTrans). The record already exists." with every transaction that was being created in InventTrans from any Dynamics AX module.

IT_5F00_error.jpg

Solution:

We did following steps that resolved the issue:

1. Open AX client and

2. Switch to development workspace (Ctrl+D)

3. Cleared all cache/garbage object shown in screenshot below

4. Restart AOS service

5. Start the AX client again, create & verify InventTrans transaction

DW.jpg

Regards,

Irum

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    The primary key for InventTrans is RecId.  It seems most likely that your system sequence has gotten out of whack.

    Run the following SQL on your business database while your AOS is not running (because it reserves blocks of system sequences in memory).

    SELECT MAX(RECID) FROM INVENTTRANS;

    SELECT NEXTVAL FROM SYSTEMSEQUENCES S WHERE TABID = 177;

    If the first answer (the highest RecId already used) is greater than the second answer (the next RecId to be used), then you have found your issue.

  • Roshani Profile Picture
    Roshani 20 on at

    Hi Brandon,

    Thanks for sharing your valued suggestion.

    I did checked & verified InventTrans next record value in SystemSequences and observed that InventTrans RECID was < SystemSequence NextVal. So I don't see that this was a RECID issue. Yet for me, restarting AOS service does the job.

    Actually we faced "Cannot create a record in Inventory transactions (InventTrans). The record already exists." issue for the 2nd time. I guess that this issue happen because of some garbage data in AOT cached elements and clearing AOT cache and restarting AOS service resolved the issue. What's  your expert opinion?

    Irum

  • Community Member Profile Picture
    Community Member on at

    Dear Irum

    I had the same problem and the solution you mentioned works

    Thank You 

    Regards

    Bilal Yaqub

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans