Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Currency translation i...
Finance forum
Unanswered

Currency translation in financial reporting shows repeating transactions

Posted on by 52

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

  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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 Profile Picture
    Shijith.cxg 52 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans