BeyondERP.Newsletter
Menu

Setup step on the Document templates page · Organization administration

Set up Document templates

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.

Business process
Administer system features
Menu item
DocuTemplate
Main table
DocuTemplate
Setup steps
1 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, a Word template built for customers can be uploaded here, and users can then create a document that contains the data of the selected customer.
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

Business processAdminister system features
Menu pathOrganization administration › Setup › Office integration › Document templates
Set up firstExcel workbook designer Microsoft Learn
Used next byOpen in Microsoft Office menu Microsoft Learn
In this process Set up Throttling priority mapping · Set up B2B Invitation Configuration
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

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 Organization administration > Setup > 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 typeExcelTemplateType
Template nameThe unique name of the template.Checked in Dynamics 365CustInvoiceJournalTemplateTemplateID
Root data entityCustInvoiceJournalHeaderEntityRootEntityName
Template display nameThe name of the template as users see it.Checked in Dynamics 365Invoice journal line
Defined bySystem

Test checklist

  1. Upload a Word template built in the Word add-in and check Root data entity is filled from the template.
  2. Set Template display name and keep Apply current record filter selected.
  3. Go to a page with the same root data source, select Open in Microsoft Office > Export to Word and pick the template.
  4. Check the document contains only the current record's data.
  5. Upload an Excel template with the filter cleared and check Open in Excel loads all records.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
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.
Solution architect

5Design impact

Can it be undoneReversible: Templates and their filter settings can be edited or replaced at any time. System-defined templates can be restored with Reload system templates.
Technical architect

6Technical

Menu itemDocuTemplate Checked in Dynamics 365
FormDocuTemplate Checked in Dynamics 365
TableDocuTemplateShown as “Document templates” in Record infoChecked 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 pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=DocuTemplate
Table definitionDocuTemplate columns and relations Microsoft data model
Everyone

8Sources

To cite this step: OA-SETUP-180, Set up Document templates. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/OA-SETUP-180