The Modern Manufacturer: Keys to Reporting Success

by | Updated September 16, 2021 | Dynamics 365 for Finance and Operations, Manufacturing

Detailed, accurate reports are key to evaluating success, accurate budgeting, understanding cash flow, and much more. Today’s leading manufacturers are generating board quality reports with real-time data to make better business decisions and understand financial standing. Power BI tools and underlying low-code or no-code solutions in the system can be used to generate good-looking reports, interactive views, and KPI-type metrics.

Why Online Reporting?

Online reporting is needed for assessment, data interaction, and exception management. Data in ERP systems, which is predominantly forward-looking, can be used to plan for the future based on assessment and exception management. Insights from a Power BI entity store drive answers to important business questions.

Insights and BI

Many built-in options are available to users with a Power BI license. Microsoft has considered what end users value, and over time, the number of templates and formats has increased and become more expansive across the system. Microsoft is moving toward a low-code / no –code environment, meaning many functionalities do not have to be development-enabled.

Filtering capabilities streamline inputs, outputs, and outcomes so they become interactive.

External data sources can be linked through Power Query for Excel to expand out-of-the-box reports to include additional reports, insights, and databases sitting outside of your system.

What Data is Available for Entity Stores?

The data for financial analysis is pulled from the entity store (System administration > Setup > Entity store). The following data is currently available:

  • Assets
  • Budgets
  • Cash
  • Inventory KPI
  • DOM (Distributed Order Management)
  • GL (General Ledger)
  • Projects
  • Purchase cube
  • Production cube
  • Sales cube; retail cube
  • Expenses


A recurring batch can be defined to regularly update data in entities. Select the time and frequency of entity updates carefully as each entity is completely rebuilt during an update. FinancialReportingTransactionData is the primary entity used for financial statements and may be updated more frequently than other entities. Although financial data is typically updated more often, updates are customizable to your situation.

In terms of security, data on embedded Power BI reports are not currently limited to legal entities that the user has access to. Therefore, duties in security setup will control embedded Power BI reports.

Operational Workspaces

Operational workspaces in Dynamics 365 combine traditional workspace tools such as lists and tiles to configure a splash screen with data you wish to track. If you haven’t played around with workspaces in D365 yet, please do. They are becoming increasingly functional and task-oriented.

Dashboard in Dynamics 365

Power BI Workspaces

Power BI workspaces offer seamlessly integrated interactive reports. They are highly graphical and can be customized with data that is not inside the system. The human brain is wired to respond to infographics and visuals, so this is a much more pleasing work experience for many people. Visuals are tablet-enabled, phone-enabled, as well as traditional desktop-enabled. You can see cause and effect and perform simple what-if operations without leaving this workspace.

Power BI dashboard with graphics, including a map and bar chart

Where Are They?

You may be asking, where are some of these dashboards right now? Functions with the arrow symbol (see below) in Dynamics 365 are Power BI enabled. Every one to two releases there is an addition or expansion to these workspaces and splash screens.

Where to find dashboards

Dashboards are putting power back in the hands of people who modify, change, interrogate, filter, and look at data in different ways and with different eyes. Users get a story from the data instead of sorting through pages and pages of an Excel spreadsheet.

View our Microsoft technology solutions for the modern manufacturer infographic and visit the manufacturing section of the Stoneridge Software Blog to learn more about modern manufacturing.




Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

13oct12:00 pm12:30 pmWave 2 Release – What’s Coming for Dynamics 365 Sales and Customer Service

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference


04nov11:00 am12:00 pmConfab LIVE with Stoneridge - Challenging the Development Paradigm

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!