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 / Microsoft Dynamics AX (Archived) / Exporting from Master ...
Microsoft Dynamics AX (Archived)

Exporting from Master Detail Form

(0) ShareShare
ReportReport
Posted on by Community Member

Hi community,

I just want to touch base with you on how to export a customer master form into excel spreadsheet?

Under sales demographics section, I am hoping to export that into spreadsheet with the name of the Employee Responsible.

Hope to hear back from you all.

Kind regards,

Justin

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Exporting from Master Detail Form

    Hi Andre, where is the collections list page you are referring to?

    Hope to hear back from you.

    Kind regards,

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at
    RE: Exporting from Master Detail Form

    Hi Justin,

    On the collections list page, there is an option to create overviews in Excel. This is creating multiple sheets in one workbook. You can try to learn from this example.

  • Community Member Profile Picture
    Community Member on at
    RE: Exporting from Master Detail Form

    Thanks for the info Andre. Are there any training materials/references I could download from here on how to use Microsoft dynamics ax 2012?

    I kinda know what you mean, I am just hoping if there are any "how to" modules in creating a customise excel sheet from ax dynamics.

    hope to hear back from you.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at
    RE: Exporting from Master Detail Form

    Hi Justin,

    You can use the Dynamics AX connector in Excel to retrieve data from the tables. In that case, you can refresh the data from within Excel.

    It is also possible to create a customization where you create one Excel sheet in coding and then fill it with your required information.

  • Community Member Profile Picture
    Community Member on at
    RE: Exporting from Master Detail Form

    Hi Darren,

    Thank you the quick response. Apologies for the confusion.

    I am hoping to extract different data from AX into the spreadsheet. For example, I want to export data from All Customers Modules and My new opportunities module into excel. I hope it makes sense? how do I also know if I am using the Dynamics AX connector?

    My main purpose is to extract information from All Customers spreadsheet and my New Opportunities spreadsheet and export it into one single spreadsheet.

    Hope to hear back from you.

    Kind regards,

    Justin

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at
    RE: Exporting from Master Detail Form

    Hi Justin,

    If the standard Export to Excel is not working for you, you might need a customization or create an Excel template using the Dynamics AX connector.

    Do you need just one record or all for an integration? What is the exact purpose?

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans