Set based operations on data entities in Microsoft Dynamics 365 Finance and Operations

Set based operations on data entities in Microsoft Dynamics 365 Finance and Operations

Set based in used  to perform bulk operations more efficiently using record set operations.

Data entity must Support set-based SQL operation

Set based cannot be used on entities using:

Views
Unions
Time-State Enabled
Temporary or TempDB
Mixed SaveDataPerCompany
Fields in AK(Alternate Key) not mapped in entity
Aggregations
Composite Data Sources
Joins other than inner and outer join