AX – D365FFO – X++ – Export in EXCEL

Microsoft Dynamics 365 for Finance and Operations has several convenient ways to view, edit and publish data. One convenient way is a feature that opens information in Excel. This feature uses some out-of-the-box Excel templates. By using these templates you directly view, edit and delete data from Excel without any additional import/export functionality.

Although there are multiple system defined document templates available, but still they don’t cover all data entities. In this blog we are going to discuss how to create a custom document template.

I’m using Customer group (CustGroup) data entity in this example.

Step 1: Create an excel resource file. Add Customer Group data entity and map your desired fields on it.

Step 2: Add your excel resource file in the project and reference the resource name of this file in your class.

Step 3: Create template registration class. Extend your class to DocuTemplateRegistrationBase, which is a parent class to populate all document templates. Override registerTemplate() method and write following code to add your custom template along with system templates. Build the project.

Step 4: Go to D365O→ Organization administration→ Setup→ Office integration→ Document templates. Click “Reload system templates”. You will see the new template is added to the list.

Similar link will be available from Customer group setup form.

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo di WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione /  Modifica )

Google photo

Stai commentando usando il tuo account Google. Chiudi sessione /  Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione /  Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione /  Modifica )

Connessione a %s...