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.
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.
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.
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.
Hi Vijay, Can you try making lot Id auto generated instead of Blank or provide lotId number manually in file.
Hi Mohit,
I have removed my customization from entity and tried with setting up lot id auto generated but no change in the result.
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.
Same result after using same exported format.
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?
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,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 796
André Arnaud de Cal... 721 Super User 2025 Season 2
Sohaib Cheema 530 User Group Leader