News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Financial reports Bala...

Finance | Project Operations, Human Resources, ...

Unanswered

Financial reports Balance sheet period end exchange rate

(0) Share

Report

Report

Posted on by Shijith.cxg

7

Dears,

In Financial reports, how to get balance sheet based on period last day's exchange rate in case of currency translations.

For example we need balance sheet as per 31-12-2022 based on the exchange rate of 31-12-2022 in a currency other than accounting for reporting.

Regards

Shijith

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

saurabh bharti 15,033 Super User 2025 Season 1 on at

Like (0)

Report

Financial reports Balance sheet period end exchange rate

Hi,

Please see the follwoing link

https://cloudblogs.microsoft.com/dynamics365/no-audience/2016/05/03/using-currency-translation-with-management-reporter-and-ax/
Kevin Xia Microsoft Employee on at

Like (0)

Report

Financial reports Balance sheet period end exchange rate

Hi,

I tried searching and didn't seem to find any out-of-the-box functionality. Maybe you can try to create an exchange rate, in the report design, you can select the appropriate exchange rate type to ensure the calculations are based on the period-end rate (December 31, 2022).

Best regards,

Kevin

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,001 Super User 2025 Season 1

#2

Martin Dráb 231,833 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans