Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
This article explains how to set up the basic functionality for Electronic reporting (ER). It also describes the steps that you must complete before you can set up ER.
Prerequisites for ER setup
Before you can set up ER, you must set up the required document types in Document management:
- A document type for Microsoft Office documents that are used as templates for ER reports.
- A document type that is used to store the output of ER reports in the jobs archive.
- A document type that is used to store the output of ER reports so that they can be viewed in other programs.
- A document type that is used to keep baselines of outputs of ER configurations.
- A document type that is used to handle files in the ER framework for all other purposes.
For each document type, the following attribute values can be selected.
| Attribute name | Attribute value |
|---|---|
| Class | Attach file |
| Group | File |
| Location | Azure storage or SharePoint |
Set up ER
Use the following procedure to set up the basic functionality of ER for all legal entities.
- Open the Electronic reporting workspace page.
- Click Electronic reporting parameters.
Main parameters
On the General tab of the Electronic reporting parameters page, set the following ER parameters:
Enable design mode
- Set this option to Yes to enable embedded ER designers, so that users can create their own ER configurations.
- Set this option to No to require that users access the functionality of ER designers by signing up for Configuration service.
Disable tracing of ER performance in data handling
- Set this option to No to allow Microsoft Telemetry to collect information about the average time that is required to process a single incoming or outgoing record as an ER configuration. This information is tracked as a specific health metric of the environment, and it will help Microsoft quickly identify and address issues that affect customers who use the ER framework.
- Set this option to Yes to stop collecting telemetry information.
Parameters to manage documents
On the Attachments tab of the Electronic reporting parameters page, set the following ER parameters:
Configurations – Select a document type to specify the storage of templates of ER formats. This document type is selected within the scope of a specific company. This document type will be used, regardless of the company that a user is signed in to while an ER format is being used.
Job archive – Select a document type to specify the storage of generated documents that are attached to the records of the ER jobs archive. This document type is selected as a company-specific document type. You must make sure that the selected document type is configured for every company that you plan to run ER formats for, and then store the results in the ER jobs archive.
Temporary – Select a document type to specify the storage of generated documents that are used for other purposes. For example, documents might be generated for preview by other services. This document type is selected as a company-specific document type. You must make sure that the selected document type is configured for every company that you plan to run ER formats for, and then store the results in the ER jobs archive.
Baseline – Select a document type to specify the storage of documents that are used as baselines during the automated testing of ER configurations. This document type is selected as a company-specific document type. You must make sure that the selected document type is configured for every company that you plan to run ER formats for, and then store the results in the ER jobs archive.
Others – Select a document type to specify the storage of generated documents that are used for all other purposes. This document type is selected as a company-specific document type. You must make sure that the selected document type is configured for every company that you plan to run ER formats for, and then store the results in the ER jobs archive.
Stop making backup copies of templates
- Set this option to No to automatically create a backup copy of any ER format configuration template and store the copy in the database storage.
- Set this option to Yes to stop making backup copies of ER formation configuration templates.
For more information, see Backup storage of ER templates.
Runtime parameters
On the Runtime tab of the Electronic reporting parameters page, set the following ER parameters:
- Autofit row height - When selected, this setting ensures that the height of a row configured in an Excel template as an AutoFit Row Height and containing at least one merged cell with wrap text alignment, is automatically adjusted at runtime. This adjustment occurs when the merged cell is filled with large text, allowing all wrapped content to be fully visible without manual resizing.
- Query timeout (seconds) - As of version 10.0.46 of Finance, the ER engine supports manual configuration of query timeouts during runtime. The default value of 0 retains the system’s standard timeout, but users can now define custom duration for queries in ER runtime, improving flexibility and execution control.
Active ER configurations provider
On the Configuration provider table page, create ER provider records. Each provider can be marked as Active. The active provider's name and internet address are stored in an ER configuration, as attributes of the configuration owner.
Optional setup for ER
In addition to the basic functionality, ER has other functionality that you can set up.
- On the Electronic reporting destination page, define the ER output destinations for each file output of each ER format configuration. Use the document types of the Document management framework that you set up earlier. You can also use this page to set up the optional ER functionality for each legal entity. For more information, see Electronic reporting (ER) destinations.
- When you add new Application Object Tree (AOT) artifacts or update existing AOT artifacts that are used as data sources (tables, views, or data entities) in ER, use the Rebuild table references menu item (Organization administration > Electronic reporting > Rebuild table references) to bring your AOT changes into the ER metadata.
Frequently asked questions
Question: I have added a custom table to the AOT. I created a new ER model mapping configuration for my ER data model. During the design of the model mapping, I tried to add a new data source type, Table records, that refers to my table. I could manually add my table name to the Table lookup, and the ER model mapping accepted it without errors or warnings. However, my table's name isn't included in the list of available choices that the Table lookup of this data source offers. How do I include the name of my table?
Answer: To include the name of your custom table in the Table lookup, use the Rebuild table references menu item as described in the "Optional setup for ER" section earlier in this article.
Question: Why can't I mark the Microsoft provider as Active in the Electronic reporting workspace in my production environment?
Answer: The Microsoft provider is used to mark ER configurations that have been designed and maintained by Microsoft. We expect that Microsoft will release new versions of the configurations in the future. We recommend that you not mark the Microsoft provider as Active. Otherwise, you can update the configurations. (For example, you can change the content and register new versions.) These updates will cause issues in the future, when Microsoft provides new versions of the configurations, and those new versions must be imported and adopted. Instead, register a new ER provider for your company, and use it for your ER configurations maintenance. To reuse a Microsoft configuration, select it as the base for your derived copy. To incorporate changes that are provided by Microsoft, rebase your configuration to a new version of the Microsoft configuration when it becomes available.
Question: I successfully ran an ER format in one company. However, when I ran the same ER format in another company and used the same settings, I received the following error message: "The provided document type is not a File type." Why?
Answer: Most likely, the second company doesn't contain document types that have been selected in the Job archive, Temporary, Baseline, and Others ER parameters. To fix this issue, configure these document types in the second company.