web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

DMF staging table modification

(0) ShareShare
ReportReport
Posted on by 30

Hi,

I want to implement some logic in staging table, something like group several records into one record before import.
Is it possible? If yes, where I should do it (in which method) ?

Kind regards,
Roman

I have the same question (0)
  • nmaenpaa Profile Picture
    101,162 Moderator on at

    I don't think that it would be the correct solution to your requirement.

    Try to modify the data either before the import, or import it in a new intermediary table and modify it there before processing it to actual D365 tables.

  • nmaenpaa Profile Picture
    101,162 Moderator on at

    Yes, that's what I mean.

    You should modify the data either before importing it, or after importing it. But during the data entity import process might not be a good place for such changes.

  • Roman Konrad Profile Picture
    30 on at

    Yes, I understand your idea of how to implement it better, but it is a very long development process. Any other ideas?

  • nmaenpaa Profile Picture
    101,162 Moderator on at

    Hi Roman,

    I don't agree that it's a "very long development process".

    You need to create one new table, new form, new data entity. This should be perhaps a couple of hours of pure development work.

    Then you need to develop the logic for manipulating the data. This you would need anyway, right?

    Yes, I have other idea which I already suggested: fix the data already before it's imported.

  • Verified answer
    Pasha Rybachok Profile Picture
    30 on at

    Hi, Roman,

    Also you can insert your logic to static method postGetStagingData on dataEntity, where you can modify records witch depending on Execution group. See example in CustCustomerV3Entity.

  • Roman Konrad Profile Picture
    30 on at

    Thanks, this is exactly what I looking for!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans