You’re offline. This is a read only version of the page.
1,295
Hi guys,
I would like to seek help from you guys. I have questions:
1. PurchTable has Currency Code Field and I would like to ask if how to get the rate(in ExchangeRateCurrencyPair Table) but i have created a code:
display VendExchRate dispExchangeRate()
{
ExchangeRate exchangeRate;
ExchangeRateCurrencyPair exchangeRateCurPair;
PurchTable purchTable;
PurchLine purchLine;
VendTable vendTable;
//Select query - Purch Table
select * from vendTable join exchangeRateCurPair where this.Currency == exchangeRateCurPair.FromCurrencyCode;
//Select query - Exchange Rate Currency Pair
select * from exchangeRate where exchangeRate.RecId == exchangeRateCurPair.RecId ;
return exchangeRate.ExchangeRate;
}
2.
The currency CNY -MYR conversion has 2 data which displays valid exchange rates for the date range how to display according date range?
Hoping for your fast Response.
*This post is locked for comments
I solved my problem on how to get the exchange rate based on the currency given on start date in Exchange Rate Table.
To get the exchange rate base on currency in PurchTable:
"ExchangeRateHelper::getExchangeRate1_Static(Ledger::current(),purchTable.CurrencyCode,today());"
Thank you nitesh Ranjan also for the help and giving me the idea. :)
As per my understanding you are on right track.
Please validated that this method exchangeRateHelper.getExchangeRate1() is returning your expected value.
purchOrderHistoryTmp.OrderAccount = purchTable.OrderAccount;
purchOrderHistoryTmp.PurchName = purchTable.PurchName;
purchOrderHistoryTmp.CurrencyCode = purchTable.CurrencyCode;
purchOrderHistoryTmp.LineAmount = purchTable.amountInvoicedExclTax();
"purchOrderHistoryTmp.ExchangeRate = exchangeRateHelper.getExchangeRate1();"
I add this "purchOrderHistoryTmp.ExchangeRate = exchangeRateHelper.getExchangeRate1();" in my RDP class and I want to connect it based from currency code in PurchTable. I don't know if it's right.
you can use this class in your SSRS reports RDP class.
A RDP class of a SSRS report basically populates a temp table which is basically a data set to a table.
so in reports temp table create a field for exchange rate and populate the field using ExchangeRateHelper class
Please verify and update us if this information helps you.
Consider utilizing following class
ExchangeRateHelper
This class is having all the methods to find out the exchange rate value.
Please verify and update us if this is helpful
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...
291,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (