Unable to upload data in SalesLine table using data entity

(1) Share

Report

Posted on by AnandKrishna

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.

All responses (3)

Answers (1)

AnandKrishna 18 on at

Like (0)

Report

Unable to upload data in SalesLine table using data entity

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
Verified answer

GirishS 27,823 Moderator on at

Like (0)

Report

Unable to upload data in SalesLine table using data entity

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.
Mohit Rampal 12,556 Moderator on at

Like (0)

Report

Unable to upload data in SalesLine table using data entity

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.