Dear All,
I have 4 legal entities as different partitions in AX 2012. Now I want to have a consolidated customer statement for these legal entities. Could anyone please help me to solve this issue.
Thanks
Why did you put them to separate partitions if you don’t want them completely isolated?
Beginning stage, they don’t want it. But now they changed mind…So is there any possibility?
Well, they can expect a huge amount of troubles if the core design of their system is wrong. I think the partner made a huge mistake by using four partitions instead of a single partition with four legal entities. What you’re dealing with now was likely coming sooner or later.
Therefore they should consider addressing the cause and migrate companies to a single partition. It’s a bid deal, of course - bugs in fundamental design are always expensive.
Querying data across partitions isn’t complete impossible, but it’s difficult. It’s no surprise - partitions are there for complete isolation, not for sharing.
A better approach may be collecting data from each company and putting them into a table shared across partitions or to an external data warehouse. But you must also be ready for some data cleaning - partitions doesn’t share even basic setup such as the list of countries, therefore data from different partitions may be incompatible (without further effort).