News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Adding Foreign Currenc...

Small and medium business | Business Central, N...

Suggested answer

Adding Foreign Currency latest value to the report layout

(1) Share

Report

Report

Posted on by salamehelie

Good day,

Kindly advise if there is a way to add the latest currency exchange rate from the currencies list as per operation date to make it show inside my invoice report?

or is there a way to make the user type it as an option when running the report before it print or preview?

thank you so much in advance for your soonest response

best regards,

Elie

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Adding Foreign Currency latest value to the report layout

Hi, on the order or invoice page, you can find a Currency Factor field that records the exchange rate posted at that time.
It is recommended that you display this in the report.

PS: Report extensibility (ReportExtension Object)

https://yzhums.com/10723/

If you need to get it manually from the code, you can refer to the table below.

Currency Exchange Rate (330)

Hope this helps.
Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans