Finance | Project Operations, Human Resources, ...

Line break in Electronic Reporting

(0) Share

Report

Posted on by SAAD Ahmed

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)

All responses (8)

Answers (0)

Suggested answer

Arcadi 794 on at

Like (1)

Report

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 ",".

Was this reply helpful? Yes No
SAAD Ahmed 70 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi SAAD,

Can you share info about mapping for "Transactions"?

Was this reply helpful? Yes No
SAAD Ahmed 70 on at

Like (0)

Report

Hi Alireza,

I'm using this mapping

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (1)

Report

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-

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

Was this reply helpful? Yes No
Suggested answer

Arcadi 794 on at

Like (1)

Report

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

Was this reply helpful? Yes No
SAAD Ahmed 70 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No