Skip to main content

Notifications

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 438

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.

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

    Yes, that can be done. But I am wondering how this is working in my other environment where the version is lower than my dev.

    anyways thank you so much for your guidance.

  • Verified answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Exactly I also did similar thing. So permanent solution in such case can be make that field in entity and table as allow edit to no if possible. So that no need to delete field all the time from Excel.

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

    I found the field IntrastatSpecialMovementCode which is part of SalesLine_Intrastat table. I removed this from my file.  then it worked.

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    If it's not working then you can make use of mapentitytods method on entity. That will work. Anyways if allowed it is no data won't come inside.

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

    I have set allow edit property to Yes, Let me set No i try once. But my requirement is to update that values from data entity but let me try it.

    and before version upgrade it was worked for me not sure how.

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Results. Matching record with key 'SalesLine': 5637249576 for the data source 'SalesLine_Intrastat' does not exist

    Anything new I am not sure. When I got this error earlier, I used to make allowedit and allowedit on create to no both on staging and entity as I have added those fields via ds using relation and also in UI also via form DS. So made as above and issue is resolved.

    Recently when I came across, I used the mapentitytodatasource method when I get this error. But I won't suggest this as it impacts performance.

    You can try like once added these fields, just check how the fields from intrastat are showing. I mean how standard is using that ds fields as that ds fields only used for reading. But we cannot confirm directly that its not working from standard itself. Just try import in other vm also.

    Can you tell us from which ds you have added these fields?

  • Vijay Yelmame VY Profile Picture
    Vijay Yelmame VY 438 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 ?

  • Vijay Yelmame VY Profile Picture
    Vijay Yelmame VY 438 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,

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 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
    Vijay Yelmame VY 438 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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans