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

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Suggested answer

saurabh bharti 15,059 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please see the follwoing link

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

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 528 Most Valuable Professional

#2

André Arnaud de Cal... 455 Super User 2026 Season 2

#3

CU10121822-0 376

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans