web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 agreementlinereleasedline table..record already exists ..

(0) ShareShare
ReportReport
Posted on by AX 2012 r3 2,426

Good Morning,

For one SalesOrder While posting invoice showing error.

"Cannot create record in Agreement released line(AgreementLineReleasedLine).The record already exists".

"An Error Occured during Update".

1832.Invoice.png

Please help me to solve this issue.

Please Find the attachment for reference.

Any suggestion will be greatly appreciated.

Regards,

*This post is locked for comments

I have the same question (0)
  • Paulo Menezes Profile Picture
    Paulo Menezes 177 on at
    RE: Cannot create a record in agreementlinereleasedline table..record already exists ..

    Please verify the recid of the table. I think that it's trying to record a recid that isn't the next recid of the table. You can check the next value of recid to a table from table systemsequences.

  • AX 2012 r3 Profile Picture
    AX 2012 r3 2,426 on at
    RE: Cannot create a record in agreementlinereleasedline table..record already exists ..

    Good Morning Paulo,

    Thanks for your quick reply.

    I have done that also

    i have seen max(recid) for agreementlinereleasedline and updated in systemsequence table..it updated.

    Restarted AOS and Sql server

    When posting invoice again the sme error.

    Please help.

    Regards.

  • Paulo Menezes Profile Picture
    Paulo Menezes 177 on at
    RE: Cannot create a record in agreementlinereleasedline table..record already exists ..

    I think this link can help to solve your problem:

    deepakdyanmicsax.blogspot.com.br/.../record-ids-in-ax-2012_5.html

    Please let me know if your problem was solved after that.

  • Atiraj Profile Picture
    Atiraj 50 on at
    RE: Cannot create a record in agreementlinereleasedline table..record already exists ..

    Do you have any solution for this problem? I'm facing the same error.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Cannot create a record in agreementlinereleasedline table..record already exists ..

    Hi AX 2012 r3,

          Once synchronize your table. may because of synch it is showing that error.

    Thanks

    Suresh

  • Verified answer
    AX 2012 r3 Profile Picture
    AX 2012 r3 2,426 on at
    RE: Cannot create a record in agreementlinereleasedline table..record already exists ..

    Hi Atiraj,

    Please synchronize tables whichever you get error

    For this Synchronize tables Agreementline and agreementHeader

    Go to AOT --> DataDictionary --> Tables --> (Whichever table you get as a error mentioned in infolog) --> Right Click --> Sunchronize and Compile.

    Best Regards.

  • sekhark Profile Picture
    sekhark 86 on at
    RE: Cannot create a record in agreementlinereleasedline table..record already exists ..

    Dear Experts,

    We are facing same issue with same RecId 5637149076 for some customers only but not for all customers or not for any specific customer group in AX 2012 R3 CU9.

    So, we tried table synchronise, complile. AOS also restarted. But no use.

    We checked NextValue in SystemSequences. It is greater than the max value in table. Can anybody suggest me further.

    Thanks

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans