web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

Finance | Project Operations, Human Resources, ...

Suggested Answer

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Kevin Xia Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi,

Please see the follwoing link

https://cloudblogs.microsoft.com/dynamics365/no-audience/2016/05/03/using-currency-translation-with-management-reporter-and-ax/

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 565 Most Valuable Professional

#2

André Arnaud de Cal... 450 Super User 2025 Season 2

#3

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans