GuruGroup logo
Microsoft Dynamics 365 F&O Technical Guide

Customization in Electronic Report Formats through Excel Templates in D365

Executive Summary & Key Architectural Takeaways
  • No-Code Report Formatting: Utilizing Excel worksheets as dynamic runtime templates for Microsoft Dynamics 365 Electronic Reporting (ER).
  • Named Range Data Contracts: Defining single-cell and table-level Excel named ranges that bind directly to ER format components.
  • Derived Configuration Management: Creating child ER format configurations from Microsoft repository baselines without breaking upgrade compatibility.
  • Template Attachment Workflow: Downloading, modifying formulas/styles via Name Manager, and re-attaching updated workbook templates.
  • Production Governance: Maintaining consistent corporate branding, calculations, and compliance across financial business documents.

Creating a New Custom Report Template

To create a new custom Electronic Reporting template, start by opening Microsoft Excel. Type all the required field names as column headers. Next, select the header row along with the row beneath it, navigate to the Formulas tab, and select Create from Selection.

Excel Create Names from Selection
Figure 1: Creating Excel named ranges from column selection headers.

In the dialog box, ensure the Top row checkbox is enabled and click OK:

Enable Top Row in Name Creation
Figure 2: Verifying Top row selection to map individual cells to column names.

Now the value of each field cell is directly associated with its corresponding field name. You can verify this by checking the Excel Name Box for individual cell addresses:

Verifying cell name associations
Figure 3: Individual cells assigned to their respective field identifiers.
Cell coordinate mapping
Figure 4: Cell coordinate mapping in Excel formula bar.

After defining individual cell names, select the complete data row and assign it a range name (for example, ReportLines). This range will be referenced in the ER format designer to repeat records dynamically:

Assigning range name to complete row
Figure 5: Defining a repeating row range name in the Excel Name Box.

Set the name of the worksheet, save the Excel workbook, and attach it to your custom ER format configuration in Dynamics 365 Finance & Operations.

“Using Excel templates in Electronic Reporting provides business analysts with complete design autonomy over fonts, colors, and formulas without writing a single line of X++ code.”

— Aamir Khan, Power Platform & Dynamics Lead

Modifying an Existing Report Template

To enable new ER functionality or modify standard business documents, adjustments can be made directly to the Excel template attached to an existing format configuration.

Create a new derived format configuration in the Electronic Reporting workspace, select your format, and click the Attachments button:

ER Configuration Attachments Button
Figure 6: Opening document attachments for the derived ER format configuration.
Attachment details in D365FO
Figure 7: Viewing the attached Excel workbook template file.

Click Open to download the original Excel template to your local workstation:

Downloading Excel template
Figure 8: Downloading the template for local customization.

Updating Ranges in Excel Name Manager

Open the downloaded template in Excel. Navigate to Formulas > Name Manager to review, edit, or create new named ranges:

Excel Name Manager Window
Figure 9: Excel Name Manager displaying existing report ranges and bindings.
Editing named range properties
Figure 10: Adjusting formula references and range coordinates.

You can now create new ranges, adjust existing coordinate references, update formatting or logos, add Excel formulas (such as SUM or VLOOKUP), and save the workbook:

Configuring new range coordinates
Figure 11: Modifying range definitions and cell values.
Reviewing updated template layout
Figure 12: Reviewing modified Excel layout before re-attaching to D365FO.

Re-uploadsing and Verifying the Template in D365FO

Return to Dynamics 365 Finance & Operations. Under the Attachments form of your ER format, uploads the modified workbook as a new file attachment. Open the ER Format Designer and verify that the newly defined named ranges appear in the format tree ready for data mapping:

Re-uploadsing updated template to D365FO
Figure 13: Successfully re-attaching the customized template to the Electronic Reporting configuration.
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.