You’re offline. This is a read only version of the page.
Announcements
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 -
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.
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.
Account structure is same in this case, now how do we include the dimensions for 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.
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?
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.
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.
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?
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).
#1
André Arnaud de Cal...
294,118
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
