Generate the trial balance with transactional detail report (New Feature) in Microsoft Dynamics 365 finance and operations

This feature lets you generate a trial balance with transactional detail. The transactional detail provides information such as the transaction date, voucher number, and transaction description. The report includes opening balances, debit or credit amount, a running balance, and the resulting ending balances for a given date range. The report can also be run to include pending ledger transactions, providing a provisional report for analysis of how unposted transactions will impact account balances.

This report was available in AX 2012 and now it is available in D365 as well.

Pre-Requisites:

1. This is available in Version 10.0.13 (Update 37)
2. Enable feature through feature management

Now, we running this report we need to import the electronic reporting configuration from repository.

Step-1: Open Global Repository

Navigate to, Electronic Reporting workspace > Select Configuration Provider > Select Global > Click Open

Step-2: Import configuration file

Search for Trial balance > Select all configuration > Import

Step-3: Check in Reporting Configuration

Imported configuration should be available in Reporting configuration workspace

Navigate to, Electronic Reporting workspace > Reporting Configuration

Now we can run the detailed trial balance report

To run navigate to, General Ledger > Inquiries and Reports > Trial balance with details > Enter Require parameters > Ok

Review the downloaded file data. This gives for each Account opening, transactions and closing balance details.

Hope this will help customers to validate and get insights of detailed trail balance.

Thank you!!! Keep reading and Sharing!!!