Belgium: “Export ledger transactions” report performance improvement in Dynamics 365 Finance

Introduction

The “Export ledger transactions” report is used by companies with primary address in Belgium to export the total balance of each ledger account for a specific period to a plain text (ASCII) file in .CED format. You can then import the generated file into third-party software to create an accounting report according to country/region-specific requirements.

Starting from version 10.0.16 of Dynamics 365 Finance, new Electronic reporting (ER) format is available for “Export ledger transactions” report and can be used to achieve better performance of the report generation.

Overview

New “General ledger data export (BE)” format for “Export ledger transactions” report together with “General ledger data model mapping” configuration are available under “Standard Audit File (SAF-T)” model:

Import “General ledger data export (BE)” format from Microsoft global repository. After importing, you must have the following versions, or later versions, of ER configurations:

For more information about how to download ER configurations from the Microsoft global repository, see Download ER configurations from the Global repository.

Note: After all the ER configurations from the preceding table are imported, set the Default for model mapping option to Yes for the General ledger data model mapping configuration on the Configurations page.

Setup

To start using new “General ledger data export (BE)” format, define its ER configuration name in new general ledger parameter:

1. Open General ledger > Ledger setup > General ledger parameters  page

2. Select Ledger tab

3. Expand Electronic reporting fast tab

4. Select “General ledger data export (BE)” format in Ledger transactions export field under Ledger transactions export group.

5. Save new setting.

Generate “Export ledger transactions” report

To generate “Export ledger transactions” report, use the previously used General ledger > Periodic tasks > Export ledger transactions menu item. When new ER format is defined in parameters of general ledger, system will use it instead of the previously used format (“Ledger transaction export format (BE)” under “Ledger transaction export (BE)” model).

1. Click on General ledger > Periodic tasks > Export ledger transactions menu item

2. Specify reporting period in From date and To date fields of the Electronic report parameters dialog page.

3. If accounting currency of your Legal entity is different than EURO and you want to generate the report in EURO, mark “Recalculate to Euro” parameter on the dialog page.
   In case when accounting currency is not EURO but reporting currency is EURO and you select “Recalculate to Euro” parameter, report will be generated with amounts stored in general ledger in reporting currency.
   In case when neither accounting no reporting currency are EURO and you select “Recalculate to Euro” parameter, report will automatically recalculate amounts in accounting currency to EURO by using the exchange rate stored in the system on the date of each transaction in general ledger. In this case, time of the report generation may take longer time then time of the report generation without recalculation.

4. When you generate “Export ledger transactions” report for long period, it is recommended to run it in batch. To run the report in batch, expand “Run in the background” fast tab of the dialog, mark the “Batch processing” parameter and specify other parameters of the batch if needed. Follow up the report generation via “Electronic reporting jobs” page.

5. Click OK button on the dialog, to start report generation.