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

How to get the Currency exchange rate in the sales order

(0) Share

Report

Posted on by muaz deyab

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

All responses (3)

Answers (0)

Suggested answer

divyeshchitte 950 on at

Like (0)

Report

RE: How to get the Currency exchange rate in the sales order

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

You should be able to get the exchange rate
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to get the Currency exchange rate in the sales order

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.
T_Mauser 397 User Group Leader on at

Like (0)

Report

RE: How to get the Currency exchange rate in the sales order

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