Create Electronic reporting (ER) configurations - Finance & Operations | Dynamics 365 (2022)

  • Article
  • 10 minutes to read

As part of the requirements for Microsoft Dynamics Lifecycle Services (LCS) solutions for localization and translation, localization ISV solution providers must implement country/region-specific or solution-specific features by using the Electronic reporting tool. This article provides background information that will help you start to use Electronic reporting to create configurations. This article isn't meant to replace any available and upcoming Electronic reporting documentation, but is intended as a supplemental view from the perspective of localization requirements.

Electronic reporting (ER) is a configurable tool that helps you create and maintain regulatory electronic reporting and payments, based on the following three concepts:

  • Configuration instead of coding
  • One configuration for multiple Dynamics 365 Finance releases
  • Easy or automatic upgrade

Using LCS, ER provides one common way for Microsoft and partners to distribute electronic document configurations to other partners and customers. ER also makes it easier for partners and customers to customize, upgrade, and distribute electronic document formats for their specific business requirements.

You can use ER to set up data models that are domain-specific and independent of the database as data sources for document formats. Formats can be configured based on these domain-specific data models by using simple visual tools that are similar to Excel. Data models and formats support versioning, and formats can be date-effective.

Main data flow

(Video) Electronic Reporting in Microsoft Dynamics 365 Finance & Operations | Webinar | ANZ D365 FinOps Team

Data model configuration creation

It's a good idea to reuse and customize data models that are released by Microsoft whenever you can, or to create a business domain area–specific data model that will introduce the abstract model of required entities and their relations. In this way, you will be aligned with future updates that are released by Microsoft, or can at least reuse your model for the design and maintenance of multiple domain–specific electronic documents that have different formats that are required in different scenarios or countries/regions.

Design the data model of the created model configuration

A data model is designed to recognize and describe the required business entities and the relations between them in the selected domain. A data model consists of descriptors that express entities by using data containers (records). Properties of entities are expressed by using data items. A record definition is an entity that contains fields (the data items). Each data item has a unique name, label, description, and value. The value of each data item can be designed so that it's recognized as string, integer, real, date, enumerate type, and so on. Additionally, the value can be another record or record list. A single record definition can be selected as a root of the data model. (A root is the starting point of the entire model for data source mapping.) In this case, the model is used as a data source that delivers data according to the single predefined data flow. If no record definition was selected as a root of the data model, the data model contains record definitions that can be assigned as a root at the format mapping stage. The data flow of such a model can be defined as a data source in multiple ways, depending on the nature of the format. For example, a single data model can be designed for the payments domain area. This data model can include data record definitions for the company as a legal entity, for vendors and customers, and also for payments. However, according to the nature of the format, the data must be presented in the following way: payer > payee > payments. Therefore, a single data model can offer data according to the following alternative paths:

  • Company > vendor > payment for the Accounts payable domain when the company record definition is selected as a root.
  • Customer > company > payment for the Accounts receivable domain when the customer record definition is selected as a root.

Format configuration creation

You use the data model configuration that is created to hold abstract data for a new electronic format that you want to design. If you intend to consume a data model that was prepared earlier when you create a new format, make sure that you select the Format based on data model option for Create configuration. After you a have a format configuration, you must define a format structure. The structure can be created manually or automatically by importing an example of an XML file or an Excel template. The data model of the parent configuration is automatically offered for format mapping, together with a proper root container. Nevertheless, a format might require that data be represented in a specific way. Therefore, you can use formula designer to define expressions as virtual data items (calculated fields) for our data containers.

Note

Although you can map format components directly to database and application artifacts, such as tables or data entities, enumerations, or classes and objects in ER, we don't recommend this approach. It's likely that multiple formats will be maintained in some business domain areas that use the same data sources. Whenever the structure of the database artifacts is changed, the format mapping to those database artifacts must also be changed. The cost of these changes is multiplied by the number of maintained formats. Therefore, we recommend that you work through the data model as the abstract description of the domain-specific data structure, and use the direct binding of format elements to database components only for simplification and for coverage for specific customizations. For example, use direct binding to refer to custom tables when those references are required in a limited number of maintained formats.

(Video) Dynamics 365 Webinar: Electronic Reporting Basics Through Simple Example

Tip

If you still have to add ER data sources to configure a format component to access database and application artifacts at runtime, select Show details on the Action Pane of the Format designer page.

Version control

One of the principles behind the design of Electronic reporting is that it should be easy to distribute a data model and formats together with an enhanced maintenance model for their customizations. All the configurations are versioned, and an existing customization can be "cloned" to derive a new configuration for localization or customization implementation. For example, we represent a company that is named Proseware, Inc. We have subscribed to the service of a company that is named Litware Inc., which provides us with the Intrastat returns configuration and supports all legal requirements in it. We have already received specific configurations, from Litware Inc., together with data model and formats, and have deployed them. Our company is working in a district where, in addition to the federal requirements, we must support the following regional requirements:

  • As part of Intrastat transactions details, our XML file must show the statistical procedure code that isn't required anywhere else.
  • We must limit the length of the company name that is presented in the Intrastat returns header block to 200 characters.

To support these requirements and comply with local district authorities, we must implement this localization as a localized configuration. However, we must keep the link with the origin configuration, so that we can adopt any future changes that are introduced at the federal level as new versions of the origin configuration. Therefore, we import the Litware Inc. origin configuration from LCS, derive it as a new localized configuration, introduce the required changes, complete this work by introducing a first version of the localized format, and start to use it internally. Whenever Litware Inc. offers us a new version of the origin configuration, we import it from LCS, rebase our localized configuration to this version, adopt changes to support new federal requirements, complete this work by introducing a next version of the localized format, and continue to use it internally.

Note

The draft version of any configuration must be "completed" before it can become available locally for further action, such as the following:

  • Make it available so that it can be referenced as a data source from a new format.
  • Enable configuration exchange between companies or instances via configuration import/export, and so on.
(Video) Configure and use Electronic reporting in Dynamics 365 Finance and Operations apps

Electronic reporting domain coverage

Several out-of-box configurations can be used to meet electronic reporting requirements for specific countries/regions. The following list show some examples of format configurations that are grouped into business domains. To get a complete, up-to-date list of available and supported configurations, open a configuration repository setup to show the configurations that are available for import from either resources or an LCS Assets library.

  • Audit file

    • FEC
    • GDPdU...
  • Payments (ISO20022)

    • SEPA CT
    • SEPA DD
    • JBA
    • BACS...
  • Statistical reports

    (Video) Electronic Reporting Business Documents in D365 F&O

    • EU Intrastat...
  • Tax reports

    • CIS
    • BAS
    • ELSTER
    • EU Sales list...
  • Customer e-Invoice

    • OIOUBL...

Your solution uptake

You can choose how to move your electronic reporting functionality into ER. However, you should consider the following high-level steps when you plan that move.

  1. Review the electronic reporting functionality that your solution currently provides.
  2. Identify domain areas that your solution covers, such as Payments and E-Invoices.
  3. Review the configurations that are provided by Microsoft. It's likely that you'll find a configuration that you can use as a base. For example, if your solution customizes the SEPA CT payment format, you should extend the SEPA CT configuration.
  4. Create new configurations that are based on either an existing model or format, or a new model or format.
  5. Define input parameters that users must select when they run the report, and validations for the content of the report.
  6. Define mappings with the model by using arithmetic, string, data, or other available Excel-like functions.
  7. Define labels and translation to different languages, where applicable.
  8. Define templates that have named ranges, and set links from the configuration for the Excel report, if applicable.

Terminology

TermDefinition
ERElectronic reporting is an engine that simplifies the creation of electronic reports for information interchange with governments, banks, and other parties. Currently, Electronic reporting supports text, XML, and OpenXML spreadsheet formats, and provides an extension interface to support more formats.
TransformationIf you have a typical action that must be done on the source of data before it is sent as output to a format, you can introduce a transformation and attach it to format components. Transformation is an ER formula that takes one value as a parameter and returns another value. For example, you have many format fields that contain spaces, and the spaces should be replaced by spaces when the fields are exported. In this case, you can create a transformation that takes a string argument and uses the REPLACE function to do the job. You can then create string components and associate them with that transformation.
Data modelA data model provides a structure for data. This structure is used to abstractly describe certain business domain areas at sufficient detail to satisfy the reporting requirements in this domain.
ConfigurationA container for either a data model or a format, together with its mappings to data sources, that can be maintained and executed, and that supports versioning. The configuration is the entity that will be imported or exported to organize electronic document format exchange between finance and operations instances.
Derive actionAn operation that uses a configuration that already exists as a basis to create a new configuration.
Rebase actionAn operation that updates a derived configuration with changes that were introduced in a new version of the base configuration. The version number is selected at the rebase initialization stage.
Update conflictA conflict that is discovered during the rebase action, where the new base version contains adjustments of a format/mapping element (name, property, and so on) that has also been adjusted in the derived version.
Relocation conflictA conflict that is discovered during the rebase action, where the new base version contains a new position (parent element) of a format element (name, property, and so on) that has also been relocated to a different position in the derived version.
Duplication conflictA conflict that is discovered during the rebase action, where the new base version introduced a new format element that is the same as an element (in other word, it has the same name and child components) that has also been entered in the derived version.

Additional resources

Electronic reporting (ER) overview

Manage the Electronic reporting (ER) configuration lifecycle

Help us understand

We want to learn more about how people use Microsoft's custom Help toolkit. Take the survey (in English) and help us understand: https://forms.office.com/r/A4cUJgjkD1.

(Video) Electronic Reporting & Business Documents for Beginners in D365 Finance & Operations

FAQs

How do I create an electronic report in d365? ›

Electronic Reporting & Business Documents for Beginners in D365 ...

How do you create an electronic report? ›

To start creating your electronic forms, navigate to Settings>Report Settings. In Report Settings, to create a new electronic form, click New Custom Report. This will prompt the following pop-up to fill out the details of the report. Once the settings are saved, click Fields Setup.

What types of reporting are available for Dynamics 365 for finance and operations? ›

These are the houses of Inquiries, SQL Server Reporting Services (SSRS), Management Reporter, and Power BI Embedded.

How do I create a dashboard in d365 finance and operations? ›

Select the Dashboards option, click New, then choose Dynamics 365 Dashboard. Select a layout option, then click Create. Pick the tile where you wish to insert a chart, then use the toolbar to select the Chart option. You can also create a new chart to use in your new dashboard.

What is electronic reporting in d365? ›

Electronic reporting (ER) is a configurable tool that helps you create and maintain regulatory electronic reporting and payments, based on the following three concepts: Configuration instead of coding. One configuration for multiple Dynamics 365 Finance releases. Easy or automatic upgrade.

What formats does Dynamics reporting use? ›

ER currently supports the TEXT, XML, JSON, PDF, Microsoft Word, Microsoft Excel, and OPENXML worksheet formats.

What are electronic reports? ›

Electronic report means a report transmitted to, or otherwise forwarded to, the Central Criminal Records Exchange in an electronic format approved by the Exchange.

How do I create a financial report in D365? ›

To generate a financial report, go to General ledger > Inquiries and reports > Financial reports. Select a report to generate and select Generate. Fill in the Report date field and select OK.

How do I create a report in Microsoft Dynamics CRM? ›

Edit a report
  1. Go to Reports.
  2. To add a new report, select New.
  3. In the Report: New Report dialog box, in the Report Type list, select Report Wizard Report, and then select Report Wizard. ...
  4. Select the starting point for your report. ...
  5. Enter the name of the report, and specify which record types the report will use.
Feb 15, 2022

How do I create a query based report in D365? ›

View Menu-->Application Explorer-->Data Model-->CustTable.

For this you must add the reference model Application Suit in to your project. Change the property Dynamic Fields of CustTable to Yes. Then go to Fields node of the CustTable and remove the unnecessary fields. Next step is Create a SSRS report.

How do I create a dashboard in Dynamics 365? ›

Open solution explorer, and then select Components > Dashboards. Select New, choose a layout, and then select Create. In the Dashboard: New dialog box enter a name for the dashboard. Select one of the component areas and then select the icon for a chart or a list.

How do I create an interactive dashboard in Dynamics 365? ›

Configure interactive experience dashboards
  1. Sign in to Dynamics 365 Customer Engagement (on-premises).
  2. Go to Settings > Customizations > Customize the System.
  3. Under Components, select Dashboards.
  4. In the grid, select New, and then select Interactive experience dashboard in the drop-down list.
Aug 11, 2022

How do I create a personal dashboard in Dynamics 365? ›

Create a personal dashboard

From the Sales, Service, or Marketing area, select Dashboards. Select New, and then select Dynamics 365 Dashboard. Select the layout that you want, such as the 3-Column Regular Dashboard, and then select Create.

What is financial reporting in D365? ›

Financial reporting for the application allows financial and business professionals to create, maintain, deploy, and view financial statements. It moves beyond traditional reporting constraints to help you efficiently design various types of reports. Financial reporting includes dimension support.

What is financial reporting in accounting? ›

Financial reporting aims to track, analyze and report your business income. This helps you and any investors make informed decisions about how to manage the business. These reports examine resource usage and cash flow to assess the financial health of the business.

What do financial reporting teams do? ›

Financial Reporting coordinates the preparation of the quarterly financial statements, various financial analyses, regulatory filings and surveys and the annual financial statement external audit.

How do I customize standard SSRS report in D365? ›

Customize Standard report in Dynamics 365 Finance and operations Steps.
  1. create a project.
  2. Create a new extension table for SalesInvoiceTmp table.
  3. Add new field on SalesInvoiceTmp extension table.
  4. Create new class.
  5. Expand SalesInvoiceTmp table > Events > Oninserting > Right click and copy event handler method.
Oct 17, 2019

Videos

1. Introduction To Electronic Reporting And How To Design The Report Without Coding
(Power Platform Community)
2. Electronic Reporting - Spend report
(Antoine Bastian)
3. Reporting in D365 Finance & Operations/SCM
(DynamicsCon hosted by Dynamics User Group)
4. Ludwig Reinhard - Electronic Reporting Power (ERP) in Dynamics 365 for Finance and Operations
(DynamicsCon hosted by Dynamics User Group)
5. QUICK CONFIG - UK BACS payment file format using Electronic Reporting ER in Dynamics 365 F&O
(SenorTalksDynamics)
6. Send emails from Finance and Operations by using the email templates, and Electronic reporting
(Guide To Learn)

You might also like

Latest Posts

Article information

Author: Jamar Nader

Last Updated: 10/05/2022

Views: 5855

Rating: 4.4 / 5 (75 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Jamar Nader

Birthday: 1995-02-28

Address: Apt. 536 6162 Reichel Greens, Port Zackaryside, CT 22682-9804

Phone: +9958384818317

Job: IT Representative

Hobby: Scrapbooking, Hiking, Hunting, Kite flying, Blacksmithing, Video gaming, Foraging

Introduction: My name is Jamar Nader, I am a fine, shiny, colorful, bright, nice, perfect, curious person who loves writing and wants to share my knowledge and understanding with you.