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). Financial date: , Yes. The record already exists.

(0) ShareShare
ReportReport
Posted on by Community Member

5355.Error.jpg

Hi,

When i am creating any record in ax (PO,SO,Movement Journal) and this error is coming please help me....

"Cannot create a record in Inventory transactions (InventTrans). Financial date: , Yes.
The record already exists."

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Shadab Khan, It sounds as if you would have some problems with number sequences if this error message pops up each and every time a Transaction is recorded.Can you possibly check your number sequence setup? Hope it helps, Ludwig

  • Community Member Profile Picture
    Community Member on at

    i have no idea which sequence

    number have issue please advice me ...

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Shadab Khan,

    Probably start in the module where you currently have the issue e.g. inventory module. There you can check the inventory parameters and the last tab of the inventory parameters form shows you the number sequences used in this module. By doing a right-click and saying "view details", the respective number sequence will open. Once opened, please check whether the parameter "continuous" is selected. Also open the status list via the button at the very top of the form and see if some numbers are "hanging". If so, delete them with ALT+F9. Continue with the other modules where you have similar issues.

    Hope it helps, Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi ,Reinhard,

    As you said i deleted the hanging number in the Status list but still same issue ....please help..

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Shadab Khan,

    Have you also checked the number sequences of the inventory journal(s) you are using? Maybe something is wrong ("hanging") there (inventory Management - Setup - journals - Journal names, inventory). If everything looks fine please  open a new journal and try recording your transaction to check if the number sequence ceck fixed your problem. You might have to delete your old existing journal though.

    Hope it helps,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Shadab,

    This error is very weird. I will explain why. The LotID (InventTransID) is taken from a number sequence, but is used in the table InventTransOrigin. This is the base for all inventory transactions. The unique index of the table InventTrans (inventory transaction) is based on three fields:

    - InventTransOrigin (reference to the table with a record ID)

    - InventDimId

    - RecId

    As the record ID of each table should be unique, there must be probably something wrong with an index on the InventTrans table or a stored procedure to retrieve the next RecId is not working.

    So please check if there are changes to the index on the InventTrans table which might cause the issue. Also check on the SQL database if the stored procedure GetNextRecId exists and the AOS user has permissions on this stored procedure.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Shadab,

    In addition, check the last used record ID in the InventTrans table. Compare this with the NextRec value in the table SysSequences for the table InventTrans (table ID 177).

    Probably this is changed by someone.

    Have you also tried to restart the AOS machine(s)?

  • Community Member Profile Picture
    Community Member on at

    Hi, Mr Andre

    yes i restart the server and compile and sync on AOS but issue still same

  • Community Member Profile Picture
    Community Member on at

    Have You Solved issue Shadab ?

    how you overcome this issue?

  • usman.malik Profile Picture
    usman.malik 40 on at

    I faced the same issue, and its resolved by did below step.

    1)  In Inventory Module, Setup, change the LOT-ID  Sequence-No and increase the # and 9( both numbers by 3 or as you want),

    and also change the next sequence No, Next sequence no  = (1+ Select  Max(InvenTransid) from InventtRansOrigin where dataareaid = 'YourDatAAreaID').

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