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

Community site session details

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

Financial analysis overview - current company and all companies not displaying data

(0) ShareShare
ReportReport
Posted on by

Hello everyone, 

We want to start using the Financial analysis overview for our operating companies in D365, but we have missing data.

After some analysis, I believe the problem is with the main account categories we have defined for our main accounts. We have a lot of out of the box, custom main account categories created by ourselves assigned to our main accounts which are not part of the calculations displayed in the PoweBI dashboard content. I found that the following entities are used as the basis of the Financial Performance: GeneralLedgerActivities and BidgetActivities.

Is there some way to see which main account categories are used in the calculations, so we can see how to proceed further with this?

We have a lot of Financial reports based on the existing main account categories as they are currently in the system. 

I checked the option link main accounts, but if we use option Link all it changes the main account category to most of the accounts and will cause issues with our existing Financial reports. 

Any advice is highly appreciated.

Regards, 

Teodora

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: Financial analysis overview - current company and all companies not displaying data

    Hi Thang,

    Thank you very much for your response, I appreciate it.

    Now that I am 100% sure for the reason behind this I can report back to the business side and discuss possible solutions.

    Have a nice day.

    Regards,

    Teodora

  • Verified answer
    ThangNguyen Profile Picture
    184 on at
    RE: Financial analysis overview - current company and all companies not displaying data

    Hi TeodoraMK,

    You are correct in identifying the main problem is the custom main account categories. (Assume that you have refreshed correctly "Entity store")

    Main account categories are used to calculate in almost pages in Financial overview analysis dashboard. The system used field "Reference ID" in Main account categories form (You can insert column to see this field)  to calculate in formula.  For more technical details, you can log in to LCS > Projects > Asset library > Power BI report model, download Power BI files and then explore it.

    In my opinion, we should use standard main account categories (about 55 categories), don't create custom main account categories if you want to utilize standard dashboard.

    For your case, it would be better if you can change the way to get data to other financial reports in stead of using main account categories. If impossible, you have to customize Financial analysis overview power BI embedded (Not recommend)

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 745 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 597 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans