The Modern Manufacturer: Keys to Reporting Success

By Anne Kaese | September 15, 2021

anne 2

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

Recommended Reading:

Stoneridge Software Selected for 2022 Microsoft US Partner Award – Dynamics 365 Business Central

Stoneridge Software is honored to be selected as a 2022 Microsoft US (MSUS) Partner Award winner for Dynamics 365 Business […]

Read the Article
6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Organize and Prioritize Your Resources with Dynamics 365 Field Service

As a manager, Dynamics 365 Field Service lets you optimize the use of your employees, their skillsets, and other resources […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!