web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :

Generate Default Finance, SCM and WHM Templates from Microsoft Dynamics 365 Finance and Operations

Ramit Paul Profile Picture Ramit Paul 22,797 Most Valuable Professional

Dear Microsoft BizApps Community,

Welcome to my next blog on Generating default data Templates for ERP implementation from Dynamics 365 Finance and Operations

In this blog, we shall see how we can generate module wise data entity templates for specific modules for a fresh implementation.

Problem statement-

In each D365 Implementation, the very basic starting point is, we need to discuss with the module wise templates with Business team, based on the same templates, they provide us the data and then we import, configure those in D365,

However, at time, to get templates like data entity module wise can be time taking and sometime can be missed to share the important templates, which further leads to the project sprint delivery delay

Solution

MSD365 has a very easy and one click solution to generate the templates for individual modules and Consultants does not need to individually export and send to send to business users

Lets explore

Navigate to System Admin from any of your environment, this is possible in any devbox or sandbox

Then Navigate to templates Workspace

 pastedimage1648275489033v1.png

pastedimage1648275519405v2.png

Click on the "Templates", the below page will open

 pastedimage1648275542075v3.png

Now, select “Load default templates"

 pastedimage1648275566040v4.png

Now, we can select all or click on “Load all”, this will load and fetch all the templates existing in D365

 pastedimage1648275582865v5.png

From there, this will take some time to load all the templates from D365

pastedimage1648275603154v6.png

Now, all the templates are loaded and created those as individual module wise

pastedimage1648275619967v7.png

Hence, whenever required, we shall export these templates and send those to business team or we can review this and show in the discussion with business

Create an export project from Data Management workspace

 pastedimage1648275636076v8.png

Click on “Add template” and select the templates from the drop down and target data as excel etc.

After that, all the data entities template for the module will be fetched and can be exported for further work with business

pastedimage1648275656530v9.png

pastedimage1648275700178v10.png

Not only thus- we can create our own template and then ad the required data entities and then re-use that for future purpose.

This can be done from Template workspace, from where we loaded the default templates, then create new add data entities and save the template

 pastedimage1648275718530v11.png

That's it for this blog, thank you for checking this space.

Stay tuned for my next article, God Bless You

Comments

*This post is locked for comments

  • combese Profile Picture combese 102
    Posted at
    Generate Default Finance, SCM and WHM Templates from Microsoft Dynamics 365 Finance and Operations
    That is why I choose to use the Import/Export template freature in the 'Templates' form to move setup and references for a specific company from one instance to another.
    But the export menu item is not exporting anything!
    When i focus on one of the default templates, and click 'export template', no data files are generated.
     
    regards,
     
  • combese Profile Picture combese 102
    Posted at
    Generate Default Finance, SCM and WHM Templates from Microsoft Dynamics 365 Finance and Operations
    Hi Ramit,
    I want to move setup, reference, master data for a specific company from one environment to another.
    If I create and run an export project that includes a template, then importing the resulted excel files into the other environment will be lengthy process.
    What do you think?
  • Nagakirthi Profile Picture Nagakirthi 17
    Posted at
    I have opened a channel for this issue. kindly post the resolution community.dynamics.com/.../unable-to-load-default-templates-in-data-management-workspace
  • Nagakirthi Profile Picture Nagakirthi 17
    Posted at
    Hi, Unable to Load default templates in Data management workspace. When i try to load templates, i get the error message that they dont exist in the target environment. Kindly help as it is stopping my work