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

(0) Share

Report

Posted on by Vijay Yelmame VY

476

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)

All responses (16)

Answers (1)

Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

Hi Mohit,

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

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

Same result after using same exported format.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No