wrong triangulation currency rate

(0) Share

Report

Posted on by Community Member

EUR	GBP	DKK
Amount in transaction currency	Amount	Amount in reporting currency
- 816,54	- 12,67	- 109,60	Result from AX
- 816,54	- 702,95	-6083,22	Correct calculation

I have setup "DKK" as triangulation currency as I have all rates for DKK

I my UK company, i receive invoices in EUR, so I would like AX to do the cross currency rate, but it seem to divide by the currency rate instead of multiplying with it

Date Rates valid in ax are:

7,45 DKK = 1 EUR

8,6539 DKK = 1 GBP

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

If you think, it makes a multiplication instead of a Division, the first place to check is Exchange rates, if the curreincies "From" and "To" are in the right direction. Can you confirm this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

From EUR to DKK (Quotation unit=1) exchange rate is 7,45, does thant answer your question?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi deterhanne,

Why has DKK been setup as triangulation currency?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

We load rates from serveral currencies to DKK daily, when we have legal entities in other countries, I try to do is use the rates i have for DKK to calculate rates between eg EUR and GBP, as I dont have a rate between EUR and GBP

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi deterhanne,

The exchange rates between the DKK, EUR and GBP are not fixed but floating.

Using the rates for DKK to calculate the ones for the other currency pairs must not necessarily result in the actual currency rates that are established in the markets. It might rather give you an indication of arbitrage opportunities.

Why don't you simply import the currency exchange rates for example from Oanda or another exchange rate provider?

The AX standard fully supports such imports.

Best regards,

Ludwig

Was this reply helpful? Yes No