Reporting in Microsoft Dynamics F&O

     Today, I would like to share the reporting possibilities of D365 FO. There are various ways to report;

1. SSRS: Most of the SSRS reports are in the system ready to be used. But if there is a need to add a new report or a field/grouping etc to the current report, there is a need for a developer. This kind of reports are mostly used for internal needs and maybe sent to 3 rd parties in a proper shape.

2. Embedded Power BI: There are Power BI reports that are already created in the system and embedded in the modules. These reports are easy to use and is more focused on the visual. 

3. Power BI: Power BI reports can be created with the Power BI desktop application and easy to manage.

4. Management Reporter: Management Reporter tool is a user efficient tool that users can create reports  from COA, transactions, budget and dimensions. Users can create their own reports or use/change the ones that are already offered in the system like audit trail, balance sheet, cash flow etc.

5. Inquiries: These are forms that have data shown in grid view and can be exported to Excel. To find data through filtering options make it user friendly. So I use this functionality most common rather than the prepare a static report.

6. Excel: You can export data to Excel via Data Migration tools and can create the reports through. 

7: Electronic Reporting (ER): This is the most out of imagine tool which can be used for reporting with none or low code methodology. There is already set up reports but standard ones can be changed or new added.

8: Word Templates: This is not a reporting tool but for some documents can be managed as an out put to be sent to customers etc with the interaction of the user.