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 :
Finance | Project Operations, Human Resources, ...
Answered

Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

(0) ShareShare
ReportReport
Posted on by 468

Hi Team,
I am getting below error while importing sales line using Sales Order line V2 entity.

Please suggest me the solution.

Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

Steps I have followed.

Imported SO header.

and now want to create new line using entity import, I have set line number as auto generated and lot id kept blank.

I have the same question (0)
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    3,634 Moderator on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Have you added any new datasource to the entity? If yes, then please let us know allowed it and edit on create properties of the entity staging and table. Because this error comes on join type given when joining.

  • Vijay Yelmame VY Profile Picture
    468 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Hi Bharani Preetham Peraka ,

    Thank you for your response. I have not added any DS in the data entity. Only few fields added. few fields having EDT of InventTransID.

    pastedimage1683174514954v1.png

  • Bharani Preetham Peraka Profile Picture
    3,634 Moderator on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Can you try making Ignore EDT relation to yes at field and table level (if you have relation made)? Also please let us know the property of allow edit and allow edit on create for the staging and to entity.

  • Suggested answer
    Mohit Rampal Profile Picture
    12,563 Moderator on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Hi Vijay, Can you try making lot Id auto generated instead of Blank or provide lotId number manually in file.

  • Vijay Yelmame VY Profile Picture
    468 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Hi Mohit,

    I have removed my customization from entity and tried with setting up lot id auto generated but no change in the result.

  • Mohit Rampal Profile Picture
    12,563 Moderator on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Can you try to export SalesOrderLineV2Entity to excel. Remove all lines and add one line for import. use this template while importing to ensure its not template issue.

  • Vijay Yelmame VY Profile Picture
    468 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Same result after using same exported format.

  • Bharani Preetham Peraka Profile Picture
    3,634 Moderator on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Have you tried like ignoring the edt relation to yes?

    And can you let us know about the properties which I asked earlier?

    Also please let us know the steps you did for adding these fields?

  • Vijay Yelmame VY Profile Picture
    468 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    About properties yes both are set yes on Table level. Let me try on ignore relation on table level.  I will update you the result,

  • Vijay Yelmame VY Profile Picture
    468 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    HI Bharani Preetham Peraka,

    It is not working even i set ignore EDT relation yes to all fields and set allow Edit to yes well.

    Strange..

    I did tried by removing all customization from entity but still the issues not resolving.

    is there anything new in this SalesOrderLIneV2 entity in last 2 release ?

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 796

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 530 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans