Email this post as a PDFAI and agents · 4 November 2026 · 3 min read

Your first Copilot Studio agent on Business Central: an overdue-customer chaser

Microsoft's agents cover the common cases. For your own, Copilot Studio and the Business Central MCP server let you build one. A walkthrough of a simple, useful first agent: one that finds overdue customers, drafts a polite chaser, and leaves it for credit control to send.

Contents
  1. What the agent will do
  2. Step 1: decide what it can see
  3. Step 2: give it a narrow identity
  4. Step 3: create the agent in Copilot Studio
  5. Step 4: where the drafts go
  6. Step 5: test in a sandbox
  7. Step 6: run, measure, adjust
  8. Why it's a good first agent

The built-in agents handle sales orders, supplier invoices and expenses. Credit control isn't covered yet, and it's a good first custom agent: rules-based, repetitive, and easy to keep a human in the loop. This is a walkthrough of the shape of it, using Copilot Studio and the Business Central MCP server. Menus in Copilot Studio change often, so treat the steps as the sequence rather than exact clicks, and check Microsoft's current documentation as you go.

What the agent will do

  1. Each morning, find customers with invoices more than a set number of days overdue.
  2. For each, gather the overdue invoices, amounts and any notes.
  3. Draft a polite chaser email in your house style.
  4. Leave the drafts for a credit controller to check and send. It doesn't send anything itself.

Step 1: decide what it can see

In Business Central, configure the MCP server to expose only what this agent needs: customers (name, contact, email), customer ledger entries (open items, due dates, amounts) and perhaps notes. Nothing it can write to. (See configuring the MCP server safely.)

Step 2: give it a narrow identity

Create the permission set the agent will act under: read-only on those tables. If someone later wants it to do more, that's a decision, not a default. (See permissions.)

Step 3: create the agent in Copilot Studio

Create a new agent and connect it to Business Central as a tool source through the MCP connection, signing in with an account that has the narrow permissions above. Give the agent instructions in plain language:

You help the credit control team. Each morning, find customers with invoices more than 14 days overdue. For each customer, list the overdue invoices with number, due date and remaining amount. Draft a short, polite reminder email addressed to the customer's contact. Never threaten legal action. Never offer discounts or changed terms. Do not send emails; save them as drafts for review. If a customer has a note saying "on hold" or "in dispute", skip them and list them separately.

Keep the instructions short and explicit about what it must not do.

Step 4: where the drafts go

The simplest design is drafts in the credit controller's Outlook (via the Outlook connector in Copilot Studio) or a list in Teams. The person reviews, edits and sends. Over time you might let it send the gentle first reminder automatically, once it has proven itself.

Step 5: test in a sandbox

Point it at a sandbox copy of production first (use a sandbox). Check it finds the right customers, gets the amounts right, respects the disputes, and writes something you'd be happy to send.

Step 6: run, measure, adjust

A month with a person checking every draft. Track accuracy and time saved (the five numbers). Adjust the instructions as you learn. Give it a named owner in credit control.

Why it's a good first agent

It only reads; it never posts; a person sends everything; the business benefit (cash in sooner) is easy to measure; and it teaches you how custom agents behave before you trust one with anything that changes data. It's also not covered by Business Central's built-in reminders automation in the same conversational way, so it adds something rather than duplicating it (reminders).

Email this post as a PDF
A branded PDF of this post, sent to your inbox to keep, print or share. Copy in colleagues if you like.
We only use these addresses to send this PDF. Nobody is added to a mailing list. Mike at Business Boxed receives a copy. See our privacy notice.
Email this post
Talk to us
Want this done in your Business Central?
Book a 30 minute callGet the monthly newsletter

Related posts