web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Community Member Profile Picture
    Community Member on at
    RE: AX 2012 - Cannot create a record in Inventory transactions (InventTrans). The record already exists.

    Dear Irum

    I had the same problem and the solution you mentioned works

    Thank You 

    Regards

    Bilal Yaqub

  • Roshani Profile Picture
    Roshani 20 on at
    RE: AX 2012 - Cannot create a record in Inventory transactions (InventTrans). The record already exists.

    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

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at
    RE: AX 2012 - Cannot create a record in Inventory transactions (InventTrans). The record already exists.

    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.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans