Finance | Project Operations, Human Resources, ...

Data entity creating a new record instead of updating it.

(1) Share

Report

Posted on by spidey1010

185

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.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
spidey1010 185 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Martin Dráb 238,193 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No