News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Custom DMF Inser Issue

Finance | Project Operations, Human Resources, ...

Suggested answer

Custom DMF Inser Issue

(0) Share

Report

Report

Posted on by Community Member

There is a problem in importing a large amount of data to DMF.

ex) DMF (5766 row)

--> DMF Result (1726 inserted, 4040 updated)

but, update 4040 row not exist target table.

I checked if the staging table and target table were mapped incorrectly, but the field mapping is ok.

The pk of the staging table and the target table is the same.

- TYM_PP_T_PLATEMASTER_L (pk : itemid, plateno, LineNo)

- TYM_PP_T_PLATEMASTER_LSTAGING (pk : itemid, plateno, LineNo)

but. There's something weird.

staging table : * field (plateno, lineno)

target table : * field (plateno, lineno, itemid)

Why does the PK of the two tables look different in the mapping structure?

I also tried entity refresh. but this problem not solved.

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

André Arnaud de Cal... 292,886 Super User 2025 Season 1 on at

Like (0)

Report

RE: Custom DMF Inser Issue

Hi Dongwoon,

Can you share technical details about this data entity? What is the entity key defined here? If the entity key is incorrect, e.g. missing a field, this could explain the current view and behavior. Ensure that the key on the data entity contains the three fields; then also update or regenerate the staging table.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,886 Super User 2025 Season 1

#2

Martin Dráb 231,766 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans