Posts

D365 F&O: Architecting Agentic Finance with Copilot Studio

Image
Copilot and AI in D365 F&O · 9 min read TL;DR: Learn how to build autonomous financial agents using the new GitHub Copilot harness in Copilot Studio to automate complex exception handling and global reconciliation in Dynamics 365 Finance. D365 F&O Finance Copilot & AI Power Platform Architecture Managing global financial operations in Dynamics 365 Finance often involves a constant battle against transaction exceptions, intercompany discrepancies, and manual reconciliation. By moving beyond rigid automation and adopting agentic workflows through the Microsoft Copilot Studio GitHub Copilot harness, you can transform your finance department from a reactive cost center into an autonomous engine of efficiency. This guide details how to architect these agents to reason through financial data, invoke Dynamics 365 actions, and resolve complex exceptions with minimal human intervention. 📖 In this article At a glance How it works Step-by-step solution Worked example Automation a...

D365 Finance: Settlement Data Storage Architecture in 10.0.50

Image
New features, release waves and version/service updates · 6 min read TL;DR: Starting in version 10.0.50, D365 Finance automatically routes customer and vendor settlement state updates into dedicated companion storage, decoupling them from CustTrans and VendTrans to mitigate database locking and high-volume integration bottlenecks. D365 F&O Finance Data Management Architecture Release Updates When high-volume payment runs hit your ledger, database contention on CustTrans and VendTrans can grind downstream integrations to a halt. In Dynamics 365 Finance version 10.0.50, a foundational architecture change decouples settlement states into dedicated companion storage tables. This post explores the foundational architectural shift that decouples settlement states to prepare for future performance and integration enhancements. 📖 In this article At a glance How it works Step-by-step solution Worked example Automation and AI opportunities Common pitfalls and troubleshooting Best...

D365 SCM: Resolving PO Discrepancies with Work IQ & Dataverse

Image
Real business use cases and end-to-end solution designs combining D365 F&O with Power Platform and AI · 10 min read TL;DR: Connect Dataverse Virtual Entities and Work IQ to Dynamics 365 Supply Chain Management to build autonomous Copilot Studio agents that resolve purchase order variances using governed Business Skills. D365 F&O Supply Chain Dataverse Copilot & AI Architecture Standard ERP workflow engines execute deterministic, rule-based branching efficiently, but handling nuanced supplier discrepancies, unit price tolerances, and delivery-date adjustments still consumes substantial procurement effort each month. By combining Microsoft Dataverse and the Work IQ semantic layer with Dynamics 365 Supply Chain Management, solution architects can now build autonomous, context-aware agents that reason across operational data and enforce business rules safely. This guide provides an end-to-end architecture and implementation blueprint for grounding agentic procurement wo...

D365 F&O: Real-Time Financial Models via Fabric IQ & MCP

Image
Reporting and analytics · 14 min read TL;DR: Connect Dynamics 365 Finance to Microsoft Fabric via OneLake to build Direct Lake financial models, automate semantic authoring with Power BI MCP, and deliver real-time conversational analytics using Fabric IQ. D365 F&O Reporting Power BI Architecture Copilot & AI Corporate finance teams running Dynamics 365 Finance often hit architectural limits when balancing sub-minute reporting requirements against database performance. Historically, architects had to choose between high-latency data exports via Data Management Framework (DMF) recurring batches or resource-heavy DirectQuery connections that risk transaction lock contention on general ledger tables. The integration of Power BI and Microsoft Fabric breaks this trade-off by combining Link to Fabric with Model Context Protocol (MCP) servers and Fabric IQ. In this guide, you will learn how to design, programmatically author, and query governed Direct Lake financial models anchored t...