Finance | Project Operations, Human Resources, ...

Global data entities vs company-specific entities

(2) Share

Report

Posted on by Afonso Rodrigues

215

Hi all

I am constructing a Data Migration Strategy to D365F&O. For that, I am most interested in understanding which Data Entities are Global (shared across LE's) or Company Specific (specific for each LE).

From my investigation, I was able to understand that there is no easy way to functionally retrieve this information directly from D365. However, there is a property of each staging table that let us know whether that table is Global or Specific. The property is "SaveDataPerCompany" that could be either Yes or No. If = Yes, it means that the table is company specific.

However, I believe there is still no easy way to get this information. Besides that, I am not a technical user which makes it even harder.

Having this said, can any of you help me on how to get this information? I try to find if this information was available on the Microsoft Documentation but I believe there are no such information within the Microsoft Documentation.

Thank you all in advance.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Vishal Tiwari 393 on at

Like (0)

Report
MD365F&O | Global Entities vs Company Specific Entities

Hi, Have you looked into the 'Target entity' (which map to table) under DM > Data entities.

Or if you don't get the desired result, I'd recommend asking a developer to run SQL/X++ script.

Quick example script to retrieve the SaveDataPerCompany property from the metadata using X++(its not complete code, but you may need to tweak little)

DictTable dictTable;
TableId tableId;
int tableCount;

Dictionary dictionary = new Dictionary(); tableCount=dictionary.tableCnt()

for (tableId = 1; tableId <= tableCount; tableId++)
{
dictTable = new DictTable(tableId);

if (dictTable && dictTable.isDataEntity())
{
str tableName = dictTable.name();
boolean isCompanySpecific = dictTable.dataPrCompany();

info(strFmt("Table: %1 - %2", tableName, isCompanySpecific ? "Company-Specific" : "Global"));
}
}

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 299,399 Super User 2025 Season 2 on at

Like (0)

Report

MD365F&O | Global Entities vs Company Specific Entities

Hi Afonso,

Knowing what tables are global or company specific is part of having experience with the product. It is indeed managed with a property Save data per company.

You are correct that getting this information is hard. You can get a list of tables using the deprecated Size of company accounts report. You can run this report twice. Once is a normal legal entity and once in the DAT company. The tables listed on the report for the DAT company are global.
Here is a blog where you can read how to run the report: Help! Where is the Size of company accounts report in AX7?

If this is not helping you enough, you can reach out to a developer or list some table names so we can help you.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Global data entities vs company-specific entities

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Global data entities vs company-specific entities

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates