Dynamics Community Forum Thread Details

How to report using 'Default consolidated accounts' instead of the Main accounts?

Hello, I have a client who has mapped all his main accounts to certain default consolidation accounts in AX as

Example:

main ac 1

default consolidated ac1

main ac 2

default consolidated ac1

main ac 3

default consolidated ac1

main ac 4

default consolidated ac2

main ac 5

default consolidated ac2

main ac 6

default consolidated ac3

And wants me to generate reports from Management Reporter using these consolidated accounts instead of using the actual main accounts for each company. Can some one help me how I can make Management Reporter to pick balances from these default consolidated accounts directly instead of having to add up all the main accounts related to that each particular default consolidated account.

Also, we have only one chart of accounts across all the companies.

Any help appreciated... and let me know if you need any more info.

Thanks.