Microsoft Dynamics 365 Business Central: the most versatile ERP in the Spanish mid-market and its real limits

If there is an ERP that has steadily gained ground in medium-sized Spanish companies over the past five years, that is Microsoft Dynamics 365 Business Central.

It is the heir to Dynamics NAV and Navision —names with decades of presence in the market—, reimagined as a cloud solution on Microsoft Azure, with native integration with Teams, Outlook and Power BI, and with a level of cost and implementation complexity that makes it accessible to companies that have overcome basic accounting tools, but do not have the budget or structure for SAP S/4HANA.

Gartner includes him among the global leaders in Cloud ERP, along with Oracle, SAP and Workday. [4] Forrester identifies him as a natural option for growing medium-sized companies with revenues between 10 and 250 million euros. [1]

In Spain, where 54.6% of companies already have ERP [11], Business Central is one of the most common alternatives for organizations looking to evolve from solutions such as A3, Sage 50 or older versions of Dynamics.

And yet, after implementation, limitations appear that the initial value proposition does not always make explicit. This article analyzes them precisely.

What was Dynamics 365 Business Central designed for

Business Central is a generalist ERP designed to cover the operational core of a medium-sized company: finance, accounting, purchasing and supplier management, inventory and warehouse, sales and order management, as well as basic projects. [2]

Its architecture is modular - it allows you to adopt only the necessary modules - and it is built on Microsoft Azure, which guarantees availability, automatic updates and scalability without the need for its own infrastructure.

Its main competitive advantage is not so much in specific functionalities, but in its ecosystem: native integration with Microsoft 365 (Outlook, Teams, Excel), with Power BI for advanced reporting and with Power Platform (Power Apps, Power Automate) for developing code-free extensions. For organizations that already operate in the Microsoft environment, this significantly reduces integration friction compared to other ERPs.

IDC describes Business Central as the natural choice for medium-sized companies that have outgrown simpler accounting tools and need “a single source of real data across all departments to facilitate decision-making”. [2]

It's a good summary of the problem it solves—and also how far that promise goes.

What Business Central Does Well

Integrated financial core

General accounting, collection and payment management, bank reconciliation, fixed asset management, VAT and tax compliance in Spain (SII, electronic invoicing) are solidly covered.
For companies that previously managed accounting in Sage 50 and sales in separate systems, Business Central integration eliminates manual reconciliation tasks with immediate impact.

Reporting with Power BI

Native integration with Power BI is, in practice, Microsoft's answer to the common reporting gap in ERPs.
Instead of building reports within the system —which usually requires technical knowledge—it allows you to work on data in Power BI and create dashboards with the flexibility of a modern visualization tool. It's a clear advantage for organizations with some analytical capacity.

Extensibility with Power Platform

Power Apps and Power Automate allow users with moderate technical knowledge to build applications and automations connected to Business Central without the need to modify the ERP.
This makes it more extensible than other, more closed solutions, although this flexibility also involves a learning and maintenance cost that should be taken into account.

Scalability within the Microsoft ecosystem

As the company grows, it can evolve to Dynamics 365 Finance without leaving the ecosystem. If you need advanced HR capabilities, you can integrate with Microsoft Viva or even with external solutions such as SuccessFactors.
The transition isn't trivial, but the environment is designed to avoid having to start from scratch.

The limits that appear in actual use

Approval workflows: present in the system, absent in practice

Business Central includes native workflow features. They exist within the system. The documented problem is not their absence, but their usability: they are designed with technical or advanced training users in mind. [3]

A purchasing manager who needs to set up an approval rule—for example, that any order greater than 10,000 euros requires validation from the CFO— usually needs the support of a Microsoft partner or a system administrator.

This explains a pattern that Aberdeen Group consistently documents: only 23% of medium-sized companies use the workflow management features of their ERP, while 77% continue to manage approvals via email. [6]

It is not a problem of ignorance. The thing is that configuring a truly useful workflow—with conditional logic, automatic scaling, notifications and traceability—involves an implementation cost that many organizations don't assume. The result is that the approval flow ends up living outside the system.

The HR module: insufficient for operational templates

Business Central includes a basic HR module: managing employees, absences and, in some countries, payroll. However, it is not designed to cover the operational management of people in organizations with shift or fieldwork templates.

It does not incorporate features such as shift planning, guard management, employee portals with self-service adapted to staff, or structured management of training or evaluations. [8]

In practice, this means that many companies with Business Central in place use tools such as Factorial, Personio, Sage HR or SuccessFactors for managing people. Furthermore, these solutions are not usually natively integrated with the ERP, requiring data to be synchronized manually or through middleware. [7]

Multi-entity reporting and cross-operational dimensions

Business Central allows multi-entity management: it is possible to operate with several companies within the same instance and consolidate financial data.

However, when consolidation requires cross-operational dimensions—such as the cost per center in an organization with several hospitals, or the profitability per program in a business school with multiple campuses and modalities—native capabilities are limited without an additional layer of analysis.

Power BI solves this problem in theory. In practice, it requires that the team has technical capabilities to model the data correctly, something that does not always happen in the Spanish mid-market.

Integration with sectoral systems

Business Central has connectors for the most common systems in the Microsoft ecosystem, but integration with specific sectoral tools — such as Opera PMS in hospitality, a clinical HIS in healthcare, ticketing systems in leisure or Guidewire in insurance — is not native. It requires its own integration projects, with their corresponding cost and time frame.

This is especially relevant because medium-sized Spanish companies operate in heterogeneous technological environments: ERP for finance, CRM for sales, specific HR tools and sectorial systems specific to each industry.

In this context, Business Central acts as the financial core, but data silos with the rest of the ecosystem remain a structural reality. [5]

Multichannel retail and inventory synchronization

For retailers with a presence in physical stores, ecommerce and marketplaces, synchronizing inventory in real time between channels is not optional: it's a basic operating requirement.

Business Central doesn't offer this capability natively. Integration with platforms such as Shopify, Amazon or Zalando requires third-party extensions or own developments. [9]

When order volume grows and multichannel return management becomes complicated, this limitation has a direct impact on both customer experience and operational efficiency.

The Microsoft Ecosystem Paradox

Business Central's greatest advantage — its membership in the Microsoft ecosystem — is also the source of its main risk. When an organization extends it with Power Apps, Power Automate and Power BI, it is building dependencies within that ecosystem that can make a future migration more expensive.

It's not necessarily a problem, but it's a strategic decision that must be taken consciously.

Deloitte documents that many organizations deviate from their initial business case with ERP: they start from the idea of integrating systems and gaining agility, but the actual implementation does not always meet those expectations. [10]

In the case of Business Central, the specific risk is that the promise of extensibility with Power Platform generates expectations of full coverage that, in practice, involve continuous investment in licensing, development and maintenance.

What type of company is it the right choice for

Business Central is the right choice for medium-sized companies that have outgrown basic accounting tools and need to integrate finance, purchasing, sales and inventory into a single system; that already operate within the Microsoft ecosystem and want to take advantage of that integration; and that have internal technical capacity or a trusted partner to correctly configure the necessary extensions.

The gaps that the system leaves uncovered—approval workflows with adequate UX, operational HR management, integration with sectorial systems or complex multi-entity reporting—should not be interpreted as reasons to rule it out. They must be addressed as architectural decisions: what tools complement it in each of these areas and how they are integrated so that data flows without duplication.

Business Central solves the standard financial and operational core of a midsize company better than most alternatives in its price range. What it doesn't cover by design is precisely the space where no-code satellite tools provide the most value: processes specific to each sector, the operation of people and the workflows that the business needs to manage autonomously, without depending on IT. [4]

Bibliographic references

Methodological note: all statistics have been verified in the original sources before inclusion. The numerical citations in superscript [N] refer to the APA references listed below.

[1] PanoramaConsulting Group. (2024). The 2024 ERP Report. Panorama ConsultingGroup. https://4439340.fs1.hubspotusercontent-na1.net/hubfs/4439340/Reports/ERP%20Report/2024-erp-report-panorama-consulting-group.pdf — Microsoft Dynamics 365 Finance is classified as Upper Tier II ($250—750 million). Dynamics 365 Business Central in Lower Tier II ($10-250M). 74% of organizations surveyed adopted SaaS in 2024 compared to 52% the year before.

[2] IDC. (2024). IDC MarketScape: Medium-sized Business ERP Applications 2024 Vendor Assessment. IDC Research, Doc. #US50655223. https://www.idc.com — Microsoft Dynamics 365 Business Central is designed for medium-sized companies that outperform basic accounting tools. It offers finance, sales, inventory, purchasing and reporting integrated with Power BI.

[3] Dyntech/ Ontargit. (2024). Microsoft Dynamics 365 vs SAP S/4HANA Independent Review 2024. https://ontargit.com/dynamics-365-vs-sap-2024/ — Dynamics 365 F&O can be overwhelming for small companies because of its configuration and approval flows, designed with large companies in mind. Business Central is ideal for companies with a turnover of $30 million to $250 million.

[4] Forrester Research. (2024). Forrester Wave ERP: Product-Centric and Service-Centric Industries, Q2 2024. https://www.forrester.com/blogs/two-erp-waves-now-live — In 2024, Oracle, SAP, Microsoft and Workday are leading cloud ERP for service companies. Universal trends: cloud migration, Deficient UX in legacy systems, need for modular extensibility.

[5] MuleSoft/ Deloitte Digital/Vanson Bourne. (2024). Connectivity Benchmark Report 2024. https://www.deloitte.com/za/en/services/consulting/perspectives/2024-connectivity-benchmark-report.html — 81% of IT leaders say that data silos block digital transformation. The average company manages more than 900 applications with only 28% integrated.

[6] Aberdeen Group. Cited in: FounderJar. (2024). The Ultimate List of ERP Statistics for 2025. https://www.founderjar.com/erp-statistics/ — Only 23% of medium-sized companies use the workflow management features of their ERP. The remaining 77% manage approvals by email, WhatsApp or verbally, without traceability.

[7] Gartner. (2023). Market Share: Enterprise Resource Planning, Worldwide, 2023. https://www.gartner.com/en/documents/5467895 — HCM was the fastest growing segment in ERP (+14% in 2023). Microsoft includes basic HR modules in Dynamics 365 but advanced functionality requires Microsoft Viva or external integrations.

[8] Cetas/ Vision 33. (2025). Microsoft Dynamics 365 Business Central vs. SAPBusiness One. https://cetastech.com/microsoft-dynamics-365-business-central-vs-sap-business-one/ — Business Central: native limitations in advanced multi-entity, need for additional Power BI for complex reporting, basic HR module that requires extensions.

[9] NetSuite/ Bizowie. (2024). Omnichannel Retail ERP: Connecting POS, eCommerce, and Warehouse. https://bizowie.com/omnichannel-retail-erp-connecting-pos-ecommerce-and-warehouse — Omnichannel retail requires real-time synchronization between POS, ecommerce and warehouse that standard ERPs, including DynamicsBC, don't offer as standard without additional extensions or integrations.

[10] Deloitte. (2023). Maximize ERP Market Value. Deloitte US. https://www.deloitte.com/us/en/what-we-do/capabilities/finance-transformation/articles/erp-value.html — Many organizations stray from their initial business case. Most start out wanting to unite disparate systems and obtain an agile platform, but the actual implementation falls short of original strategic expectations.

[11] Eurostat. (2023). e-Business integration — Statistics Explained. European Commission. https://ec.europa.eu/eurostat/statistics-explained/index.php?title=E-business_integration — 54.6% of Spanish companies with 10+ employees use ERP. Microsoft Dynamics is the second most implemented system in Spain after SAP, with a particularly strong presence in services and medium-sized retail.

‍

‍