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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Enable Set-Based Processing for a Custom Data Entity

(0) ShareShare
ReportReport
Posted on by 256

We are setting up consolidation and elimination in D365 Finance and Operations and would appreciate guidance from anyone who has implemented this.

Scenario

1. Source legal entities: IND and BNG.
2. Main account: 710720.
3. Transactions are posted to this account with the financial dimension Site carrying values A and B in both entities.
4. A separate consolidation legal entity has been set up.

Requirement

We want to consolidate main account 710720 from both source entities into the consolidation entity. Once consolidation is complete, we need to eliminate intercompany entries posted to this account.

Questions

1. What filtering options are available when defining elimination rules in D365? Specifically, can elimination rules be scoped by main account, by financial dimension values, or by a combination of both?
2. Is filtering on financial dimensions the recommended approach for identifying entries to be eliminated, or is there a more appropriate method in standard functionality?
3. We do not currently maintain a separate financial dimension to identify intercompany transactions. Is introducing such a dimension the standard recommended practice for elimination purposes?
4. Is using dedicated intercompany main accounts an alternative to introducing a new dimension, and if so, which approach has worked better in practice?
 

Categories:
  • Verified answer
    Adis Profile Picture
    7,015 Super User 2026 Season 2 on at

    Hi,

    Have you checked out the following Learn article:

    Optimize data migration for finance and operations apps - Finance & Operations | Dynamics 365 | Microsoft Learn

     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • Suggested answer
    Subra Profile Picture
    2,663 Super User 2026 Season 2 on at

    Hi @CU29091230-0 

    please enable the set based operation processing colum for your custom data entity and you can look for the standard entity how MS implemented the set based operation.

    Kinldy let us know if you have any issues during implementation.

    Thanks,
    Subra

    If this helped, please mark it as "Verified" for others facing the same issue

  • CU29091230-0 Profile Picture
    256 on at

    Hi Subra, 

     

    Could you please clarify how the Set-Based Processing option becomes available for a custom data entity in D365FO? 

     

    Do I need to create or configure it manually, or does it appear automatically based on a specific property or configuration?

     

     

    Pls advise, thanks 

  • Suggested answer
    Subra Profile Picture
    2,663 Super User 2026 Season 2 on at

    Hi @CU29091230-0 

    Yes, it's available for custom data entity and you can enable the same using supportsetbasedoperations properties in the data entity.

    Thanks,
    Subra

    If this helped, please mark it as "Verified" for others facing the same issue

  • CU29091230-0 Profile Picture
    256 on at

    Hi Subra,..

     

    I am still unable to see the Set-Based Processing column for my custom data entity in D365FO.

     

     

    Could you please clarify whether I need to set the Supports Set-Based SQL Operations property to Yes in order to make this column available, or is there any other configuration required?

     

    Pls advise, thanks 

  • Subra Profile Picture
    2,663 Super User 2026 Season 2 on at

    Hi @CU29091230-0 

    I hope there won't be any new column like Set based processing in your custom data entity.

    If the you want to use a entity as set based operation entity like updating multiple records instead of row by row. you can enable the Supports Set-Based SQL Operations property to Yes.

    Thanks,
    Subra

    If this helped, please mark it as "Verified" for others facing the same issue

  • CU29091230-0 Profile Picture
    256 on at

    Are you sure Subra…

  • Subra Profile Picture
    2,663 Super User 2026 Season 2 on at

    Hi @CU29091230-0 

    Are you referrring the below column in the data entities list?

  • Suggested answer
    Anthony Blake Profile Picture
    3,317 Super User 2026 Season 2 on at

    hi @CU29091230-0 

     

    From the Data management workspace, open the data entities tile.

    Hit edit, and check the set-based box: 

     

    Note this setting is environment-wide.

     

    Anthony

     

     

     

  • CU29091230-0 Profile Picture
    256 on at

    Yes Subra, Pls advise thanks

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 264 Super User 2026 Season 2

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 219

#3
Subra Profile Picture

Subra 164 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans