Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Refreshing Target Fiel...
Finance forum

Refreshing Target Fields After Adding New Fields

(1) ShareShare
ReportReport
Posted on by raoraheel 85

I have been searching for a solution to bring in newly added custom fields to a data entity  in D365 F&O but can't seem to find a solution so far. I have already tried refreshing the entities but still don't see my new fields in there. I can delete the data entity and refresh the list again which I know will work as it did in a test system, but problem is that we have data projects in production being used. To delete will mean we'll have to first remove the data entity from all those projects, refresh the data entity and then re-add/re-create data project and users will not like that idea. 

Is there anything else we can think of that can be done to refresh a data entity without going through the exercise of deleting entity from projects?

Let me know please. 

Thanks!

Raheel

Categories:
Data Integration
Development / Customization / SDK
  • Suggested answer
    raoraheel Profile Picture
    raoraheel 85 on at
    RE: Refreshing Target Fields After Adding New Fields

    Thanks Oleksandr - this worked! I'll remember doing this next time I add more fields.

  • Eugen Glasow Profile Picture
    Eugen Glasow 6,357 on at
    RE: Refreshing Target Fields After Adding New Fields

    Concur with Oleksandr Nazarov. By the way, the new field must be in the staging table for it to work. Adding them to the entity alone is too little.

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,755 on at
    RE: Refreshing Target Fields After Adding New Fields

    You mean you have refreshed the entity list from data management framework parameters but you don't see the new field? You don't have to delete the entity from entity list to get the new column. Refresh entity list should populate the new column or just select the entity and click on Modify target mapping and then Generate mapping. And for data projects, you can click on view map inside the data project for that entity and add your new column if you don't want to re-add the entity. We have automated that process in case of republish or publishing a new entity.

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,682 Moderator on at
    RE: Refreshing Target Fields After Adding New Fields

    If the field is added in entity then you just have to generate target mapping. Did you perform that action?

  • Verified answer
    Sasha Nazarov Profile Picture
    Sasha Nazarov 901 on at
    RE: Refreshing Target Fields After Adding New Fields

    Hi Raheel

    You need to open the entities form, select your entity, click on "Modify target mapping" button, and then click on "Generate mapping" button.

  • duocprogrammer@gmail.com Profile Picture
    duocprogrammer@gmai... 35 on at
    RE: Refreshing Target Fields After Adding New Fields

    Hi Raheel Rao,

    After you added new fields into table, you must create extension for DataEntity.

    In the fields node of Data Sources of Data Entity, you can find newly fields that is entered in previous step.

    Drag that field  and drop into Fields Node of Data Entity. See image below .

    drag-drop.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,020 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans