Microsoft Dynamics AX (Archived)

Exchange rate (Purchase Order)

(0) Share

Report

Posted on by SII1MNL

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;
}

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 have the same question (0)

All responses (7)

Answers (3)

Sort by

Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report
Copy link

Link copied!

So i can place it in SSRS report? To get the result, according from what date? Because I am creating a report and i need to display the rate of each currency code according from what date it was created.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

As per my understanding you are on right track.

Please validated that this method exchangeRateHelper.getExchangeRate1() is returning your expected value.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report
Copy link

Link copied!

"Please validate that this method exchangeRateHelper.getExchangeRate1 () is returning your expected value. "

-I run my report and it throws an error.

I have 2 currency code here. Hope you can help me with this. I'm new to this.

Was this reply helpful? Yes No
Verified answer

SII1MNL 1,295 on at

Like (0)

Report
Copy link

Link copied!

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. :)

Was this reply helpful? Yes No