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, ... / Unable to upload data ...
Finance | Project Operations, Human Resources, ...
Answered

Unable to upload data in SalesLine table using data entity

(1) ShareShare
ReportReport
Posted on by AnandKrishna 18
Hello all 
 
I am try to import data through sales order lines v2 data entity using an excel file. The excel is file was downloaded after exporting using the same entity.
But I am getting the following error :- 
 
Results. Matching record with key 'SalesLine': 5637144576 for the data source 'SalesLine_Intrastat' does not exist
 
5637144576 -> recid on the sales line record.
 
 
 
 
I have the same question (0)
  • Mohit Rampal Profile Picture
    Mohit Rampal 12,565 Moderator on at
    Hi, I don't know the root cause of your issue, probably issue in data you are to insert. I am able to import Sales order line using 'Sales order lines v2' data entity. Try exporting one sales order, keep only one line in the file, change LineNum and LotId (If LotId is not auto generated) and see if you are able to import it.
  • Verified answer
    GirishS Profile Picture
    GirishS 27,827 Moderator on at
    Hi Anand,
     
    Open SalesLine_Intrastat in table browser - Location the record with SalesLine recid 5637144576  - If possible try deleting the record and check.
    In the excel do you have any field like "IntrastatSpecialMovementCode" ?
     
    Thanks,
    Girish S.
  • AnandKrishna Profile Picture
    AnandKrishna 18 on at
    We recently updated out systems and a new field called "IntrastatSpecialMovementCode" was added which was creating the issue. Once we removed this from the mapping we were able to import the data without any issues. 
     
    Thank you Mr.Girish for your help

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
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans