2026-07-13 · Season 3
Copilot for Dynamics 365 Finance and Operations - Simply Explained

Show notes
Finance teams have never struggled with a lack of data—they struggle with the time it takes to find, organize, analyze, and act on that information. Traditional ERP workflows often require switching between customer records, reports, Excel spreadsheets, Outlook, and multiple ERP screens before a single decision can be made. Copilot for Dynamics 365 Finance & Operations changes that experience. Instead of searching for information manually, Copilot brings insights directly into your workflow, helping finance professionals summarize customer accounts, draft emails, analyze financial performance, forecast cash flow, and automate repetitive tasks without leaving the applications they already use. SOLVING THE DAILY FINANCE WORKFLOW Most finance professionals spend more time gathering information than analyzing it. Whether it's reviewing overdue invoices, preparing month-end reports, reconciling accounts, or responding to customer payment inquiries, much of the work involves navigating multiple screens and manually assembling information. Copilot reduces this friction by presenting relevant data, recommendations, and AI-generated summaries directly inside Dynamics 365 Finance & Operations, Outlook, Excel, and Microsoft Teams. COLLECTIONS AND ACCOUNTS RECEIVABLE One of Copilot's most valuable capabilities is improving collections management. Within the Collections Coordinator workspace, Copilot automatically summarizes overdue invoices, outstanding balances, payment history, disputes, and customer risk. Instead of reviewing multiple screens, collectors receive a complete overview the moment they open a customer record. Copilot can also draft personalized collection emails based on customer history and communication preferences. Through the Copilot for Finance Outlook add-in, finance teams can access customer information, generate responses, and synchronize activities back into Dynamics 365 without leaving their inbox. MONTH-END CLOSE AND FINANCIAL REPORTING Financial close remains one of the busiest periods for every finance department. Copilot assists before, during, and after month-end by identifying missing transactions, suggesting journal entries, highlighting reconciliation issues, and automatically explaining financial variances. Instead of manually investigating why operating expenses increased, finance professionals can simply ask Copilot for a variance explanation and receive a natural-language summary highlighting the biggest contributors. Rather than replacing financial expertise, Copilot removes much of the repetitive investigation work, allowing accountants to focus on analysis and decision-making. CASH FLOW FORECASTING Cash flow forecasting traditionally depends on spreadsheets, manual assumptions, and historical analysis. Copilot continuously analyzes open transactions, payment behavior, seasonal trends, and historical patterns to generate more dynamic cash flow forecasts. It can identify payment delays, unusual spending patterns, and potential cash flow risks while allowing finance teams to model different business scenarios before making important financial decisions. EXPENSE MANAGEMENT AND ACCOUNTS PAYABLE Copilot also streamlines expense processing and accounts payable. Using Optical Character Recognition (OCR), receipts are automatically scanned, key information extracted, and expense reports prepared with minimal manual input. Company policies are checked automatically, helping identify potential compliance issues before submission. For vendor invoices, Copilot assists with invoice processing, general ledger suggestions, purchase order updates, and approval workflows, reducing manual data entry while minimizing errors. GETTING STARTED Organizations need several prerequisites before using Copilot. Dynamics 365 Finance & Operations should be running version 10.0.38 or later. Power Platform and Dataverse integration must be enabled, supported Copilot features activated through Feature Management, and Microsoft 365 Copilot licensing assigned alongside the existing Dynamics 365 licenses. Because Copilot is cloud-based, on-premises deployments are not supported. DRIVING USER ADOPTION Technology alone doesn't guarantee success. Organizations that achieve the highest adoption typically begin with targeted pilot projects focused on high-value processes such as collections, month-end close, or expense management. Training users around real business scenarios rather than individual product features helps finance teams quickly understand where Copilot delivers measurable value. Successful adoption depends on improving existing business processes first and then using Copilot to accelerate those workflows rather than expecting AI to fix inefficient processes automatically. WHY COPILOT FOR D365 F&O MATTERS Copilot transforms Dynamics 365 Finance & Operations from a traditional ERP into an intelligent finance workspace. Instead of replacing accountants, controllers, or finance managers, it automates repetitive work such as data gathering, summarization, drafting communications, and preparing reports. This allows finance professionals to spend more time interpreting financial results, improving customer relationships, managing cash flow, and making strategic business decisions. Ultimately, Copilot helps finance teams shift from asking "What happened?" to focusing on the more valuable question: "What should we do next?" Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.
Apple Podcasts · Spotify · YouTube · YouTube Music · Deezer
Host: Mirko Peters
Guests
Related articles
Transcript
Read the full transcript
Welcome to another episode of Microsoft Knowledge Nuggets here on M365, FM, I'm your host, Mirko Peters. Today's topic is one you've definitely heard about if you work in finance, co-pilot for Dynamics 365 Finance and Operations. But here's the thing, most people here co-pilot and picture a chatbot that answers questions or maybe writes an email, but what does it actually do for a finance team on a Tuesday morning? That's what we're clearing up today in plain English. This isn't a robot that replaces your accountant. It's a helper that lives inside the tools you already use, your ERP, your email, your spreadsheets. At the end of this episode, you'll know exactly what co-pilot does in D365 F&O, where it works best, and what it really delivers. We'll walk through the main use cases starting with the one that brings the most immediate value, so grab your coffee and let's dive in. The problem co-pilot solves. 20 years ago, if you worked in finance, you're daimant logging into the ERP, exporting data to Excel, manipulating it, writing commentary, sending emails and repeating that cycle every month. The data was there. You just spent most of your time chasing it down and moving it around. That's the real problem co-pilot solves. Finance teams don't lack information. They have plenty. The friction is in how you access it and act on it. You'd open a customer record, then a screen for aging, then another for payment history, then switch to Outlook to draft an email. Every step costs time. Co-pilot flips that model. Instead of you going to the data, the data comes to you inside your workflow, one screen, one conversation. So what are the actual things it can do? Let's start with the biggest one. Co-pilot for collections and AR. So here's another knowledge nugget for you. This is the main use case for co-pilot in D365 F&O. It gets the most attention because it gives you the fastest return on your time. Let me explain how. Inside D365, F&O, there's a workspace called the Collections Coordinator Summary. When you open a customer record, co-pilot generates a summary of everything you need to know. Overdue invoices, payment history, aged balances, risk exposure, all in one place. Let me walk you through a real example. Say you're a collector and you open a customer named Contoso-Luted. Co-pilot immediately tells you. This customer has three overdue invoices totaling $12,000. Their last payment was 45 days ago and they have a dispute on invoice FT9. Back in the old days, you'd spend 5 to 10 minutes hunting for that information across different screens. Now it's there in seconds, but summaries are just the beginning. Co-pilot can also draft personalized reminder emails based on that customer's history and tone preferences. You review the email, click Send and move on. That's a two-click workflow. View the summary, create the email. A 30-minute task becomes 30 seconds. And here's what makes it even better. This works inside D365FNO and from outlook through the Co-pilot for Finance add-in. So if a customer emails you directly, you can pull up their account info, see their outstanding balance and draft a response without ever leaving your inbox. The collection activity gets synced back to FNO automatically. Collections is the big one. But there's another area where Co-pilot saves even more hidden time. Co-pilot for financial close and reporting, month and close. Every finance team knows this rhythm. Reconcile, adjust, validate, report, repeat. It's the same dance every single month and it eats up days of focused work. Co-pilot can help at every stage of that close life cycle. So let's walk through it. Before close even starts, Co-pilot does a pre-close scan. It identifies missing activity, unusual transactions and incomplete postings that need attention before you begin. Think of it like checking your kitchen before you start cooking a big meal. You want to know if you're missing ingredients before your halfway through the recipe, not after. While you're working through the close, Co-pilot gets more hands-on. It suggests journal entry accounts and descriptions based on your historical patterns. So if you always book prepaid expenses to the same account with the same description, Co-pilot learns that and offers it up automatically. It also flags discrepancies during reconciliation. Items that don't match, amounts that look off, entries that seem out of place. You still make the final call, but the hunting and gathering is done. Now the review phase, this is where Co-pilot really shines. It runs a variance analysis and generates plain language explanations of your financial statements. Here's a concrete example. You're reviewing the monthly P&L and you see operating expenses jumped. Instead of digging through spreadsheets for an hour, you ask Co-pilot, explain the variance in operating expenses this month. It returns a summary with the top three drivers and their dollar impact. Maybe it's a one-time consulting fee. Maybe it's higher utility costs. Maybe it's a supplier price increase. You get the answer in seconds, not hours. Now, let's be clear about what Co-pilot isn't doing here. It's not replacing your judgment. You still need to review the explanation, validate the numbers, and decide what to do about them. But Co-pilot replaces is the manual hunting and gathering phase, the part where you open five different reports, export data, build pivot tables, and try to piece together a story. That's the part that takes time and drains energy. Co-pilot handles that so you can focus on the actual analysis. Close is about what happened last month. But what about what's coming next? Co-pilot for cash flow and forecasting. Why is cash flow forecasting so hard? Think of the old routine, you export data. Build models in Excel. Make assumptions about when customers will pay. Then hope you're close. It's reactive. Look at the past and guess the future. Co-pilot works differently. It analyzes what's already in your system. Open transactions. Recurring patterns. Seasonality. It uses your actual data to predict cash inflows and outflows. You don't build a model from scratch. The forecast comes from your real numbers. Now for the practical part. Co-pilot flags variances early on usual payment delays. Unexpected costs spikes. A customer who usually pays in 30 days hasn't paid in 45. Co-pilot spots the pattern and brings it to your attention. You see cash flow problems as they happen, not at month end. Think of it as a financial radar for your business. It spots trouble before it arrives. Then there's scenario planning. This is where co-pilot becomes a decision tool. You can ask. What happens to cash if we slow collections by 10 days? Or what if we accelerate payments to top vendors? Co-pilot analyzes the data and shows the impact. You test different assumptions without building separate models for each one. This changes the finance role. Instead of spending time explaining what happened you think about what might happen. It's a shift from reactive reporting to proactive decisions. That's co-pilot inside F&O. But co-pilot also reaches into your inbox and spreadsheets. Co-pilot for expense management and AP. Let's talk about expense reports. You know the drill. Someone hands you a crumpled receipt. You type the amount, date, merchant and category. Then check policy. Then root for approval. Every single receipt. Every single time. Co-pilot uses optical character recognition or OCR. Scanner receipt. Co-pilot extracts the amount, date and merchant automatically. It builds a compliant expense report without you typing a single line. Then it checks each line against company policy. It flags anything wrong. A meal over the daily limit. A hotel charge needing pre-approval. It catches those early. For accounts payable, it's similar. Invoices come in. Co-pilot helps ingest them. Suggest general ledger codes and trigger the right approval workflows. You don't manually code each invoice and root it. Co-pilot handles the setup. The AP specialist reviews and confirms. Here's a common scenario. A vendor emails a change request on a purchase order. Maybe they can only supply 50 units instead of 30 or the price changed. In the old workflow, someone would open the PO, update the line, re-root for approval and email the vendor back. With Co-pilot, the system detects the change. It shows the difference side by side. It asks if you want to apply it, your review, click confirm. Co-pilot handles the rest. The PO updates. The approval workflow triggers. The vendor gets notified. What this adds up to is less manual data entry and fewer keying errors. The accountant still reviews and approves. But the mechanical part, typing, rooting, checking policy, gets handled automatically. All of this sounds great. But there are requirements you need to know before getting started. What you need to get Co-pilot working. So let's talk about what it actually takes to run Co-pilot in D365 F&O. I'm not going to bury you in technical specs, but you need the basics so you don't hit a wall halfway through a project. First up your D365 F&O version has to be 10.0, 38 or higher. That's a hard block if you're on something older. No workaround. Next, Power Platform and Dataverse integration need to be enabled. This is how Co-pilot sees your F&O data. Think of Dataverse as the bridge between your ERP and the AI layer. No bridge? Nothing for Co-pilot to work with. Then you've got to toggle on specific capabilities and feature management. The collections workspace and AI summaries aren't on by default. You go in and flip those switches. Now licensing. This is the one that catches people off-guard. Co-pilot requires a Microsoft 365 Co-pilot license on top of your existing D365 license. That's a separate cost. You need to factor that into your planning from day one. Your environment needs to be cloud-hosted. On-premise deployments don't qualify. If you're still running on-prem, you'll need to move to the cloud first before Co-pilot becomes an option. I'm not listing these to discourage you. I'm listing them so you know what you're walking into. These requirements are clear and achievable, but they're real. And ignoring them leads to frustration down the road. Once Co-pilot is running, the real question becomes, how you get your team to actually open it. Making people actually use it. Here's a number you should sit with. This organization's that roll out Microsoft 365 Co-pilot only about 35% of licensed users actively use it without deliberate adoption planning. That means roughly two out of three people with access never open it. They're licensed, they're paying for it and they never touch it. The most common failure is turning Co-pilot on without aligning it to your existing processes. Here's the honest truth. Co-pilot amplifies good processes and bad ones equally. If your collections workflow is a mess, Co-pilot won't fix it. It'll just help you generate messy emails faster. You need to clean up your processes first, then let Co-pilot accelerate them. So what actually works? Start with targeted pilots. Pick two or three high impact workflows, collections, month and close, expense processing, and roll Co-pilot out to those teams first. Don't give everyone access at once. Start small, prove the value, then expand. Train your teams on scenarios, not features. Don't run a training session called what Co-pilot can do. Run one called how to close month and a half the time. Show people exactly how Co-pilot fits into their actual day. That's what sticks. Sign licenses to whole teams, not individuals. When a team learns together, they share tips, they compare results, and they push each other to use it more. Peer learning drives adoption way more than any training session ever will. Let's pull all of this together into one picture. The big picture, how it all connects. Here's the thing about Co-pilot. It's not one single switch you flip and suddenly everything changes. It's a set of helpers, spread across F&O, Excel, Outlook and Teams. Each one does something specific. In F&O, expense reports through Outlook, cash flow analysis in Excel. Different tools, but they're built to work together. That's where the real power sits, the integration. Imagine a typical sequence. You're in F&O and Co-pilot gives you a summary of a customer's overdue balance. From there you move to Outlook to draft a reminder email and Co-pilot pulls that same data and writes it for you. Your customer responds. Dispute status updates right there in Outlook and the change syncs back to F&O automatically. You never left your flow. The data moved with you. Here's what finance teams really need to understand. Co-pilot respects your existing security roles. It only shows what that user already has permission to see. Collections agents see their own customers. Controllers see the full ledger. AP clocks see vendor invoices. Co-pilot doesn't create new access. It works within the boundaries you've already set. Now let's talk about what this actually means for the people doing the work. Co-pilot doesn't replace finance professionals. It doesn't make journal entries on its own. It doesn't approve payments. What it does is automate the mechanical parts. The summarizing the drafting, the data gathering, so humans can focus on judgment, negotiation and strategy. The collector still decides how to handle a difficult customer. The accountant reviews the variance and picks the right action while the controller signs off on the close. Co-pilot handles the prep work. You handle the decisions. That's the real shift. Finance teams have always been good at answering one question. What happened? Co-pilot helps them move to a better one. What should we do about it? So that's Co-pilot in D365F&O. Not a separate tool you need to learn. Just a set of AI helpers embedded in the workflows finance teams already use. Collections, close expense management, reporting, forecasting. If you're in finance and your organization runs D365F&O, here's your single most effective starting point. Start with the collections workspace this week. Open one customer record. Read the AI summary. Draft one email. See how it feels. Subscribe for more D365 in plain English and drop a comment if something clicked today.