Armanino Blog

Cross-Company Data Sharing Is Key for Multi-Entity Organizations

April 30, 2019

Dynamics 365 for Finance and Operations (D365 F&O) is designed to be flexible. It allows different legal entities to have different rules and setups to support their often unique business processes. Each company may have its own set of lists of values, and default table values can be maintained and updated separately. Many companies, however, look to standardize processes and normalize data when they take on a new ERP implementation. Cross-company data sharing functionality can be helpful when multiple companies will be using the same values and want to maintain a single set of values without duplicate maintenance. Like the deprecated virtual companies' function, the tables can be set up to share values across multiple companies. They function like "global tables,"such as the procurement categories table, where a change to a value in one company is immediately seen in all.

When to use shared tables

Shared tables are associated to share groups. You should create the share groups for the combinations of companies with common data uses and/or table values. For example, a Sales share group may be used for all the sales-related "global tables," such as the return reason groups, return reason codes and ship codes. An Item master share group may be created for tables such as product line and product family. A share group may be created for a subset of companies that have shared values because of localization and/or regional requirements.

Enabling Cross-Company Data Sharing:

The table shares are defined at System administration > Setup > Configure cross-company data sharing. The table sharing can be defined for selected companies and tables in just a few steps.

  1. Create a sharing group
  2. Data Sharing
  3. Add the tables that will be shared to the group
  4. Add the companies that will be sharing the table values
  5. Enable cross-company sharing using the Enable function on the action pane
  6. Data Sharing 2

During the enabling process, the share groups can be validated using the Find sharing issues function.

The use of cross-company data sharing may develop or change with different business processes and requirements. Share groups may be updated if they need to be amended as business process requirements. New companies or tables may be added or removed. Updates are made by disabling the share group, making the table or company changes, and re-enabling the share group.

Find more helpful tips and tricks for Dynamics 365 for Finance & Operations (D365 F&O) throughout Armanino's Dynamics resources or contact our team to learn more about D365 for your company.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
General Contractor Trends to Consider in 2022 Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Women in Nonprofit Leadership Panel
Aspiring nonprofit leaders should hear the insightful stories of these women industry leaders to empower their journeys.

December 14, 2021 | 10:00 AM - 11:00 AM PT
The Evolution of Gaming Companies
From seed-funding to acquisition, position your gaming company for success.

December 9, 2021 | 01:00 PM - 02:00 PM PT