In this blog, I am going to explain about the new general ledger account statement report using electronic reporting. This is really a helpful report for extracting general ledger transactions.

Note: The General ledger statement by main account report in Excel format is available in Dynamics 365 Finance as of version 10.0.27.

General journal account entries on the report are presented in groups by main account. For each main account, an opening balance is reported that represents the amount in either the accounting currency or the reporting currency at the beginning of the reporting period. Each main account group of general journal account entries is finalized by using a line that presents the total amount of debit and credit turnover at the end of reporting period, and the accumulated balance by main account at the end of the reporting period.

The format of the report uses the language that has been selected as the user’s preferred language in Finance user options.

Setup:

Step-1: Import electronic configurations from LCS

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-download-configurations-global-repo

Step-2: Map format to ledger parameters

Step-3: Enable features in feature management

Generate report

Step-1: Generate and specify parameters

Step-2: Download and view report

Few highlights which I liked:

That’s it for this blog, hope this will help you!!!

Thank you!!! Keep reading and sharing!!!