Get currency exchange rate by specific date by X++

(0) Share

Report

Posted on by CBNestor

Hi all,

I am working on customizing the Cost Estimates and Costings Report by retrieving the result from the Sales Line Price minus(-) the cost of production.

I already have the sales price that is linked to the production (TransRefId/CollectRefProdId). The problem comes when the Currecy from the sales is different from the company we are working with.

so pulling out the currency by X++ at the moment the sales was made is the only option I can think of.

I have just coppied a code from this community https://community.dynamics.com/ax/b/hellodax/posts/get-currency-exchange-rate-using-ax-class

but is not working well all the time, as you can see in pictures is taking correctly the currecny from EUR to any other currency but is not taking for example PLN to DKK .

Thanks a lot for your time, your help is greatly appreciated

I have the same question (0)

All responses (9)

Answers (0)

WillWU 22,361 on at

Like (0)

Report

Hi Nestor,

Have you tried the findByDate() method on the table ExchangeRate?

community.dynamics.com/.../how-to-get-exchange-rate-in-x

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi CBNestor,

I would change the final info message to get currency codes from ExchangeRateHelper.parmFromCurrency and ExchangeRateHelper.parmToCurrency, to be sure that values were passed correctly to ExchangeRateHelper class.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Hi Sergei,

Looks like is taking the parameters correctly

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Hi Will,

Thanks for fast reply. I will take a look to the code and see if works

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Will I tested the Code. I can see is looping directly to the table

Is not making the right triangulation between EUR and other. that means I have EUR-PLN and EUR-DKK it wont bring any result when asking for PLN-DKK.

that means if I delete the PLN to DKK from the ExchageRatePair table it wont give me any currency even though the sales transaction was made long time ago when this rate in fact did exist

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Nestor,

Please check the exchangeRateCurrencyPair table, does it have a record links PLN and DKK?

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Hi Will thanks for replay

I am plannig to Let the AX update the currency rate from the EU Bank actual currency rate. So the PLN-DKK should not exist. thats why this code wont work so well for me in the future.

Was this reply helpful? Yes No
Suggested answer

CBNestor 46 on at

Like (1)

Report

Finally Resarching a bit

A found a solution which is supplied and well explained by Microsoft in this Paper = Shared Currencies and Exchange Rates for Microsoft Dynamics AX 2012

They explain the necessary codes needed on each situation, like mine, here a pic of the code to get the currency between two currencies , ExchangeRate1 and ExchangeRate2 are griven. Also the Euro triangulation is always taken in consideration, also works for any combination outside the euro triangulation.

someone please set this as Solved.

thanks a lot for your time, appreciated.

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Nestor,

Thanks for your sharing!

Was this reply helpful? Yes No