In our previous blog post, we briefly touched upon reporting with Financial Reports. Financial Reports are traditional financial statements like P&L, Balance sheet, etc. It’s part of Dynamics 365 Business Central and if you have a license, you can run them and create them, export them to Excel and share that with your team. Financial […]
What’s New with Reporting and Analytics in Business Central
Last month, Tensoft hosted a webinar on “What’s New in Microsoft Dynamics 365 Business Central”. I covered some of the new features in the latest release related to reporting, user interface, multi-company management, etc. Below are some of the updates associated with reporting and analytics that you may find useful: Analyze Data in Lists and […]
Financial Reporting in Microsoft Dynamics 365 Business Central
In Microsoft Dynamics 365 Business Central, the financial reports are available in a nice almost printable format especially if you know how to export it and refresh it with your own formatting. But sometimes, you need the raw data quickly in a Pivot Table format or a Power BI refreshable report for data analysis. To […]
New Feature in Business Central 2023 Wave 1 Release: Analyze View
Of all the new features in the latest release of Microsoft Dynamics 365 Business Central, Analyze View is probably my favorite one. With this feature, you can analyze data from list pages within the application itself, essentially turning it into a pivot table. To do something like this in the past, you would have to […]
Financial Statements in Microsoft Power BI from Business Central
In Dynamics 365 Business Central, under Web Services, you’ll see the list of the APIs that are available. There are two different data sources – page type and query type – for the same type of information. You may want to try them both as some of the fields may be different. If you don’t […]