Electronic reporting - Adding columns horizontally in format mapping to get financial dimensions

(4) Share

Report

Posted on by Pranav Teja

264

hello experts,

I have a requirement to dump purchase order header appended with lines in an excel and hence was using electronic reporting. I also had a need to bring financial dimensions in such report. Hence, I was following below MS doc:

ER Use horizontally expandable ranges to dynamically add columns in Excel reports (Part 1 - Design format) - Finance & Operations | Dynamics 365 | Microsoft Learn

I was seamlessly able to add ranges in format mapping as guided by above link in the excel file "SampleFinDimWsReport.xlsx". In fact this file was provided by MS in the above link.

But somehow it is failing using the file prepared by me while adding ranges in format mapping with below error. (File prepared by me - "PO_Dump_ER.xlsx"). Attaching both the files.

Kindly help me understand where am making mistake. This is not enabling me saving the format mapping.

Regards,

Pranav

SampleFinDimWsRep...

PO_Dump_ER.xlsx

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Ramesh Kumar 7,549 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I hope below can help you

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/electronic-reporting-destinations?utm

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Pranav Teja 264 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ramesh for responding.

My issue was while creating format mapping model to dynamically increase columns. But your response was completed unrelated. I would appreciate if you would help me in the context of the issue.

Pranav

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,853 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,
The error message indicates that the fields you're trying to use have not been created in the Excel template.

To fix this:
-Open the Excel file and go to Formulas > Name Manager.
-Check if the fields are defined under a valid named range.
-If they’re missing, either:
-Add the fields under an existing range, or
-Create a new range and assign the fields to it.
Once the fields are correctly defined, import the Excel file into the Format Designer again so the new fields are recognized.
You can find a detailed explanation and best practices in my blog series on Business Documents:

For a detailed walkthrough, feel free to check out my blog series on Business Documents:
https://dynfotech.com/category/business-documentsbd/

Was this reply helpful? Yes No
Pranav Teja 264 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Alireza Eshaghzadeh,

For helping me out. This helped me solve.

The mistake which i made was ->> Additional ranges which the document asked to create should be with the existing names. So far, I have been creating new fields and this caused an error.

Thanks again

Was this reply helpful? Yes No