Management Reporter Data Mart and Historical Rates

(0) Share

Report

Posted on by Kelly Top

How can I get MR Data Mart to pick up the historical currency rates? The account is already set to translate at historical, however, when I generate a report in MR it is using the average rate. I have checked the Exchange Table and there is a valid rate dor that transaction date.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Management Reporter Data Mart and Historical Rates

I believe there is one thing missing and you need to consider, go to Cards > Financial > Accounts.

Click on "Currency" to open the account currency window, on which you have an option for "Currency Transaction Type", it includes the following three types:

Average

Current

Historical

Your feedback is highly appreciated,
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Management Reporter Data Mart and Historical Rates

Management reporter take the exchange rate in GP based on the Rate ID and calculation method set on the Multicurrency window. Please check the rate ID mapped in that window and generate the report again to verify the same.

Hope this helps!!!
Community Member on at

Like (0)

Report

RE: Management Reporter Data Mart and Historical Rates

Did you ever sort this out. I have the same issue?