BeyondERP.Newsletter
Menu

Setup step on the Document templates page · Common

Publish Word and Excel templates

Make Word and Excel templates available on the Open in Microsoft Office menu.

Business process
Administer system features
Menu item
DocuTemplate
Main table
DocuTemplate
Setup steps
2 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you upload and manage the Word and Excel templates that power the Open in Microsoft Office options.
What you do hereUse this page to add templates so that users can create documents, such as Export to Word documents, from the record they are working on.
ExampleFor example, BEAT builds a Word welcome letter for new customers, uploads it on Document templates with Apply current record filter selected, and a sales clerk then opens a customer and selects Open in Microsoft Office > Export to Word to get the letter for that customer only.
Document templates page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Publish Word and Excel templates

Make Word and Excel templates available on the Open in Microsoft Office menu.

Set up Document templates1 screen

Use this page to add templates so that users can create documents, such as Export to Word documents, from the record they are working on.

  1. Screen 1

    Check a document template

    Go to Organization administration > Setup > Office integration > Document templates

    1. Find the template in the list
    2. Check its type, root data entity and display name
    3. Select Download to open the template, or New to upload your own
    1Template nameCustInvoiceJournalTemplate
    Template typeExcel
    Root data entityCustInvoiceJournalHeaderEntity
    Template display nameInvoice journal line
    Defined bySystem
    Check a document template (zoomed on the outlined fields)
    Show the full screenCheck a document template
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Common > Common > Office integration > Document templates.
  2. Select New.
  3. Select Browse.
  4. Select the template you created, and then select Open. The root data entity is read from the template.
  5. Select OK.
  6. Check that the template now appears in the list.
  7. If the template shouldn't be filtered to the user's current record, clear the Apply current record filter checkbox.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Apply current record filterWhen selected, the document uses only the record the user has selected. Clear it to include all records.Microsoft Learn ApplyRecordFilter
Template typeThe Office app the template is for, Word or Excel.Microsoft Learn WordTemplateType
Template nameThe ID that identifies the template.Microsoft Learn CustInvoiceJournalTemplateTemplateID
Root data entityThe root data entity of the template; it decides which pages offer the template.Microsoft Learn CustCustomerV3EntityRootEntityName
Template display nameThe name shown for the template in lists.Microsoft Learn Invoice journal line
Defined byWhether the template is system-defined (registered in code and restored with Reload system templates) or added on this page.Microsoft Learn
Apply company filterWhen selected, the data is filtered to the current company.Microsoft Learn Selected
List in Office menuWhen selected, the template is offered on the Open in Office menu of applicable pages.Microsoft Learn Selected

Common errors and fixes

MessageWhat to do
The template doesn't appear under Open in Microsoft OfficeTemplates are offered only on pages whose root data source matches the template's root data entity, and only when List in Office menu is selected. Microsoft Learn

Test checklist

  1. Build a Word template with the Office add-in from a blank document created with Excel workbook designer > Create blank document.
  2. On Document templates select New, browse to the template and check the Root data entity is filled in.
  3. Set Template display name and decide whether Apply current record filter stays selected.
  4. Open a page with the same root data source, select Open in Microsoft Office > Export to Word and pick the template.
  5. Check the generated document holds data from the selected record (or all records when the filter was cleared).

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Publish Word and Excel templatesKeep Apply current record filter for Export to Word documents about one record; clear it for Excel list templates that should load all recordsThe record filter decides whether the document holds the selected record or the whole list.Who maintains document templates?Uploading a template whose root data entity doesn't match the page's root data source: it is never offered on that page.Test: Template offered on its page
Set up Document templatesKeep Apply current record filter for Export to Word documents about one record; clear it for Excel list templates that should load all recordsWith the filter on, the generated document is limited to the record the user is on; Microsoft's tutorial clears it for an Excel list template so the full list loads.Uploading a template whose root data entity doesn't share the page's root data source. Templates are offered under Open in Microsoft Office only on pages with the same root data source.

Feature management and licence

Licence or add-inOn the live system, these roles can open the page: Maintain document templates.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyShared, with optional filters: a template is offered to all users on matching pages; Apply company filter limits its data to the current company. Microsoft Learn
Can it be undoneReversible: Templates can be edited, removed and downloaded; system templates are restored with Reload system templates.
If you change it laterAdding or changing a template changes the Open in Microsoft Office options users see on every page with the same root data source. Microsoft Learn
Technical architect

6Technical

Menu itemDocuTemplate Checked in Dynamics 365
FormDocuTemplate Checked in Dynamics 365
TableDocuTemplateShown as “DOCUMENT TEMPLATES” in Record infoKey field: TemplateID, LegalEntityID, LanguageID, RegionIDChecked in Dynamics 365
Who can open itPrivilegesMaintain document templates DocuTemplateMaintainDutiesMaintain document templates DocuTemplateMaintainChecked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintain document templates DocuTemplateMaintainGive people a role that holds these duties. On this system, 0 roles give access to this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Download, Reload system templatesChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=DocuTemplate
Data migrationLoad order: Document templates has no data entity in Data management. Download each template with Download and upload it again with New in the target environment; system-defined templates come back with Reload system templates.Microsoft Learn
Table definitionDocuTemplate columns and relations Microsoft data model
Everyone

8Sources

To cite this step: CMN-OFF-020, Publish Word and Excel templates. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CMN-OFF-020