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

I have the same question (0)

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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!!!

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
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,

Was this reply helpful? Yes No