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

Announcements

No record found.

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
    14,839 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
    14,839 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
    14,839 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans