Finance | Project Operations, Human Resources, ...

Cross Company Data Sharing

(0) Share

Report

Posted on by Saurabh_star

Hi Everyone,

Looking for some quick guidance and real time experience related to Cross Company Data Sharing if someone has already implemented it before. Client is upgrading from Ax 2012 and there is a long list of tables which they were using as part of virtual company. These tables need to be shared among 500+ legal entities.

Issue 1: Some field in table are not sharable. Mainly the Dimension fields in most of the tables are not sharable. Microsoft documents also mentions about this limitation. But what is the workaround if it's a must have requirement from the client, is there a custom development that can be done? Has anyone successfully implemented this?

Issue 2: Some tables are completely not sharable through Cross Company Data Sharing mainly because of 2 kind of issues -

No unique Index
Table xyz is a Group table as specified by the table group and may not be shared unless its Data Sharing Type is Duplicate

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,637 Super User 2025 Season 2 on at

Like (0)

Report

RE: Cross Company Data Sharing

Hi Saurabh,

Regarding the both issue, you can evaluate to use Data Management Framework and copy into legal entity functions.

It should be taken into consideration that you have not same behavior of Cross-Company Data Sharing (e.g. Table is not shared) while you can copy data from source companies to target companies (insert + update).

Was this reply helpful? Yes No
Saurabh_star on at

Like (0)

Report

RE: Cross Company Data Sharing

Data management framework will enable you to copy the data at the time of fresh import, but what about the scenarios post go live when user starts updating the data in different companies and expect that to be replicated in all the companies?

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report

RE: Cross Company Data Sharing

The requirement can be achieved from backend. You can add a new button which opens a dialog box in which you should have some parameter like from which vendor to which vendor. Also the countries where these need to be added. Once that is selected and clicked on ok a job should run which will insert these new records in other legal entities.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (1)

Report

RE: Cross Company Data Sharing

I've been on projects where we got permission from MSFT to share the financial dimensions on vendors, which required a bit of custom code. Microsoft's caveat was that the dimension values had to be the same across all legal entities, which they were.

Was this reply helpful? Yes No
Saurabh_star on at

Like (0)

Report

RE: Cross Company Data Sharing

Can you please share some more insight about this? were you able to include the dimensions as part of the cross company data sharing after the code change or you had to build a separate functionality to sync the financial dimensions?

Was this reply helpful? Yes No
André Arnaud de Cal... 299,897 Super User 2025 Season 2 on at

Like (0)

Report

RE: Cross Company Data Sharing

Hi Saurabh,

When you include the financial dimensions, the account structures for each ledger should be the same. A company with 2 dimensions and another with 3 dimensions will have different values for the dimension combination.

When there are differences in account structures, you can use the data management framework like mentioned above. To keep data in sync, you should then perform the action regularly.

Was this reply helpful? Yes No
Saurabh_star on at

Like (0)

Report

RE: Cross Company Data Sharing

Account structure is same in this case, now how do we include the dimensions for sharing?

Was this reply helpful? Yes No
Saurabh_star on at

Like (0)

Report

RE: Cross Company Data Sharing

looking for some direction from all the experts here... I do have some dirty customizations in mind but before I go that route I would really want to hear some tried and tested solutions that some fellow mates have implemented.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,897 Super User 2025 Season 2 on at

Like (0)

Report

RE: Cross Company Data Sharing

HI Saurabh,

I have no experience in changing the cross-company data sharing to allow copying the financial dimensions. Frank mentioned they had some experience. Not sure if he is able to share some hints. Otherwise, you would need to reverse engineer the current feature and check where to hook in to be able to include the financial dimensions.

Was this reply helpful? Yes No