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

How to add new entity in open in excel functionality

(0) ShareShare
ReportReport
Posted on by 3,008

Hi all,

I need to add new entity"Period discount line " below periodic discount entity in all discounts form, which can be found in Retail -> Pricing and discounts -> All discounts.

Anyone please guide how to do this. find the screenshot for the reference

2744.OpenInExcelForum.png

I have the same question (0)
  • Blue Wang Profile Picture
    Microsoft Employee on at

    Hi Krishna,

    When will an entity show as an Open in Excel option?

    When an entity has the same root datasource (table) as a form, it will be added as an option in the Open in Excel section of the Open in Microsoft Office menu.

    How can an entity be added as an Open in Excel option on a form that doesn’t share the same root datasource?

    A generated Open in Excel option can be added on any form by implementing the ExportToExcelIGeneratedCustomExport interface. When adding a generated option programmatically, the set of fields can be explicitly specified.

    Please read this Doc:docs.microsoft.com/.../office-integration-edit-excel

  • krishna.rao@dax Profile Picture
    3,008 on at

    Thanks Blue wang, I am looking into it.

    I haven't find practical examples over internet, or any blogs.

    anyone please share your experience on this requirement or any blogs?

    Also in MS link https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/office-integration-edit-excel 

    mentioned, form FMRental extends and implents as well, whereas in AX I found it only extends formRun, does it mean in standard form we need to do changes? please share your guidance here how to do this step, also I didn't find objects in AX "ExportToExcelIGeneratedCustomExport,ExportToExcelITemplateCustomExport". find the screenshot for reference. many thanks

    pastedimage1582545053476v1.png

  • Suggested answer
    Sukrut Parab Profile Picture
    71,735 Moderator on at

    Here you go , another example you can refer-

    ievgensaxblog.wordpress.com/.../

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 658

#2
André Arnaud de Calavon Profile Picture

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

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 333 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans