web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic Reporting E...
Finance | Project Operations, Human Resources, ...
Answered

Electronic Reporting ER : How to add Line Feed to Trailer Record?

(0) ShareShare
ReportReport
Posted on by RaghuD3FO 60

Hello All, 

I have a custom ER Solution, where Data Model and Format Model are created from scratch.  The output file is of Text Format.  Please see below screenshot for how I have the basic Format Setup:
pastedimage1620263093190v1.png

I have a requirement for Header Records, Detail Records and Trailer Records all to end with Line Feed.   When the output file is viewed through an application like Notepad++,  the Header Record and Detail Record are automatically getting a Carriage Return (CR) and Line Feed (LF) at the end, without me doing anything special in the configuration for Header and Detail.  But the Trailer record, being the last record in the file, is not ending with Line Feed. 

Please see below screenshots to see how I setup Header, Detail and Trailer nodes of TYPE SEQUENCE.   Same properties for all 3 records sequences. 
pastedimage1620263318305v3.png     

Can you please help me what property on the Trailer Sequence node in the ER Config, which will make the Trailer Record also end with Line Feed? 

Thank you.

I have the same question (0)
  • Verified answer
    WillWU Profile Picture
    WillWU 22,361 on at

    Hi RaghuD3FO，

    Did you try using char(10) in the formula?

    Please check the old thread:community.dynamics.com/.../dynamics-footer-on-my-electronic-reporting

  • RaghuD3FO Profile Picture
    RaghuD3FO 60 on at

    Hi Will,  

    That worked, thank you.    I had seen that old thread but thought it was talking specifically for Excel-Output file.  And also not sure whether to include the LineFeed as an additional Node beneath the Trailer node.   I created it as a String-type field under the Trailer record-sequence and in Formula Editor entered CHAR(10) and it worked.

    Thank you,

    Raghu.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans