Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Financial Reporting mu...
Finance | Project Operations, Human Resources, ...
Suggested answer

Financial Reporting multiple legal entity summary by dimensions

(0) ShareShare
ReportReport
Posted on by Shijith.cxg 7

Hi,

We have more than 10 legal entities that using same chart of account, financial dimension set (and same FD values) and same reporting currency.

I need to create a FR report where i need to show data summarized across the legal entities by Main account [sum of all legal entities reporting currency], then by Business unit, Department, cost center etc.

I created a reporting row definition contains all P&L accounts, tree definition with all required legal entities and column definition with reporting unit as summary. 

It works fine, however we need to drill down to mainaccount-BU-Dpt-CC. It not doing so. It shows  mainaccount-BU-Dpt-CC under individual legal entity level only. 

How to achieve this in summary level.

We have same chart of accounts and financial dimension values across the companies.

Regards

shijith

  • sathms@gmail.com Profile Picture
    sathms@gmail.com 12 on at
    Financial Reporting multiple legal entity summary by dimensions
    Hi Shijith 
     
    Did you find the solution for this issue. we are looking for consolidate at transaction level with FD. 
     
    Normally all reports would be generated with three levels, Frist Financial , Second Accounting & Third Transaction. 
     
    As we experiment , the consolidation works at Frist two levels but transaction consolidation with financial dimension is not working. 
     
    Thanks
    Sathish 
  • Shijith.cxg Profile Picture
    Shijith.cxg 7 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Dear Suzan Salai,

    You are right, summary was specified in reporting unit, to get totals. I was experimenting different reporting tree options. So removed to test something.

    Regards

    Shijith  

  • Suzan Salai Profile Picture
    Suzan Salai 50 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Hi,

    I'm not quite sure how you expect the report to look like. But if you want to see all the entities on the first page of the report, you need to select the enities on the line 'Reporting unit' in the column definition. If you double click there, you should be able to select legal entities.

    BR

    Suzan

  • Shijith.cxg Profile Picture
    Shijith.cxg 7 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Hi Suzan Salai,

    I have columns for each month. We need to aggregate data monthly.

    And in Reporting tree we have legal entities with Financial dimension set. Screens attached.

    pastedimage1683909678875v1.png

    pastedimage1683909876093v3.png

  • Shijith.cxg Profile Picture
    Shijith.cxg 7 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Thanks Frank E. Hamelly,

    We are trying to eliminate a consolidation run by using MR reports.

    In reporting tree we are using legal entities. Hence it creates separate tabs on export.

    Is there a way to create a report across entities just using FDs.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,220 Super User 2024 Season 2 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    That's not how Financial reporter works.  By default, each business unit in your reporting tree will export to Excel in a separate tab.  There's no way to change this.

  • Suzan Salai Profile Picture
    Suzan Salai 50 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Ok on column definition, do you have a column for each legal entity? You should be able to them on the front page. Can you insert a screen shot of your column definition?

  • Shijith.cxg Profile Picture
    Shijith.cxg 7 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Dear Suzan Salai,

    Thanks for the response. 

    I am choosing to drill down up to transaction level. That works fine; however, each legal entity data is appearing in different pages.

    I like to get all data in one sheet as we have more than 10 legal entities.

    Regards

    Shijith

  • Suzan Salai Profile Picture
    Suzan Salai 50 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Hi,

    On the report definition, there is a field with drop down list, where you can choose in which level the report should show.

  • Shijith.cxg Profile Picture
    Shijith.cxg 7 on at
    RE: Financial Reporting multiple legal entity summary by dimensions

    Dear Hana,

    Thanks for the reply.

    I tried the drill down option and exporting to excel as well, it has all the data but places to separate sheet by legal entities.

    We need the following report in single sheet.

    Main account, BU,  Dpt ,   CC, amount

    Amount should be total of the posting in the main account across all the legal entities mentioned in reporting tree. We don't need to bifurcate the amount by legal entities. All legal entities use same COA and FDs.

    I thought it is simple however proves to be a challenge.

    Regards

    Shijith

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans