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 / Finance | Project Operations, Human Resources, ... / Cannot create a record...
Finance | Project Operations, Human Resources, ...
Answered

Cannot create a record in agreementlinereleasedline table. record already exists while invoicing sales order

(0) ShareShare
ReportReport
Posted on by sekhark 86

Dear Experts,

We are not able to post invoice to one of the sales order for some customers only but not for all customers or not for any specific customer group. We are getting below error in AX 2012 R3 CU9.

6457.Untitled.jpg

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

I think there is no issue with RecId. But I checked NextValue in SystemSequences. It is greater than the max value in table. Can anybody suggest me further.

Thanks

I have the same question (0)
  • Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at

    Try identifying what is the unique index on the table and see if values are somehow getting duplicated from the code during insertion. Another option would be to debug insert method to see if it's called multiple times and then determine if it's custom code vs. standard. If the error is there first time, see what value it's trying to insert and then try to insert that data manually in AOT and see if you get same error. To rule out number sequence error, try inserting record in that table manually from AOT. Debug is your best option at this point as it's not functional error.

    Thanks,

    Satish Panwar

    Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    There is KB article https://fix.lcs.dynamics.com/Issue/Details/1323481?bugId=839494 that says:

    After changing the formats for the Customer Invoice Number Sequence and the Sales Credit Note Number sequence we were able to resolve the issue. Customer Invoice Number Sequence and the Sales Credit Note Number sequence were set up exactly the same.  It is recommended to set up the number sequences so that each one is unique.

    So, check number seq!

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans