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
How can i get the value in relational exch. Rate amount from this page
Can you try to use the currency factory and do reverse calculation.
You should be able to get the exchange rate
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (