Finance | Project Operations, Human Resources, ...

Data Entity set the Reference (RecId) on datasource

(2) Share

Report

Posted on by Johnny

6,494

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)

Sort by

Suggested answer

Anthony Blake 3,224 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please send your code which you have written in mapentitytodatasource method.
Johnny 6,494 on at

Like (0)

Report
Copy link

Link copied!

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?