Home / General / Business Central Reporting for Manufacturers: Gaps, Costs and Fixes
CONTENTS

Social Shares

Business Central Reporting for Manufacturers: Gaps, Costs and Fixes

TL;DR

Business Central reporting gives manufacturers hundreds of standard reports, but none are built around how a specific business measures customer profitability, margin trends or production performance. Custom fields and processes rarely appear, so teams rebuild the same numbers in Excel every month. Custom Business Central reports and Power BI dashboards close that gap.    

Business Central native reporting is missing three things manufacturers need most: reports that reflect their own customizations, KPIs defined the way their business measures performance, and automation that removes repeat manual work. Microsoft Learn states that Business Central ships with more than 300 built-in reports. The problem is not the number of reports. It is the fit. 

Most mid-sized manufacturers do not run Business Central out of the box. They add extensions for quality, costing, configure-to-order or EDI. They track customers by channel, products by family and plants by line. Standard reports know none of this. 

So the reporting work moves to Excel. A finance analyst exports four reports, merges them with a pricing file and rebuilds the margin view by hand. A sales manager waits for that file before the weekly review. By the time leadership sees the number, the moment to act on it has often passed. 

This guide covers what native Business Central reporting misses, how those gaps affect CFOs, finance leaders and sales managers, and how customized reporting closes them. 
 
“The most expensive report in a manufacturing company is the one three teams build separately. When finance, sales and operations each calculate gross margin their own way, leadership spends the meeting debating numbers instead of acting on them. Custom Business Central reporting fixes the definition first, then the dashboard.” 
– Kamal Sharma, Founder & CEO, Addend Analytics 

The Core Gaps in Business Central Native Reporting 

The Business Central reporting limitations manufacturers hit most often fall into three groups. 

1. Too Many Reports, None Built for Your Business 

  • Standard reports are built on the base application, so fields and tables added through extensions often do not appear in them. 
  • Microsoft notes that you can’t modify built-in layouts. You can only create custom layouts on top of them. 
  • Plant-specific processes, such as custom routings, co-products or industry costing rules, are not reflected in generic output. 
  • The result is a long report list that still does not answer the questions leadership asks. 

Microsoft itself acknowledges the gap. Its ad-hoc analysis guidance opens by noting that users sometimes need to analyze data in ways standard reports don’t support. 

2. Your KPI Definitions Are Not Microsoft’s 

Every manufacturer defines its core metrics differently. Native reports apply one generic logic to everyone. 

  • Customer profitability. One company measures it after freight, rebates and returns. Another adds cost-to-serve, such as expedited shipping and small-order handling. 
  • Sales growth. Some leaders want growth by region. Others need it by product family, new versus existing customers, or price versus volume. 
  • Margin trends. Finance may track margin at standard cost, actual cost or landed cost. Each tells a different story. 
  • Manufacturing performance. OEE, scrap, yield and schedule adherence all depend on how the plant counts downtime and good output. 

Even the Manufacturing app in Power BI, which Microsoft lists with 11 reports, uses standard definitions rather than yours. 

3. Manual Work Every Cycle 

  • Teams export to Excel, reformat, reconcile and repeat at every month-end. 
  • Microsoft says Excel layouts suit simpler datasets, while complex calculations work best in Word or RDLC layouts. 
  • Pixel-perfect RDLC changes may need a developer, which creates a queue behind limited internal resources. 
  • Knowledge of how each report is built sits with one or two people. When they are busy or leave, reporting stalls. 

Business Central Reporting Gaps by Area 

The table below maps each Business Central reporting limitation to what manufacturers actually need. 

Reporting area What native reporting gives you What manufacturers need 
Business customizations Base application fields and fixed built-in layouts Reports that include custom fields, extensions and plant processes 
Customer profitability Sales and margin by customer at document level Profit after freight, rebates, returns and cost-to-serve 
Sales growth Period totals and standard comparisons Growth by segment, region, product family and rep against targets 
Margin trends Point-in-time margin per item or document Trend lines showing where margin is eroding and why 
Manufacturing KPIs Production order, capacity and consumption reports OEE, scrap, yield and cost variance on your definitions 
Effort per cycle Run, export to Excel, reformat, reconcile Scheduled refresh and automatic distribution 
Ownership Layout changes routed to a developer Self-service dashboards business users can filter and explore 

Limits of Business Central’s Built-In Analytics 

Business Central does include tools beyond standard reports. Each helps, but none solves the full problem for a growing manufacturer. 

  • Analysis mode and Excel. Useful for quick pivots on one list. Microsoft’s operational limits page notes that Open in Excel, Edit in Excel and Excel layouts are bound by Excel’s own row and column limits. 
  • Out-of-the-box Power BI apps. A strong starting point for finance, sales, inventory and manufacturing. Microsoft has since open-sourced the apps so businesses can change the semantic models to fit their needs, but someone still has to do that modeling work. 
  • Direct connections at scale. The same limits page caps concurrent OData requests per user and returns throttling errors when connections exceed the limit. Heavy reports pulled straight from the ERP can slow down as data grows. 
  • Financial reports. Good for income statements and balance sheets built on G/L accounts. They are less suited to item-level, customer-level or production-level analysis, which is where manufacturers lose margin. 
  • Single-source view. Native tools report on Business Central data. Most manufacturers also need CRM pipeline, MES output, quality logs or budget files in the same view. 

In short, the building blocks exist. What is missing is the design, modeling and governance that turn them into a reporting layer built for one specific business. 

What Happens When Reports Don’t Fit the Business 

The cost of these gaps is rarely a single failure. It is a slow drag on every decision cycle. 

  • More preparing, less analyzing. Finance spends month-end building the report instead of reading it. 
  • Delayed visibility. Sales shortfalls and financial risks surface weeks after they start. 
  • Hidden margin erosion. Declining margins and underperforming customers stay buried in averages. 
  • Inconsistent numbers. Sales, finance and operations each report a different version of gross margin. 
  • Slower decisions. Leadership debates whose number is right instead of what to do next. 

These delays compound. A margin problem spotted six weeks into a quarter leaves little room to fix pricing, renegotiate supply or rebalance production before the period closes. 

What This Looks Like by Role 

  • CFO and finance leaders. Close takes longer than it should. Board packs depend on manual workbooks that are hard to audit. Cash and working capital risks show up late. 
  • Sales managers. Reps are measured on revenue, not profit. Without customer-level margin, discounting decisions are made blind and low-margin accounts keep growing. 
  • Operations and plant leaders. Production data lives in separate reports from cost data. Linking scrap or downtime to its margin impact needs another spreadsheet. 
  • Business Central users. The few people who understand the data model become a bottleneck for every new request. 

A Month-End Example 

Consider an illustrative mid-sized manufacturer running Business Central across two plants. The CFO wants to know why gross margin fell two points last quarter. 

  • The finance analyst runs the item sales report, customer sales report and production order cost report, then exports each to Excel. 
  • She adds freight invoices from a separate file and rebate accruals from another workbook, because neither sits in a standard margin report. 
  • Product family and channel are custom fields added through an extension, so she maps them manually with lookups. 
  • Two days later, the answer emerges: a material price increase hit one product family, and two large customers moved to a lower-margin channel. 

The analysis was right, but it arrived late and took two days of a senior analyst’s time. Next month, the same work starts again from scratch. With a customized model, the same answer sits in a margin bridge that refreshes overnight. 

A Quick Checklist for Business Central Reporting Gaps 

Use this quick checklist. If three or more apply, your team is likely paying a hidden reporting tax every month. 

  • Month-end reporting takes more than two working days after the books close. 
  • Key reports depend on Excel files that only one or two people can maintain. 
  • Sales and finance regularly disagree on margin or revenue figures. 
  • Custom fields from your extensions never appear in reports without manual work. 
  • You cannot see profitability by customer after freight, rebates and returns. 
  • Production KPIs such as scrap or OEE are tracked outside Business Central with no link to cost. 
  • New report requests wait in a developer or partner queue for weeks. 

Standard Reports or Custom Dashboards: A Side-by-Side View 

Here is how standard reporting compares with Business Central custom reports and dashboards built around your business. 

Factor Standard Business Central reporting Customized Business Central reporting 
Report logic Generic, Microsoft-defined Built on your KPI definitions 
Custom fields and extensions Often missing Included in the data model 
Data sources Business Central only Business Central plus CRM, MES and spreadsheets 
Refresh Run on demand or exported Scheduled and automatic 
Drill-down Limited, report by report Company to customer to invoice in one view 
Maintenance Developer for layout changes Governed model with self-service for users 
Consistency Varies by team and workbook One definition of each metric 
Scale Slows as data and users grow Model refreshed off-peak, users query the model 

5 Business Central Dashboards Every Manufacturer Needs 

Customized reporting is not just nicer visuals. It is the same Business Central data, modeled around the questions your leadership asks every week. Typical Business Central dashboards for a manufacturer include the following. 

  • Customer profitability dashboard. Revenue, gross margin and net contribution by customer after freight, rebates and returns. Ranks customers from most to least profitable and flags accounts slipping below target. 
  • Margin bridge. Breaks margin change into price, volume, mix, material and labor effects. Finance can explain a two-point drop in one view instead of five spreadsheets. 
  • Sales growth tracker. Growth by region, rep, product family and customer cohort against budget. Separates price-driven growth from volume-driven growth. 
  • Production performance view. OEE, scrap and yield by line and shift, linked to production order cost variance so operations sees the financial impact. 
  • Executive scorecard. A single page with the ten numbers leadership reviews every week, each with one agreed definition and a drill path to the detail. 

Each of these draws on Business Central data, including custom fields, and refreshes on a schedule. Nobody rebuilds them by hand at month-end. 

Key Benefits of Customized Business Central Reporting for Manufacturers 

Closing the reporting gaps does more than save analyst hours. It changes how quickly and confidently a manufacturer can act on its own data. 

  • Faster month-end and weekly reporting. Reports refresh on a schedule, so finance reviews numbers on day one instead of building them for days. 
  • One version of the truth. Every team uses the same certified definition of revenue, margin and profitability, which ends the debate over whose number is right. 
  • Earlier warning on margin erosion. Margin trends by product family, customer and plant surface problems while there is still time to fix pricing or costs. 
  • Smarter customer decisions. True customer profitability shows which accounts to grow, reprice or serve differently, so discounting stops being a guess. 
  • Sales performance tied to profit. Sales managers can coach reps on margin and mix, not just revenue volume. 
  • Operations linked to financial impact. Scrap, downtime and yield sit next to cost variance, so plant leaders see what each improvement is worth. 
  • Full use of your Business Central investment. Custom fields and extensions finally show up in reporting, so the data your team captures actually gets used. 
  • Less dependency on a few people. A governed, documented model means reporting continues when key staff are busy or move on. 
  • Room to grow. New plants, entities, product lines or data sources such as CRM and MES can be added to the model without rebuilding reports from scratch. 

Benefits by Role 

Role Key benefit 
CFO and finance leaders Faster close, auditable board reporting and early visibility into margin and cash risk 
Sales managers Customer and rep profitability, growth by segment and better discount control 
Operations and plant leaders Production KPIs connected to cost, so improvement work is prioritized by value 
Business Central users Self-service filtering and drill-down instead of waiting in a report queue 

Signs Native Reporting Still Fits Your Business 

Not every business needs a custom reporting layer on day one. Native reporting is usually enough when: 

  • You run Business Central close to standard, with few extensions or custom fields. 
  • Your KPIs match Microsoft’s standard definitions closely. 
  • One person can prepare monthly reports in a few hours without heavy Excel work. 
  • You report on Business Central data alone, with no CRM, MES or budget sources. 

If two or more of these are not true, the gaps covered above are likely already costing your team time and visibility. 

In-House vs Partner for Business Central Reporting 

Some manufacturers try to close these gaps internally. That can work, but it helps to be clear about what the project needs. 

  • Business Central data knowledge. Someone must know which tables hold value entries, item ledger entries, capacity entries and your custom extension data. 
  • Data modeling skills. A sound Power BI semantic model with tested measures is different from a set of visuals on raw exports. 
  • Finance and operations input. KPI definitions must be agreed by the people who will use them, not guessed by the person building them. 
  • Time. Internal teams usually build reports alongside their day jobs, so projects stretch and priorities slip. 

