Finance | Project Operations, Human Resources, ...

Data Entity set the Reference (RecId) on datasource

(2) Share

Report

Posted on by Johnny

6,414

Hello,

there is a standard data entity for Planned Orders (ReqPlannedOrderEntity), which is read-only and we wanted to change it.

I have duplicated it and set Read-Only to No.

I have removed some datasources too and currently I keep only ReqPo and InventDim.

The Key on datasource and on table ReqPo is a PlannedOrderID (RefId) and PlanVersion (RefRecId to ReqPlanVersion table).

I have a unmapped str field on data entity which during the export is filled by the PlanVersion Id in the postLoad method.

But I have problem during the Import. Even though I have value in the PlanVersionId field in Excel, when I import it I do not see the value (during debugging) in any of the following methods (mapEntityToDataSource, mapDataSourceToEntity, postLoad). And I'm getting error that the Reference isn't set (because of the PlanVersion field, which is refRecId).

How can I achieve it? Which method can I use?

So, I have a value in excel column and this column/field is mapped to an /UnMapped/ field of Data entity / staging table. And I want to use this value (which is the plan version id) to find a recid of ReqPlanVersion table.

All responses (3)

Answers (0)

Johnny 6,414 on at

Like (0)

Report

Data Entity set the Reference (RecId) on datasource

As I see ValidateWrite is executed first and it thrwos error that Reference isn't set, so it does not even go to mapEntityToDataSource where I assign value to "Reference" field.

So, what would be a place place to place the code?
Bharani Preetham Pe... 3,613 Super User 2024 Season 1 on at

Like (0)

Report

Data Entity set the Reference (RecId) on datasource

Please send your code which you have written in mapentitytodatasource method.
Suggested answer

Anthony Blake 2,212 Super User 2024 Season 2 on at

Like (0)

Report

Data Entity set the Reference (RecId) on datasource

Take a look here:

https://community.dynamics.com/forums/thread/details/?threadid=491d3581-d83c-4339-a681-00f41a4080dc

There are a few options:

Handle creation manually from unmapped field using mapEntityToDataSource

Create the data entity from scratch using the wizard

Take a look at how some standard entities handle the same situation, there al lots of RefRecId references in standard code.