GuruGroup logo
Microsoft Dynamics 365 F&O Technical Guide

Customizations in Electronic Report for Beginners

Executive Summary & Key Architectural Takeaways
  • No-Code Enterprise Reporting: Electronic Reporting (ER) allows creating, configuring, and updating business documents without X++ development.
  • Core Component Triad: Clear decoupling between the business Data Model, Model Mapping (binding to ERP tables), and Format (Excel, XML, PDF).
  • Regulatory Configuration Services (RCS): Synchronizing standard Microsoft repositories to import baseline formats and establish version control.
  • Inherited Configuration Pattern: Deriving custom models from Microsoft standard models to maintain clean upgradeability during monthly updates.
  • Extending Data Structures: Adding custom child nodes, calculated formulas, and formatting rules directly within the browser designer.

Introduction & Data Flow Architecture

Electronic Reporting (ER) is a configurable no-code reporting framework natively integrated into Dynamics 365 Finance & Operations. It allows business analysts and developers to create and maintain document structures directly without requiring code deployment.

ER separates report design into three modular components:

  • Data Model: Represents the domain-specific business data structure (independent of the underlying database schema).
  • Model Mapping: Maps the conceptual data model to D365FO tables, views, and data entities at runtime.
  • Format Component: Defines the external document representation (Excel workbook, XML payload, JSON, or PDF document).
Electronic Reporting Data Flow Diagram
Figure 1: High-level data flow from D365FO database tables through Model Mapping and Format.

β€œThe true power of Electronic Reporting is separating the business data contract from the presentation format. One data model can seamlessly feed multiple Excel, XML, and PDF formats.”

β€” Aamir Khan, Power Platform & Dynamics Lead

Configuring Repository & Baseline Configurations

Before creating custom configurations, navigate to Organization administration > Workspaces > Electronic reporting:

Electronic Reporting Workspace
Figure 2: Accessing the Electronic Reporting workspace in D365FO.

Open Reporting configurations to inspect existing repositories and import Microsoft standard configurations:

Reporting configurations list
Figure 3: Exploring configuration trees and versions.
Importing configurations from repository
Figure 4: Importing latest baseline configurations from Microsoft repository.

Creating a Derived Data Model

To customize without breaking standard upgrade paths, select the standard model and click Create configuration > Derive from Name:

Create derived configuration dialog
Figure 5: Creating a derived configuration with custom name and description.
Derived model appearing in configuration tree
Figure 6: Custom derived model initialized under parent node.

Open the Designer to begin expanding the data structure. Click New to add child nodes or attributes to active elements:

ER Data Model Designer
Figure 7: Data Model Designer showing node hierarchy and data types.
Adding custom child node
Figure 8: Adding a new child field to the active node.
Specifying item data type
Figure 9: Selecting data item type (String, Real, Date, Record list).

Configuring Model Mapping to ERP Data Sources

Once your data model is extended, switch to the Model to datasource mapping view. Bind your new fields to the underlying D365FO tables or calculated expressions:

Model mapping designer
Figure 10: Mapping model fields to D365FO table fields and calculated functions.
Formula Designer in ER
Figure 11: Using the built-in Formula Designer to transform runtime data.

Format Designer & Document Generation

Finally, create a derived Format configuration based on your extended model. Use the visual Format Designer to map your data model fields to Excel cells, XML tags, or PDF form fields:

ER Format Designer
Figure 12: Visual Format Designer organizing output structure.
Binding model to format elements
Figure 13: Binding model elements to format components.
Validating and completing configuration
Figure 14: Validating configuration status and marking as Completed.
Ready to Move Forward?

Turn Your Business Goals into Measurable Results

Partner with Guru Group to design, deliver, and scale secure technology solutions for your organization.