News and Announcements icon

Dynamics 365 CommunityForums Finance forum Customisable Reports f...

Finance forum

Suggested answer

Customisable Reports for Operational and Financial Metrics

(1) Share

Report

Report

Posted on by SavvasD

8

Hi Everyone,

We have a deployment of D365 Finance and Operations and our finance department requires bespoke reports for their monthly reporting duties. The problem is we need to be able to combine data from GL and AR and Sales modules. Is this even possible?

I have thought about using the Excel Dynamics Add-in but how do I know what tables/fields to draw from? Can this even be done in Dynamics without development?

Thanks in advance.

Kind regards,
Savvas

Categories:

Development / Customization / SDK

BI and Analytics

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

BillurSamdancioglu 14,220 Most Valuable Professional on at

Like (0)

Report

Customisable Reports for Operational and Financial Metrics

Hi,

In addition to Frank you may use;

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/bi-reporting-home-page?context=%2Fdynamics365%2Fcontext%2Ffinance
Suggested answer

Frank Hamelly | MVP... 3,928 Super User 2024 Season 2 on at

Like (1)

Report

Customisable Reports for Operational and Financial Metrics

Excel Add-In is only for transaction processing. You need to consider Power BI for your requirements, which requires Data Lake configuration, soon to be superseded by Fabric. Also, have a look at Business Performance Analytics, which was recently released. It's in its infancy but might work for you. What is Business performance analytics - Finance | Dynamics 365 | Microsoft Learn

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2

Martin Dráb 228,651 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans