D365 F&O Electronic Reporting

Electronic Reporting is one option for Functional consultants who do not know more about coding and can design reports, extract data from the system

Scenario: Edit ER Fixed asset roll forward to add 4 fields from fixed asset table, and book: financial dimensions 1, financial dimensions 2, location, and Depreciation period remaining

What we need to do

Import standard report > Create Data model > Create Report Format > Edit Data Model > Mapping Data model to Data Source > Edit and mapping FA Roll forward report > Run report

Import standard Fixed asset roll forward report

Create new Data Model

Create new Report FA roll forward

Edit Demo-Data Model

Mapping Demo-Data Model to Datasource

Edit and mapping Fixed Asset Roll Forward report

Run test new report

Conclusion

Import standard Fixed asset roll forward report

We need to import the Fixed asset model and Fixed asset roll forward

Link reference: learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/electronic-reporting-import-ger-configurations

We select the Fixed asset model and Fixed asset roll forward as below screenshot to import the standard report.

Create new Data Model

Because MS does not allow editing directly in the standard Data model "Fixed assets model". So, we need to create a new data model based on the standard data model. In my scenario, I named as "Demo-Data model"

Path: Organization administration > Electronic reporting > Reporting Configurations

After create a data model, we need to active by changing status from draft to complete

Create new Report FA roll forward

Because MS does not allow editing directly in the standard report "Fixed Asset Roll Forward". So, we need to create a new report based on the standard report. In my scenario, I name it "Demo-FA roll forward"

Path: Organization administration > Electronic reporting > Reporting Configurations

Select “Fixed asset roll forward”
Select “Create configuration”
Select “Derive from Name: Fixed asset roll forward, Microsoft”
Name: Input your report’s name
Select the Data model in the previous step
Choose the correct Data model version

Edit Demo-Data Model

Export standard report Excel file

To know which fields are lacking from the standard report, we will export the standard report and define which fields we want to add more.

Path: Demo-FA roll forward > tab versions > select attachments, Then click Open to export the standard Excel file

Here is the exported Excel file detail

Add new fields in the Data Model

Path: Demo-Data Model > Designer > Fixed assets entry point(FixedAssetsEntryPoint) > AssetRollForwardTotalsByGroup > Lines

In my scenario, I will add 4 more fields: financial dimensions 1, financial dimensions 2, location, and Depreciation period remaining.

Location: Item Type = String
FD1: Item Type = String
FD2: Item Type = String
Depreciation period remaining: Item Type = Real

Mapping Demo-Data Model to Datasource

Path: Demo-Data Model > Select Map model to datasource > Select Designer

Choose the Data Model field and then Bind to a field in Data Sources

In my case, I am binding a new field Location in the Data Model with Location in Fixed Asset table in Data sources.

Data Model. Location = Data Source. AssetRollForwardTotalsByGroup > Lines > Relations > >Relations > Fixed assets(AssetId) > Field > Location
Data Model. Depreciation period remaining = Data Sources. AssetRollForwardTotalsByGroup > Lines > Relations > >Relations > Fixed assets(AssetId) > Methods > assetBookCurrent() > Fields > Depreciation periods remaining (Life TimeRest)
Data Model. FD1 = Data Sources. AssetRollForwardTotalsByGroup > Lines > Relations > >Relations > Fixed assets(AssetId) > Methods > assetBookCurrent() > Relation> >Relations > Dimension Code Set (DefaultDimension) > Fields > Dimension value (FD1)
Data Model. FD2 = Data Sources. AssetRollForwardTotalsByGroup > Lines > Relations > >Relations > Fixed assets(AssetId) > Methods > assetBookCurrent() > Relation> >Relations > Dimension Code Set (DefaultDimension) > Fields > Dimension value (FD2)

After completing mapping > Select Save

Change Demo-Data Model status from draft to complete to active edited version.

Edit and mapping Fixed Asset Roll Forward report

Edit the standard report excel file by adding 4 new fields as my scenario, and save as the Excel file, then name excel file “FixedAssetRollRorward_demo”

Import and map 4 new Excel fields and Data Model

Import the edited Excel file to the Report Demo-FA roll forward

Path: Fixed assets model > Fixed asset roll forward > Demo-FA roll forward > Select Designer

Change the Data model version for the report

Bind new fields in report with Data Model fields

Change Report Demo-FA Roll Forward status from Draft to Complete

Run test new report

Path: Fixed Assets > Inquiries and reports > Transaction reports > Fixed asset roll forward

In parameter, change Format mapping by the new Fixed asset roll forwar report.

Here is the result:

Conclusion

ER gives you one more option to create and design your report dynamically.

ER is a good tool that allows FC could modify existing reports or create new reports (excel, doc, xml…). You could design format, group, and parameter... as your needs.
We could utilize a lot of standard forms, and reports from the system. In my scenario, I could create a Fixed Asset Report for the Vietnam Accounting System without coding by utilizing the standard Fixed Asset Roll Forward.

Page updated

Google Sites

Report abuse