web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / ER Export with Comma S...
Finance | Project Operations, Human Resources, ...
Answered

ER Export with Comma Separated Values (CSV) file

(0) ShareShare
ReportReport
Posted on by Pedro-Rodriguez 266

Hi,

I need to create a ER Model/Format (Similar to Intrastat/Sales List) to do an export that will generate data in a CSV (Comma separated) file. 

The sample with Intrastat generates XML but it would be great to have some documentation, sample or blog entry that shows how a CSV file can be generated with ER. If anyone knows about a good documentation to do this task it would be nice to have it here instead of losing a lot of time with trial an error. 

Basically what I will do is to generate the data in a intermediary table and generate the CSV from this table, so the data model will be very simple.   

Thanks

Pedro

I have the same question (0)
  • Suggested answer
    Pedro-Rodriguez Profile Picture
    Pedro-Rodriguez 266 on at
    RE: ER Export with Comma Separated Values (CSV) file

    Thanks. I already solved it looking at the EU Sales List (DE). Anyway I will look also at it now.

  • Verified answer
    nunomaia Profile Picture
    nunomaia 18 Moderator on at
    RE: ER Export with Comma Separated Values (CSV) file

    Take a look on EU SALES LIST (SE ) if is similar what you need 

  • Pedro-Rodriguez Profile Picture
    Pedro-Rodriguez 266 on at
    RE: ER Export with Comma Separated Values (CSV) file

    Maybe not by default but with some extra work should be possible to put the commas in there. Probably at the beginning with columns of the same width should be enough. I think that looking how the EU Sales List Format is done will be sufficient.

  • Ankit Life Profile Picture
    Ankit Life 622 on at
    RE: ER Export with Comma Separated Values (CSV) file

    Hi Pedro-Rodriguez,

    As per my understanding in Standard ER, CSV format is not available. You could try to create and generate the file in Excel and then save the excel file into CSV.

    Regards,

    Ankit Arora

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 764 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 619 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans