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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Composite data entities
Finance | Project Operations, Human Resources, ...
Answered

Composite data entities

(1) ShareShare
ReportReport
Posted on by DP-04060556-0 105
Hi experts,
Recently I has an issue whereby users can not use "Open in excel" for composites data entities for users hold "Data migration admin" role. They can access Composites data entities from Data management workspace but cannot see those entities from "Open in excel" menu. please advise.
 
Daniel
I have the same question (0)
  • Layan Jwei Profile Picture
    Layan Jwei 8,124 Super User 2025 Season 2 on at
    Hi,
     
    What are the composite entities that you can't see? Are they standard or custom? And if they are custom, did you create privileges for them and assigned them to the data migration role? If not, then make sure the role has access to those entities
     
    Also can you see them using a different role?
     
     
  • DP-04060556-0 Profile Picture
    DP-04060556-0 105 on at
    Hi Layan Jwei,
    the data entity that users cannot see is Inventory adjustment journal headers and lines V2, however user can see Inventory movement journal headers and lines V4 from "Open in excel". it is a standard items and I did not create new privilege for it. I had try to assigned "Data migration administrator" , "IT manager" to users but unsuccessful.
     
    Daniel
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,994 Most Valuable Professional on at
    Note that this thread isn't about composite data entities at all.
     
    Composite entities aren't exposed via OData, and because Open in Excel uses OData, they can't be used there either. They're supported in data management only.
     
    Both InventInventoryMovementJournalEntryV4Entity and InventInventoryAdjustmentJournalEntryV2Entity are normal data entities, not composite ones.
     
    Access to InventInventoryAdjustmentJournalEntryV2Entity is granted by two privileges: InventInventoryAdjustmentJournalEntryEntityExport and InventInventoryAdjustmentJournalEntryEntityImport. But it won't work even if you assign them to users, because they have Integration Mode = Data Management, therefore they don't give permissions to OData. You'll have to create new privileges.
  • DP-04060556-0 Profile Picture
    DP-04060556-0 105 on at
     
    yes, you are right. thanks for your advise.
     
    Daniel

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans