Case Study

Sage 200 to Microsoft Dynamics 365 Business Central for a Multi-Entity Charity

How the Royal Air Forces Association Is Replacing Sage 200 with Microsoft Dynamics 365 Business Central to Unite Finance, Warehousing and Reporting Across Its Charity and Subsidiaries

  • Registered Charity
  • Leicester, UK
  • Six Entities
Client Story

A Crux of the Case Story

The Royal Air Forces Association supports the RAF community through a main charity and five subsidiary companies covering trading, housing, nursery and events operations. Its finance team ran on Sage 200, hosted in Azure but not built for the cloud, and relied heavily on Excel to report across entities and restricted funds. After a structured selection process, RAFA chose Dynamics Square to implement Microsoft Dynamics 365 Business Central as a single system for finance, warehousing and reporting.

Business Overview

The Royal Air Forces Association is a registered charity that supports serving and former members of the Royal Air Force and their families. Alongside the main charity, it operates five subsidiary companies covering trading, housing, nursery and events operations.

Finance for the group ran on Sage 200 Professional, hosted on Microsoft Azure. Because Sage 200 is not a native cloud application, the team regularly faced slow performance and connection problems.

Charity accounting brings specific demands. RAFA needed to report on restricted and unrestricted funds, manage a VAT group with partial exemption and give budget holders visibility of their spending. Sage 200’s limited dimensional structure meant much of this reporting happened manually in Excel.

Around the finance system sat separate tools for CRM, expenses and warehousing, each holding part of the picture. The trading operation also needed robust stock and warehouse capability.

RAFA’s finance systems team ran a formal two-stage selection: initial demos to shortlist two or three systems, followed by targeted demos for senior finance and management. Their aim was a single, cloud-based system with stronger reporting and automation.

Royal Air Forces Association business overview

What are The
Business Challenges

Sage 200 was hosted in Azure but not built for the cloud, causing slow performance and connection problems.

Reporting across six entities relied heavily on manual work in Excel.

A limited dimensional structure made restricted-fund and charity reporting difficult.

VAT group reporting with partial exemption added complexity.

CRM, expenses and warehouse ran in separate, disconnected systems.

Budget holders lacked easy, read-only access to their own figures.

Approvals were not routed by cost centre or spending threshold.

Accounts payable, expenses and bank processes were largely manual.

The organisation needed a single, cloud-based finance platform designed for a multi-entity charity.

What the Business Needed

Royal Air Forces Association Sage 200 to Business Central requirements
  • One system for finance across the charity and all subsidiaries.
  • VAT group compliance, including partial exemption.
  • Flexible, multi-dimensional reporting for funds and charity structures.
  • Robust stock and warehouse capability for the trading operation.
  • Cost-centre approval workflows with spending thresholds.
  • Read-only access for budget holders.
  • Bank feeds and automation for accounts payable and expenses.
  • AI and Copilot capability for the future.

The goal was a single source of truth for the whole group, not another system to reconcile.

Business Objectives

RAFA set clear objectives for the project:

Replace Sage 200 with Microsoft Dynamics 365 Business Central in the cloud.

Bring the main charity and five subsidiaries onto one platform.

Build dimensions for fund, entity and cost-centre reporting.

Introduce mobile warehouse management for the trading operation.

Automate approvals, bank feeds, payables and expenses.

Give budget holders read-only access to live figures.

Go live in line with the financial year-end.

Royal Air Forces Association Sage 200 to Business Central

Solutions Proposed by Dynamics Square

After discovery discussions and demonstrations with RAFA’s finance team, Dynamics Square proposed Microsoft Dynamics 365 Business Central as a single platform for the charity and all five subsidiaries. The rollout is phased: core finance first, designed as a blueprint for every entity, followed by warehouse operations, automation and wider integration. Licensing uses Microsoft’s not-for-profit programme.

Phase 1: Core Finance as the Blueprint

  • Set up Business Central for the charity, RAFATRAD Limited, RAFA Housing Limited, RAFA Kidz Limited, RAFA Kidz Zone Limited and RAFA Events.
  • Redesigned the chart of accounts and introduced dimensions for entity, cost centre and restricted funds.
  • Configured the general ledger, budgets, deferrals, fixed assets, bank management with automatic reconciliation, receivables and payables.
  • Set up intercompany transactions between the charity and its subsidiaries.
  • Supported VAT group requirements, including partial exemption, with a strengthened audit trail.

Approvals and Purchasing Controls

  • Built approval workflows aligned to cost centres, with spending thresholds rather than a rigid hierarchy.
  • Added a purchase requisition process: raise a requisition, send it for approval and convert it into a purchase order.
  • Gave budget holders read-only access to their own figures.
  • Designed four customised document layouts, including purchase order, sales invoice, delivery note and credit note.

Accounts Payable and Expenses Automation

Warehouse, Retail and E-Commerce

  • Implemented inventory and warehouse management, with Tasklet WMS for mobile scanning.
  • Connected two Shopify stores through Business Central’s standard Shopify connector.
  • Built API integrations with RAFA’s web portal and the eBay marketplace for items, stock levels and orders.
  • Enabled integration with Salesforce to reduce manual data entry.

Data Migration, Go-Live and Support

  • Uploaded master data from templates prepared by RAFA, plus one year of financial history as monthly trial balances.
  • Followed a structured delivery covering analysis, design, development, user acceptance testing and deployment.
  • Provided two weeks of hypercare after go-live and a one-month warranty period.
  • Set up ongoing support with prepaid hours, a support portal and response times by priority.

Results and Impact: What This Transformation Means

The move to Business Central gives RAFA one cloud platform for finance, warehousing and reporting across the whole group.

The charity and five subsidiaries run on a single, cloud-native system.

Performance and connection problems from hosted Sage 200 are gone.

Fund, entity and cost-centre reporting no longer depends on Excel.

VAT group and partial exemption are handled within the system.

Budget holders see their own figures without waiting for finance.

Approvals, bank feeds and payables are automated.

Why This Case Matters and Future Prospects

Charities with trading subsidiaries face the same complexity as commercial groups, plus the extra demands of fund accounting, VAT partial exemption and accountability to trustees. Many still rely on finance systems that were never designed for that combination, filling the gaps with spreadsheets.

RAFA’s project shows how Microsoft Dynamics 365 Business Central can serve a multi-entity charity at the right scale. Dimensions handle fund and cost-centre reporting, approvals reflect real budget responsibility, and warehousing for the trading arm sits in the same system as the charity’s finances.

The next phase of the journey is already defined:

  • Power BI dashboards for trustees and senior management.
  • Copilot to speed up reporting and analysis.
  • Document management alongside finance and warehousing.
  • Integration with RAFA’s CRM and fundraising data.
  • Further automation of expenses and approvals.
  • Ongoing support and optimisation from Dynamics Square.

With one system across the group, RAFA’s finance team can spend less time reconciling and more time supporting the charity’s work.

Business consultant

Consult To Reveal Best Approach

Connect with us to facilitate your system to drive a parallel approach in the market you deal with. We help enterprises to implement their unique needs.

Let’s build the future of your business—together!

The right technology can change everything, and Dynamics Square ensures your business gets the tools it needs to succeed. Take the first step towards smarter solutions now!

Phone