Generate ledger statement by main account in Microsoft dynamics 365 finance and operations

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!!!

3 comments

  1. Hi Saurabh,
    I am not seeing the ER parameters screen while generating the report. What could be wrong?
    Thanks,
    Pankaj

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s