Integrations

Finance Automation for Dynamics 365 Business Central

Two production finance platforms run against Dynamics 365 Business Central today — a $11.8M collections workspace and an AI collections agent. Both read BC through Azure Synapse or Microsoft Fabric, keep the ERP untouched, and run in the client's own Azure tenant.

GDPR CompliantIrish CompanyXero & QuickBooks Integration

Key Takeaway

Two production finance platforms run against Dynamics 365 Business Central today — a $11.8M collections workspace and an AI collections agent. Both read BC through Azure Synapse or Microsoft Fabric, keep the ERP untouched, and run in the client's own Azure tenant.

Two Production Builds, Not a Connector Listing

Most "Business Central integration" pages describe a connector that could, in principle, be configured. This one describes two systems that run in production against Dynamics 365 Business Central right now: a collections workspace managing $11.8M of open receivables across 7,700+ invoices for a US insurance services firm, and an AI collections agent that drafts every chase email for a European equipment rental group's €7.6M ledger.

Both follow the same principle: Business Central stays the system of record and stays read-only. The automation layer is a custom platform in the client's own Azure tenant that reads BC data, does the work BC was never designed to do — chasing, scoring, promising, escalating — and stores its own activity data in its own database. Nothing writes back to the ledger.

How We Connect to Business Central

We don't screen-scrape and we don't install anything inside BC. The data path is the one Microsoft built for exactly this:

  • Azure Synapse or Microsoft Fabric mirrors BC data on a schedule — customers, invoices, payments, ledger entries — into a read-only analytical layer. The platform queries that mirror, never the live ERP.
  • Microsoft Graph sends email from the client's own mailboxes, so every chase email comes from a real address the customer already knows.
  • Microsoft Entra ID handles sign-on. Finance staff use the account they already have; access is role-based and revocable by the client's own IT.
  • Azure PostgreSQL holds everything the platform creates — tasks, call logs, promises to pay, approval decisions. The ERP's books and the platform's activity trail stay cleanly separate, which auditors like.

If you already run Synapse or Fabric, most of the plumbing exists. If you don't, standing up the mirror is part of the build, not a prerequisite project.

Build One: A Collections Workspace on BC + Azure Synapse

The client had no system of record for collections — the work lived in personal inboxes next to a perfectly good ERP. We built a workspace that mirrors Business Central daily through Azure Synapse, re-scores every payer's risk each morning with a balance-weighted algorithm the finance team can explain to an auditor, generates and routes follow-up tasks across four escalation tiers, tracks promises to pay, and sends dunning email through Microsoft Graph. The ledger data it started from had inconsistent status flags and free-text payer names; the build absorbed that with resolution logic and review queues rather than demanding a cleanup project first.

Read the full case study, the guide to AR automation on Business Central, or the insurance services industry page this build anchors.

Build Two: An AI Collections Agent on BC + Microsoft Fabric

A Norwegian equipment rental group (~€30M revenue) ran a €7.6M receivables ledger with a one-person AR team. Their BC data already landed in a Microsoft Fabric Gold layer; we built an agent that reads it every morning, drafts the correct chase email for each account in Norwegian, classifies every customer reply into one of twelve intents, and routes everything through a human approval queue — no email leaves without sign-off. A single agent run drafted 162 correctly-staged chase emails. Before it touched a real customer, the agent passed a 23-scenario validation harness covering every outbound stage and inbound intent.

Read the full case study, the Microsoft Fabric integration page, or the equipment rental industry page this build anchors.

Streamline Your Financial Operations

Join hundreds of businesses already saving time with FinTask. Get a personalised demo today.

What Stays in Business Central — and What Doesn't

Business Central keeps what it's good at: the ledger, posting, credit memos, the audit trail of record. The platform owns what BC has no model for: who was chased and when, what was promised on which call, which dispute is blocking a six-figure payment, which payer's risk score just jumped. That split is deliberate. There is zero risk of automation corrupting the books, and if you ever re-implement or switch ERPs, the workflow layer — and its history — survives.

Everything a finance team needs to tune lives in an admin screen, not in code: templates, cadences, risk thresholds, escalation rules, even the AI prompts. No change request to us for a wording tweak.

Why Not an AppSource Connector?

Sometimes an off-the-shelf AR or AP app is the right answer, and we'll say so in a free assessment. The cases that come to us are the ones where it isn't: a payer structure no template models (one client chases ~2,500 insurance claims adjusters spread across 1,200 carrier customers), a security review that a third-party SaaS holding a copy of your ledger won't pass, or per-user-per-year pricing that inverts against a one-time build the moment the team grows. A custom platform on infrastructure you already pay for typically runs on tens of euros a month of Azure spend — and it fits the process you actually run, not the one the template assumes.

Where to Start

If your receivables or payables process runs on spreadsheets and inboxes next to Business Central, start with the AI readiness assessment — eight questions, a tailored reply within one business day. We'll map what an automation layer on your BC environment would look like, whether Synapse or Fabric is the right mirror for your setup, and what the first build should be. Or tell us how the process works today and we'll take it from there.

Frequently Asked Questions

Do you write data back into Business Central?

No. Every build reads BC through Azure Synapse or Microsoft Fabric and keeps the ERP read-only. Everything the platform creates — tasks, promises, emails, approvals — lives in its own database. Your books cannot be corrupted by the automation, and your auditors get a clean ledger plus a complete separate activity trail.

Do we need Azure Synapse or Microsoft Fabric already set up?

No. If you have one, we build on it — the Norwegian build reused the client's existing Fabric deployment and went from kickoff to live agent runs in weeks. If you don't, standing up the read-only mirror is part of the project, not a prerequisite you have to complete first.

Does this work with Business Central online and on-premises?

The production builds run against Business Central online, which is where Microsoft's Synapse and Fabric integration paths are strongest. On-premises BC can feed the same architecture through its API layer — the workflow platform doesn't care which deployment model feeds the mirror, so it's a connector question we'd resolve in the assessment, not a blocker.

How long does a Business Central automation build take?

Weeks, not months, when the Microsoft infrastructure already exists — the collections agent went live in a matter of weeks because it reused the client's Fabric deployment, BC and email tenant. Timeline is driven mostly by how standardised your process rules are, which is what the assessment establishes upfront.

Our BC data is messy. Is that a blocker?

It's the norm. The $11.8M collections build ran on a ledger with inconsistent status flags, missing salesperson codes and free-text payer names that couldn't be joined to anything. The build absorbed that with resolution logic and review queues rather than demanding a data cleanup project first. Messy data affects sequencing, not feasibility.

Reza Shahrokhi, ACA - Chartered Accountant and FinTask Founder

Written by Reza Shahrokhi ACA

Chartered Accountant (Chartered Accountants Ireland) • Founder of FinTask • 8+ years in finance & automation

Reza is a Chartered Accountant and the founder of FinTask. He specialises in helping growing businesses automate accounts payable, invoice processing, and financial reconciliation using AI-powered tools integrated with Xero and QuickBooks.

More about the author

Related Guides

guide

Accounts Receivable Automation for Dynamics 365 Business Central

Business Central knows which invoices are open. It doesn't know who promised to pay, which dispute is blocking a six-figure payment, or whose turn it is to chase. Here's how mid-market teams close that gap -- with the architecture from two production builds, an $11.8M ledger and a €7.6M one.

guide

Accounts Payable Automation for Business Central and Dynamics 365 F&O

Business Central and D365 F&O know which purchase orders are open. They don't know that a supplier billed in cases when the PO ordered eaches, or that one damaged-parts credit memo on a consolidated invoice shouldn't hold up the other 49 lines. Here's the matching architecture that fixes that, from a production build.

guide

Microsoft Fabric for Finance Teams: From Reporting to Automation

Companies deploy Microsoft Fabric, wire Business Central into the medallion layers, build Power BI dashboards -- and stop. The same Gold layer that feeds your dashboards can feed systems that do finance work. Here's what that looks like in production.

landing-page

ERP Finance Automation on Your Microsoft Stack

Your ERP holds the ledger. The actual work of finance -- chasing receivables, matching supplier invoices, costing jobs -- happens around it. We build the systems that do that work, on your own Azure tenant, with the ERP kept read-only.

guide

Financial Close and Consolidation Software for Multi-Entity Microsoft Environments

A CFO running 90 entities called their close process 'prehistoric' and asked a finance community how to start applying AI to it. Native ERP consolidation caps out well before 90 entities -- often well before 10. Here's the architecture that closes that gap on Business Central or D365 F&O, without an enterprise consolidation suite's price tag or timeline.

guide

Global Business Services: Where Business Central and D365 F&O Still Need Custom Work

A shared services centre exists to run one standardised finance process across many entities. Business Central and D365 F&O were both built to run one entity's process at a time. That mismatch -- not the ERP being weak -- is where GBS finance functions keep hitting walls.

Running Finance on Business Central?

Tell us where the spreadsheets take over and we'll map what an automation layer on your own BC environment would look like — read-only on the ERP, in your own Azure tenant.