Skip to main content

Notifications

Announcements

Forum Structure Changes Coming on 11/8
Give Back to the Community this Month
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Excel Formatting issue...
Finance forum
Unanswered

Excel Formatting issue in the electronic reporting

(0) ShareShare
ReportReport
Posted on by Raj Borad 436
Hi,
I getting the same issue in Excel formatting in ER.
Issue is to fill the value of Journal table and journal Lines details as per the customer settlement transaction.
I create three ranges with details regarding below SS.
 
I want to know that how to use of REPLACE function available in the Format mapping to repeat the list values more than one time?
 
 
ER mapping is below. want to use REPEAT function here?
In export report, the details with Header and Lines are coming only for the first row, remaining value is blank. (Just like above ss)
 
Thank you,
Raj D Borad
Categories:
Finance

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Forum Structure Changes Coming on 11/8
Give Back to the Community this Month

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,888 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,247 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans