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 record. ...
Microsoft Dynamics AX (Archived)

Cannot create record. The Record already exists.

(1) ShareShare
ReportReport
Posted on by Community Member

Dear All,

when i create new line in salesorder form showing this error "

Cannot create a record in Order lines (SalesLine). Sales order: 000002, S0007.
The record already exists "

" in salesLine table no record showing.

Could somebody give me some suggestions on what might be wrong and how to fix it?

*This post is locked for comments

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

    Hi subh,

    Have you checked the number sequence that is used for creating your sales orders/order lines and whether some numbers might be hanging there in the status form?

    Ludwig

  • Mea_ Profile Picture
    Mea_ 60,284 on at

    Hi subh,

    There are couple of unique indexes you can find on salesLine, this message means that you are trying to insert data that violates one of them. You need to put breakpoint somewhere on insert, check what values get inserted and see if you already have these index values in DB.

    As Ludwig mentioned It could be number seq issues, that generates numbers already used.

  • kbendrikar Profile Picture
    kbendrikar 65 on at

    This is due to uncommited transaction! Resarting AOS solved my problem

  • joelhtown80 Profile Picture
    joelhtown80 30 on at
    I also have the same issue but with Purchase Orders. I used Logic Apps in creating the record. Here are my steps:
     
    1. Check if the PO already exists in F&O. There is none.
    2. Created the PO header in PurchaseOrderHeadersV2. It was successful.
    3. Check if there are line items for the PO in PurchaseOrderDetailsV2. There is none.
    4. Created the PO Line item in PurchaseOrderDetailsV2. It was an error.
     
        
     

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