News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Data entity creating a...

Finance | Project Operations, Human Resources, ...

Suggested answer

Data entity creating a new record instead of updating it.

(1) Share

Report

Report

Posted on by spidey1010

101

Hi ,

I created a new data entity which automatically took one more datasource (suppose B)with which it has foreign key relation. I have added two fields from the datasource A and 1 field from datasource B. In the key I have 2 fields 1 each from both datasources. While importing, it creates new record instead of updating the existing one. Please suggest what approach I can use.

All responses Img

All responses (3)

Answers Img

Answers (0)

Martin Dráb 230,503 Most Valuable Professional on at

Like (0)

Report

Data entity creating a new record instead of updating it.

Which of the tables do you mean when saying "it creates new record"?

You said your entity has two key fields, one from TableA (let's call it FieldA) and one from TableB (FieldB). Is FieldA the primary key of TableA and FieldB the primary key of TableB?

Doesn't it belong to an F&O forum? I see all your other threads are about F&O, not Dynamics AX.
spidey1010 101 on at

Like (0)

Report

Data entity creating a new record instead of updating it.

Hi Navneet,

I dont think so this is the issue. Because for other entities, this is working fine. But for this one its behaving differently.
Suggested answer

Navneeth Nagrajan 1,439 Super User 2024 Season 2 on at

Like (0)

Report

Data entity creating a new record instead of updating it.

Hi,

For the new data entity, following are the suggestions:

1. If you are running the import for the first time suggestion is to use a full push while importing data through the data entity as illustrated in the screen clip below.

2. If you are running the import post your first run then enable change tracking on the data entity and change the Default refresh type to incremental.

Added an entity Customer Details V2, enabled Change tracking and changed the import to an incremental push.

Hope this helps. Happy to answer questions, if any.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans