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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Line break in Electronic Reporting

(0) ShareShare
ReportReport
Posted on by 70

Hi All,

I am creating my first electronic reporting in which I have to generate positive pay file in CSV in which I need to know how can I add a line break after a first record ?4527.Er.PNG

I have the same question (0)
  • Suggested answer
    Arcadi Profile Picture
    796 on at

    Hi, 

    You need to select the sequence "MainSequence" and in right column on the format tab you'll see "Special character". Also don't use "separator", select the sequence "transactions" and add in the format tab a custom delimiter ",".

  • SAAD Ahmed Profile Picture
    70 on at

    Thanks Arcadi for your response , I have tried by adding special character in the main sequence but it is still not adding a line break in my CSV although custom delimiter on transactions that you suggest is working fine. Is any thing I am doing wrong here for a line break.

    pastedimage1675670137698v2.png

    pastedimage1675669846084v1.png

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    15,225 Super User 2026 Season 1 on at

    Hi SAAD,

    Can you share info about mapping for "Transactions"?

  • SAAD Ahmed Profile Picture
    70 on at

    Hi Alireza,

    I'm using this mapping

    pastedimage1675672361934v1.png

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    15,225 Super User 2026 Season 1 on at

    Hi,

    It seems the issue is related to the Sequence.

    Please try to map the "Model.PositivePayTransaction" just to "Transaction" tag so see if it helps.

    If not you try create a new model without sequence to check if the helps-

    pastedimage1675673108925v1.png

    You can activate "Run draft" to test before you publish the config.

  • Suggested answer
    Arcadi Profile Picture
    796 on at

    What Alireza Eshaghzadeh is right, but don't delete mainSequence, just unmap it.  

  • SAAD Ahmed Profile Picture
    70 on at

    Thanks after un map I am getting a line break in CSV.

    Is there any article from where I can start learning that because I also have to make couple of changes in that like currently  I am not getting a vendor name field in model which I also have to add.

    pastedimage1675769453765v1.png

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    15,225 Super User 2026 Season 1 on at

    Hi SAAD,

    Regarding electronics reporting, you can read following posts on Microsoft docs:

    learn.microsoft.com/.../general-electronic-reporting

    learn.microsoft.com/.../general-electronic-reporting-formula-designer

    learn.microsoft.com/.../er-formula-language

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2026 Season 1

#2
Subra Profile Picture

Subra 370

#3
Martin Dráb Profile Picture

Martin Dráb 283 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans