8 min read
Dual-Write Dropped My Field and Reported Success
Why a dual-write map can complete with zero errors while a custom F&O field never lands in Dataverse — staging tables, unpublished maps, and change tracking after a schema change.
Tag
Dynamics 365 F&O
X++, data entities, batch jobs, dual-write, and the Finance & Operations work that breaks on upgrade day.
34 articles
Related series: F&O and Dataverse integration, X++ performance, Copilot in Dynamics 365, Power Automate gotchas
7 min read
OData 429s from F&O: What Actually Throttles You
HTTP 429 from Dynamics 365 Finance & Operations is usually the query shape, not the request count — cross-company scans, $filter that cannot seek, $batch that still burns SQL, and why retrying harder makes month-end worse.
4 min read
SysTest in D365 F&O: Unit Tests That Survive a Platform Update
How to write X++ SysTest cases that isolate tables, skip UI, and stay green after Microsoft ships a new PU — without turning the suite into a 40-minute tax.
4 min read
Feature Management in D365 Finance and Operations: Flags, States, and Custom Features
How the D365 F&O Feature management workspace works, what feature states mean for ALM, and how to ship your own X++ features behind flags.
7 min read
D365 F&O Data Entities: Composite, Computed, and Virtual Fields Explained
Data entities look like simple tables until you need a nested import, a derived column, or a field with no storage. Knowing the three advanced shapes is what makes integrations actually work.
5 min read
Extending Data Entities in D365 Finance & Operations Without Breaking Upgrades
Add fields, computed columns, and validation to standard D365 Finance & Operations data entities the upgrade-safe way — with X++ examples and the staging-table traps to avoid.
4 min read
Chain of Command vs Event Handlers: Extending D365 F&O the Right Way
When to use Chain of Command and when to use pre/post event handlers in Dynamics 365 Finance & Operations — with X++ examples, a decision table, and the gotchas that trip up teams.
4 min read
Electronic Reporting in D365 Finance: Building Custom Formats Without Code
A practical guide to the Electronic Reporting (ER) framework in D365 Finance — data models, model mappings, and format configurations to produce custom files without X++.
4 min read
Financial Dimensions in D365 Finance: How They Really Work
Default dimensions, ledger dimensions, account structures, and the DimensionAttributeValueCombination table explained — with X++ patterns for reading and building dimensions in D365 Finance.
4 min read
Number Sequences in D365 Finance & Operations: Setup, Pitfalls, and X++ Patterns
How the number sequence framework works in D365 Finance & Operations — continuous vs non-continuous, preallocation, cleanup, and X++ patterns for generating numbers on custom tables.
4 min read
D365 Finance & Operations Security: Roles, Duties, and Privileges Done Right
How the role-based security model in D365 Finance & Operations actually works — privileges, duties, roles, segregation of duties, and how to extend security without overlayering.
4 min read
Recurring Integrations and the REST API in D365 Finance & Operations
Move files in and out of D365 Finance & Operations reliably using the recurring integrations REST API — enqueue, dequeue, acknowledge, and the status polling patterns that keep data flowing.
4 min read
Extensible Data Security (XDS) in D365 Finance & Operations: Row-Level Security That Scales
How to build extensible data security policies in D365 Finance & Operations to filter records by user context — with a worked example, query constructs, and the performance pitfalls to avoid.
7 min read
Managing D365 Finance & Operations Environments with LCS and Database Refreshes
Practical D365 Finance and Operations LCS guide for environment tiers, database refreshes, bacpac exports, restores, and sandbox governance.
6 min read
Table and Form Data Source Events in D365 F&O: A Practical X++ Reference
Practical D365 F&O X++ event handler guide for table CRUD events, form data source events, ordering caveats, and when to use CoC.
6 min read
Building and Deploying D365 Finance & Operations Packages with Azure DevOps
Build and deploy D365 Finance and Operations packages with Azure DevOps, hosted build pipelines, LCS Asset Library, and release safeguards.
6 min read
Surviving OData Throttling in D365 Finance & Operations Integrations
Design resilient D365 Finance and Operations OData integrations with 429 handling, Retry-After, batching, backoff, jitter, and DMF fallbacks.
6 min read
Building Custom Workflows in D365 Finance & Operations from Scratch
Step-by-step D365 Finance and Operations workflow framework guide covering categories, types, approvals, event handlers, and submit code.
6 min read
Scaling Batch Processing in D365 Finance & Operations: Groups, Threads, and Parallel Tasks
How to scale D365 F&O batch: batch groups bound to servers, max threads per AOS, splitting work into parallel tasks with SysOperation, task dependencies, and troubleshooting.
5 min read
TempDB vs InMemory Temporary Tables in X++: When to Use Which
Clear X++ guide to TempDB vs InMemory temporary tables in D365 F&O, with joins, indexes, set-based operations, and performance tradeoffs.
7 min read
Dual-Write vs Virtual Entities vs OData: Choosing the Right F&O–Dataverse Pattern
Compare dual-write, virtual entities, OData, and DMF for Finance and Operations to Dataverse integration with latency and failure tradeoffs.
7 min read
Configuring Purchase Requisition Approval Workflows in D365 F&O Without Code
A hands-on guide to building approval workflows in Dynamics 365 Finance & Operations using the workflow editor, with conditional routing, escalation, and delegation.
7 min read
Building a Balance Sheet and P&L with Financial Reporting in D365 Finance
How to build financial statements in Dynamics 365 Finance using row, column, tree and report definitions, with practical tips on dimension sets and performance.
6 min read
Query-Based vs RDP SSRS Reports in D365 Finance & Operations
When to use query-based versus Report Data Provider SSRS reports in Dynamics 365 F&O, the full component stack, and an X++ sketch of an RDP class and data contract.
6 min read
Inventory Costing Methods in D365 Supply Chain: FIFO, Average, and Standard
A practical breakdown of inventory costing in Dynamics 365 Supply Chain Management with item model groups, physical vs financial updates, inventory close, and a FIFO example.
8 min read
The New Accounting Rules Engine in D365 Finance: Stop Wasting 30 Hours a Month on Period Close
How the Accounting Rules Engine, multi-entity journals, flexible hierarchies, and Copilot in D365 Finance 10.0.46+ transform period close for multi-company environments.
9 min read
Dual-Write Between D365 F&O and Dataverse: Pitfalls and Patterns That Actually Work
A field-tested guide to dual-write configuration between D365 Finance & Operations and Dataverse — covering initial sync failures, conflict resolution, performance tuning, and when to use alternatives like virtual entities or data export service.
10 min read
X++ Query Performance in D365 F&O: Indexes, Joins, and the Trace Parser
How to diagnose and fix slow X++ queries in D365 Finance & Operations using Trace Parser, LCS SQL insights, execution plans, proper index design, join selection, and set-based operations.
9 min read
Virtual Entities in D365 F&O: Exposing External Data Without the ETL Tax
How to use virtual entities in D365 Finance & Operations to surface external data from APIs and databases without importing, syncing, or paying the ETL tax — with a real-world supplier data example.
10 min read
Migrating Data into D365 F&O with the Data Management Framework — Lessons from the Trenches
A practical guide to data migration using the Data Management Framework in D365 Finance & Operations — covering entity selection, staging tables, transformation patterns, error handling, and performance tuning from real enterprise migrations.
9 min read
Power Automate + D365 F&O End-to-End: Consuming Business Events and Calling Data Entities
Build a full round-trip integration between Power Automate and D365 Finance & Operations — trigger on business events, transform data, and write back via OData.
9 min read
Chain of Responsibility in D365 F&O: Extending Standard Logic Without Overlayering
How to use Chain of Responsibility (CoR) to extend standard X++ classes in D365 Finance & Operations — with code samples for wrapping methods, accessing protected members, and avoiding common pitfalls.
11 min read
Business Events and Data Events in D365 Finance & Operations: A Developer Guide
How to build, activate, and consume Business Events and Data Events in Dynamics 365 Finance & Operations with X++ code samples and integration patterns.
9 min read
SysOperation Framework in D365 F&O: Building Batch Jobs the Right Way
How to build batch jobs using the SysOperation framework in D365 Finance & Operations — contract, controller, and service classes with X++ code samples.