In-house works best when you already have a dedicated BI resource and clear KPI definitions. A partner makes sense when reporting knowledge is concentrated in one or two people, when leadership needs answers this quarter, or when the internal team should focus on running the business rather than building reports. 

Many manufacturers choose a hybrid. A partner designs the data model and first set of dashboards, then trains the internal team to extend them. 

Addend’s Approach to Business Central Custom Reporting 

Addend builds Microsoft Dynamics 365 Business Central reporting around how your business actually runs, not around the base application. A practical starting point is the handful of reports leadership debates most, then expanding once those numbers are trusted. 

Our Approach 

  • 1. Reporting gap assessment. We review current reports, Excel workbooks and KPI definitions with finance, sales and operations, and agree one definition for each metric. 
  • 2. Data model design. We connect to Business Central through its APIs, include custom tables and extension fields, and bring in other sources where needed. 
  • 3. Build and validate. We build the reports and dashboards, then reconcile every figure against Business Central before go-live. 
  • 4. Automate and govern. Scheduled refresh, row-level security and one certified version of each metric. 
  • 5. Handover and training. Your team owns the reports, so reporting no longer depends on one person. 

What We Deliver 

  • Business Central custom reports. Word, Excel and RDLC layouts for documents and statements that must stay inside Business Central. 
  • Business Central dashboards in Power BI. Profitability, margin, sales growth and cash views defined your way. 

Addend’s analytics consulting and manufacturing analytics teams have worked with mid-sized manufacturers on exactly this shift. See client stories for examples. 

Questions to Ask Any Business Central Reporting Partner 

Whether you work with Addend or another firm, these questions separate a reporting partner from a dashboard vendor. 

  • Will you include our custom fields and extensions? If the answer is “standard tables only,” the core gap stays open. 
  • Who defines the KPIs? The right partner works with your finance and sales leaders to agree definitions before building anything. 
  • How do you reconcile figures? Every dashboard number should tie back to Business Central before go-live. 
  • How will this scale? Ask how the model handles growing data volumes and Business Central API limits. 
  • What happens after handover? Your team should be able to maintain and extend the reports without the partner. 

How Addend Can Help 

Whether you need a few custom Business Central reports or a full reporting layer for finance, sales and operations, Addend can meet you where you are. Pick the starting point that matches your situation. 

If you need to… Start with What you get 
Understand where reporting breaks today Business Central reporting assessment A gap map of current reports, Excel workbooks and KPI definitions, with a prioritized fix list 
Prove value fast on one painful report Quick-start dashboard One high-impact dashboard, such as customer profitability or margin bridge, built on your definitions 
Replace month-end Excel work across teams Full reporting build A governed Power BI model on Business Central, custom reports and role-based dashboards 
Track plant performance against cost Manufacturing reporting solutions OEE, scrap, yield and cost variance views linked to Business Central production data 
Keep reports current as the business changes Ongoing reporting support New reports, model changes and Business Central upgrade checks as you grow 

Why Manufacturers Work With Addend 

  • Microsoft-ecosystem focus. Business Central, Power BI and Microsoft Fabric are core to what we do, so the reporting layer fits the stack you already own. 
  • Manufacturing context. We start from the questions CFOs, sales leaders and plant heads ask, not from a generic dashboard template. See our manufacturing accelerator for ready starting points. 
  • Your definitions, documented. Every KPI is agreed with your team, written down and reconciled to Business Central before go-live. 
  • Built for handover. Your team gets training and documentation so reporting does not depend on Addend or on one internal expert. 

Key Takeaways 

• Business Central ships with 300+ built-in reports, but they rarely reflect your customizations, extensions or KPI definitions. 

• The biggest gaps for manufacturers are customer profitability, margin trends, sales growth by segment and production KPIs such as OEE and scrap. 

• Built-in layouts can’t be edited, RDLC changes often need a developer, and Power BI apps work per company, so teams fall back on manual Excel work. 

