web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Financial Reports: Consolidation account

(0) ShareShare
ReportReport
Posted on by 149

Hello,

I wouldl like to use the "default consolidation account" stored with each main account to prepare reports and aggregate data in individual lines in the financial report. It does not appear as a dimension which can be selected/filtered. Is there any other way?

Many thanks in advance.

Regards,

I have the same question (0)
  • Juanse Profile Picture
    660 on at

    Hello,

    In the financial reporting application you can group main accounts using the account categories or simply adding different account ranges. You can also use account sets within the financial reporting application.

    The default consolidation account you refer to is used in separate consolidation method, apart from financial reporting method.

    regards,

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    301,171 Super User 2025 Season 2 on at

    Hi DynamicsHampshire,

    I had a customer having a similar requirement before to report directly on consolidation accounts. You can create a consolidation legal entity; consolidate into this company an then do the reporting from this consolidation company as workaround.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello DynamicsHampshire,

    The default consolidation account should be available as an attribute in the financial report designer.

    You can thus use this field for creating your financial reports.

    The 'disadvantage' of doing that is that the selection and setup of attributes in the financial report designer takes some time.

    An alternative workaround is using a separate findim that you fix for each of your ledger accounts; then you can create any kind of report that you want in an easy and straightforward way.

    Best regards,

    Ludwig

  • DynamicsHampshire Profile Picture
    149 on at

    Superb. thank you very much.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans