Skip to main content

Notifications

Announcements

No record found.

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 6

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
    6 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
    3,524 Moderator 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
    6 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
    3,524 Moderator 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
    6 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
    3,524 Moderator 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
    6 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
    6 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
    3,524 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
    6 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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

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

#1
Jahanvi Profile Picture

Jahanvi 34

#2
PJ JohnPaul Profile Picture

PJ JohnPaul 5

#3
SudhanshuMSID Profile Picture

SudhanshuMSID 1

Overall leaderboard

Product updates

Dynamics 365 release plans