• These gaps delay visibility, hide margin erosion, create conflicting numbers and slow decisions for finance, sales and operations. 

• Customized Business Central reporting gives one trusted, automated version of each number, with drill-down from company to customer to invoice. 

• Start with the few reports leadership debates most, agree the definitions, then expand once those numbers are trusted. 

• Addend can help with an assessment, a quick-start dashboard, a full reporting build or ongoing support, depending on where you are today. 

FAQs

Business Central offers financial reports, KPIs and role center dashboards, embedded Power BI apps, ad-hoc analysis in lists and Excel, and built-in reports. Each suits a different need. Financial reports cover statements, Power BI covers interactive analysis, and Excel covers one-off questions. Most manufacturers end up combining two or three of them.
The main Business Central reporting limitations are generic KPI definitions, limited support for custom fields and extensions, built-in layouts that cannot be edited, and heavy reliance on Excel exports. Reports also look at Business Central data alone, so CRM, MES or budget data must be merged by hand.
Partly. Microsoft says Business Central users get a free Power BI license for common features, but that free license cannot be used for the Business Central Power BI apps. To install, refresh or share those apps and reports, users need a Power BI Pro or higher license.
Not in one view by default. Microsoft notes the Power BI apps work per company, so each company needs its own app installed and set up. Manufacturers with several legal entities or plants usually need a custom data model to see consolidated results in one report.
Only partly. Microsoft states built-in layouts cannot be modified, but you can create custom Word, Excel or RDLC layouts on top of them. Layouts change how data looks, not which data the report contains. Adding new fields or logic usually needs a report extension built by a developer.
For formatting changes, copy an existing layout in the Report Layouts page, edit it in Word or Excel and import it back. For new datasets or calculations, a developer builds a report object or report extension in AL and deploys it as an extension. For analytical reporting, Business Central custom reports are often better built in Power BI.
The standard Business Central connector and Power BI apps are built on Microsoft’s own API pages, which do not include fields added through extensions. To report on custom fields, they must be exposed through a custom API page or web service and then added to the Power BI data model.
At a basic level, yes. The Inventory Customer Sales report sums quantity, amounts, discounts and profit for each customer and item, including item charges. True customer profitability after freight, rebates, returns and cost-to-serve usually needs a custom model that brings those costs together.
Not as a standard KPI. Microsoft lists utilization, capacity, work center load, production time and scrap among the manufacturing data Business Central captures. Turning that data into OEE, with availability, performance and quality on your definitions, generally requires custom calculations in Power BI or an add-on.
Excel works well for quick, one-off analysis through Open in Excel and Excel layouts. It struggles as a long-term reporting layer because files are rebuilt by hand, versions multiply, and Microsoft notes these features are bound by Excel row limits and column limits.
They solve different problems. Jet Reports builds Excel-based financial reports on live Business Central data, which finance teams like for statements and consolidations. Power BI is better for interactive dashboards, trend analysis and combining Business Central with other systems. Many organizations use both.
Start with the questions leadership needs answered, not the tool. Then weigh who will build and maintain reports, whether you need data from systems other than Business Central, how many companies you report across, and total licensing cost. A short reporting gap assessment usually makes the choice clear.
In Power BI Desktop, choose Get Data, then Online Services, then Dynamics 365 Business Central, and sign in to select your environment and company. For production reporting, connect through API pages with filters and scheduled refresh, since Microsoft caps concurrent requests per user.

Author By

Kamal Sharma

Kamal brings over 20 years of experience in data analytics and business intelligence. He has led the design and implementation of analytics solutions across operations, financial reporting, and performance improvement initiatives. With a background in business statistics and Six Sigma, his work focuses on applying data in a structured and practical way to solve real business challenges.

Author By

Picture of Kamal Sharma

Kamal Sharma

Kamal brings over 20 years of experience in data analytics and business intelligence. He has led the design and implementation of analytics solutions across operations, financial reporting, and performance improvement initiatives. With a background in business statistics and Six Sigma, his work focuses on applying data in a structured and practical way to solve real business challenges.
Translate »