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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 304,932 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Shijith.cxg 7 on at

Like (0)

Report
Copy link

Link copied!

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

Regards

Shijith

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No