web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to get exchange ra...

Microsoft Dynamics AX (Archived)

How to get exchange rate for specific company in AX 2012 using query

(0) Share

Report

Report

Posted on by SunilRGami

165

Hi,

I have need to write a query in sql which gives me the exchange rate from and to period along with the respective company from the AX 2012 database.

I checked below tables but didn't find the data area id. Can someone tell me which tables needs to involve to get the exchange rate for specific company.

select * from EXCHANGERATE
select * from EXCHANGERATECURRENCYPAIR
select * from EXCHANGERATETYPE

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 303,679 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

On the table Ledger (which represents the DataAreaId == the Legal entity) an exchange rate type is linked.

So from this table you have the link between the exchange rate type and the company.

Was this reply helpful? Yes No
Suggested answer

SunilRGami 165 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your quick help

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans