Currency translation in financial reporting shows repeating transactions

(0) Share

Report

Posted on by Shijith.cxg

Hi,

We enabled balancing dimensions for Brach FD. Each Brach have different currency.

Balance sheet generated from financial reports using "translated to currency" option in column; shows extra amount. When drilling down we can see some of the transactions getting repeated.

What cases this duplication for columns having translated currency.

Due to this we are not able to generate Branch vice financial statements.

Regards

Shijith

All responses (3)

Answers (0)

Hana Xue Microsoft Employee on at

Like (0)

Report

RE: Currency translation in financial reporting shows repeating transactions

Hi Shijith,

Perhaps you could try using the financial consolidation feature, consolidations that involve multiple reporting currencies. By bringing across key setup data, you don't have to do any additional setup in Financial reporting to view any report, in any currency, at any time, for any user.

Generate consolidated financial statements - Finance | Dynamics 365 | Microsoft Learn

Or you can view the discussion of related issues as needed.

(+) Duplicate Record in a report - Dynamics 365 Business Central Forum Community Forum

how to avoid repeated records in rdlc report (microsoft.com)

Best Regards,

Hana
Shijith.cxg 7 on at

Like (0)

Report

RE: Currency translation in financial reporting shows repeating transactions

Thanks for the advice. We will contact Ms support and will update the tread.

Regards

Shijith
André Arnaud de Cal... 293,027 Super User 2025 Season 1 on at

Like (1)

Report

RE: Currency translation in financial reporting shows repeating transactions

Hi Shijith,

Have you tried resetting the datamart database for the Financial reporter? If this is not solving the issue, you might need to contact Microsoft Support.