add recId field to entity

(0) Share

Report

Posted on by ..

1,133

Hi,

I created a table with the following fields (Table1)

Number Id codeX codeY Field1
------ --- ------- ------- --------
1 id1 codex1 codey1 fieldz
2 id2 codex1 codey1 fieldz

index "Idx" with allow duplicate No is "Number"
replacement key index is "Idx"

I created a field group with CodeX only to use it in the form

I added Table1RecId field to 'SalesLine' table where the relation is: Table1.RecId == SalesLine.Table1RecId
This field appears in "SalesTable" form with replacement fieldGroup having CodeX only

Now i want to be able to import CodeX via SalesOrderLineV2Entity

i added table1 as a read data source to the entity (outer join salesLine). I added CodeX to the entity fields and the staging table.
I also added Table1RecId from SalesLine to the entity fields, and made it private.

Now when i import, i'm getting this error:
"Matching record for the read only data source 'Table1' does not exist"

Categories:

Dynamics 365 Finance