Hi, Readers.
Dynamics 365 Business Central 2025 wave 1 (BC26) is generally available. More details: General Available: Dynamics 365 Business Central 2025 release wave 1 (BC26).
And minor update 26.2 for Business Central 2025 release wave 1 has been released for Business Central online. More details: Cumulative Update Summary for Microsoft Dynamics 365 Business Central (June, 2025)
I will continue to test and share some new features that I hope will be helpful.
Use enhanced analytics for manufacturing (updated Power BI app):
The improvements in reporting and analytics for the manufacturing area can help your business track new KPIs and scenarios in Power BI.
We’ve significantly improved reporting and analytics for manufacturing in Power BI, where we have added new reports
https://learn.microsoft.com/en-us/dynamics365/release-plan/2025wave1/smb/dynamics365-business-central/use-enhanced-analytics-manufacturing?wt.mc_id=DX-MVP-5004336
It’s easy to get insights into your Business Central data with Power BI – a data visualization system from Microsoft. Power BI retrieves Business Central data so that you can build dashboards and reports based on that data. Power BI provides a flexible alternative to reports built in Business Central, enabling you drill down and customize the visualization, and even merge data from different companies in Business Central. Some Power BI reports can also be embedded in Business Central and viewed without leaving the system. More complex dashboards are better experienced from the Power BI web site.
In Business Central 2024 wave 2 (BC25.1), Microsoft added a lot of new reports for finance, sales, purchasing, inventory, manufacturing, and projects. More details: Business Central 2024 wave 2 (BC25.1): Use embedded Power BI reports out of the box (In-client Power BI reports)
With this release(BC26.2), Microsoft has significantly improved reporting and analytics for manufacturing in Power BI.
Manufacturing Power BI app for Business Central (26.2):
We can already install this new Power BI app.
Done.
PS: You can quickly locate the Manufacturing reports by the following method:
Alternatively, you can switch to the Manufacturing Manager role and then find them directly in the role center.
Let’s look at what’s improved this time.
- Work Center Statistics highlights the work center scrap percent, and lists work center output and work center scrap.
About Work Center Statistics
View your work center statistics and explore detailed metrics on total and effective capacity, expected and actual efficiency, actual need, cost, and allocated time.
- Machine Center Statistics highlights the machine center scrap percent, and lists machine center output and machine center scrap.
About Machine Center Statistics
View your machine center statistics and discover detailed metrics on total and effective capacity, expected and actual efficiency, scrap rates, and output.
- Prod Order List highlights total actual cost with variances to expected and standard costs, quantities and document numbers, source numbers, and production order routing number.
About Prod. Order – List
View all production orders and analyze detailed production order information, including status, due date, and planned versus finished quantities.
- Prod Order Routing Gantt visualizes routing line timelines as operation durations.
About Prod. Order Routings Gantt
Visualize the schedules of each work and machine center with a Gantt chart, detailing production order routing lines. Highlight the duration of each production order on a timeline for better planning and management.
- Prod Order WIP visualizes WIP value over time and lists production order level details such as beginning balance value, consumption, capacity, output, and ending balance value.
About Production Order WIP
View inventory valuation for selected production orders in your WIP inventory. The report also shows information about the value of consumption, capacity usage and output in WIP.
- Production Overview focuses on current or unfinished production orders.
About Production Order Overview
The Production Order Overview dashboard presents key metrics and charts including a breakdown of total actual costs, the number of production orders by status, and the completion percentages for each source item.
Microsoft also updated some existing reports:
- Current Utilization is marked for deprecation.
About Current Utilization
View the current Weeks Utilisation % by comparing Capacity Used to Available Capacity in Hours. View all or some Work Centres to measure throughput and efficiency.
- Historical Utilization is marked for deprecation.
About Historical Utilization
View the historical Utilisation % by comparing Capacity Used vs Available Capacity in Hours viewed over a timeline you can define to see trends. View all or some Work Centres.
- Work Center Load has visual layout updates. We added a Work Center Load Details matrix that breaks down work center statistics by work center, source number, and production order.
About Machine Center Load
View your machine center load and usage, including allocated time and availability for each machine center, helping you optimize resource allocation and improve operational efficiency.
- Allocated Hours is now called Allocated Time, and has some visual layout updates:
- Allocated time is now visualized by work center, source number, work center type, and production order status.
- Allocated Time Details matrix now displays allocated time by source number and production order.
About Allocated Hours
View the number of hours remaining for production allocated to each Work Centre in a specified period. Allows you to determine if a Work Centre is under or overloaded and requires rescheduling.
- Expected Capacity Need has visual layout updates:
- Expected capacity need is now visualized by work center, machine center, and source number.
- Expected Capacity Need Variance matrix now displays Production Order Expected Capacity need vs. Production Order Actual Capacity Need, and the deviation as a percent.
About Expected Capacity Need
View the total hours scheduled to be performed for each Work Centre Group and/or Work Centre broken down by production order status and production order to analyze your requirement on factory resources.
- Finished Production Order Breakdown highlights the total actual cost with variances to expected and standard cost. Visual layout updates:
- Actual costs breakdown by source number is visualized as a stacked bar chart with cost components as segments.
- Finished production order breakdown details planned and finished quantities as well as actual cost components by production order.
About Finished Prod. Order Breakdown
View Expected Quantities and Cost vs Actual Quantities and Costs over time, analyze the detail per item and drill down to the Production Order to track where variances are occurring.
- Consumption Variance highlights material cost with variances to expected and standard material costs. Visual layout updates:
- Expected and standard material cost deviation percentage by source number are visualized as bar charts.
- Consumption Variance Details matrix lists actual, expected, and standard material costs with variances by production order.
About Consumption Variance
View your consumption cost variance % viewed over a timeline you can define to see trends. Analyze by each production order and filter by Work Centre to see the detail behind the overall percentages.
- Capacity Variance highlights capacity cost with variances to expected and standard capacity cost. Visual layout updates:
- Expected capacity cost deviation percentage by source number is visualized as a bar chart.
- Capacity Variance Details matrix lists the standard and expected capacity cost variances as well as the production order capacity need variance.
About Capacity Variance
View your capacity cost variance % viewed over a timeline you can define to see trends. Analyze by each production order and filter by Work Centre to see the detail behind the overall percentages.
- Average Production Times has visual layout updates:
- Average production time per finished quantity is visualized by work center and by source number.
- Average Production Time Details matrix lists actual time used, finished quantity, and average production time per unit by source number and production order.
About Average Productions Times
View the average time spent for Setup, Run and Stop times per unit for each manufactured Item. Expand to see the times for each production order to determine why fluctuations occurred.
- Released Production Orders highlights total actual cost with variances to expected and standard costs. Visual layout updates:
- Number of production orders by source number is visualized as a bar chart.
- Completion Ratio pie chart visualizes the relationship between finished quantity and remaining quantity.
- Released Production Order Details lists key details about released production orders such as starting, ending and due dates, planned vs. finished quantities and document number, source number, and production order routing number.
About Released Production Orders
View how your released production orders are tracking by comparing Expected Quantity vs Finished Quantity
- Production Scrap highlights Production Order Scrap % and lists production order finished and scrap quantities. Visual layout updates:
- Scrap quantity over time visualized as a line chart displays scrap quantity trends across time.
- Work and machine center scrap KPIs are listed in a central card.
- Scrap percentage by production order is visualized as a bar chart.
- Scrap quantity by scrap code is visualized as a bar chart.
- Scrap quantity vs. expected scrap quantity by source number is visualized as a comparative bar chart.
About Production Scrap
View your scrap quantities over a timeline you can define to see trends. Analyze further by Scrap Code, Location, Item Categories and by filtering for specific items.
Great! Power BI reports solve many limitations of BC existing reports. Go and try it out.
PS:
1. What’s new: Manufacturing analytics (updated Power BI app)
2. You can still install the older version: Manufacturing Power BI app for Business Central (for version 25.2)
3. Microsoft also added a new Manufacturing analytics section in the documentation. More details: Manufacturing Power BI app
4. Install Power BI apps for Business Central
END
Hope this will help.
Thanks for reading.
ZHU
コメント