web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to get the Currenc...
Small and medium business | Business Central, N...
Suggested Answer

How to get the Currency exchange rate in the sales order

(0) ShareShare
ReportReport
Posted on by muaz deyab 90

I created a report to display the data from sales order but I still need to add the currency exchange rate. I can get this value from Currency Exch. Rate Table but when the change  it from the assist edit button in currency code field in the sales order card it does not update it 

2308.Capture.PNG

How can i get the value in relational exch. Rate amount from this page 

I have the same question (0)
  • T_Mauser Profile Picture
    T_Mauser 397 User Group Leader on at

    Hello, as far as I know this page doesn't have any source table. It uses dynamic data means it pulls the exchange rates from the table 330 "Currency Exchange Rate".

    The necessary data is saved as global variable inside the page, when you choose your currency code.

    If you change the value it is only saved inside that page (Dialog).

    I don't know if it's possible to get data from a page inside a report - never tried that before.

    As a workaround you can add a new field to the SalesHeader and push the changed Relational Exch. Rate Amount to that field.

    So you can add that field to your report...

    Tom

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,165 Moderator on at

    You can use the currency factor field on the sales header table. I think it is field 32. To calculate what currency exchange rate have been used on a specific order.

  • Suggested answer
    divyeshchitte Profile Picture
    divyeshchitte 970 on at

    Can you try to use the currency factory and do reverse calculation.

    You should be able to get the exchange rate

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,902 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 580 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans