Reporting Currency MR

(0) Share

Report

Posted on by agus

1,174

Hi expert,

My accounting currency is IDR, reporting currency USD. I'd to display trial balance in Reporting currency. but the result for the main account was not the same in general Journal account entry table (reporting currency amount field).

in MR column (currency display) I choose USD, is there any configuration i'm missing ?

I saw in other forum, it should be setup in main account>>management reporter Tab>>currency translation. I thought it different with reporting currency right ?

thanks in advice

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Prashant Singh 8,802 on at

Like (1)

Report

Dear,

In the Management Reporter report definition you can select the check mark "Include all reporting currency". Also you can add more currency in currency display as you said.

For your reference,

This video can help you in the setup

https://www.youtube.com/watch?v=dbkZaIWD0yA

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Agus,

In addition to what Prashant already recommended, you need to define how to convert your accounting currency transactions into your reporting currency used in MR by specifying the exchange rate type and currency translation type in the Chart of Accounts for each and every account setup. Typically Balance sheet accounts are converted by using a closing (current) Translation type and income Statement accounts by using a average Translation type. What type to use depends on the accounting regulations in your country. You can find some additional Information on the Microsoft MR blog. Please see: blogs.msdn.microsoft.com/.../currency-translation

All the best,

Ludwig

Was this reply helpful? Yes No
Verified answer

agus 1,174 on at

Like (0)

Report

oh done, thanks kumar

Was this reply helpful? Yes No
Suggested answer

Prashant Singh 8,802 on at

Like (0)

Report

You are most welcome. Please verify the correct answer of the thread if it helped. So that other people can use the reply in same situation.

Was this reply helpful? Yes No
Tjoa on at

Like (0)

Report

Need help...

I have the same problem. I already tick mark "include all reporting currnency".

But when I view report transaction with reporting currency (USD) balance amount shown accountng currency (IDR).

Anyone can help me...

Thanks.

HT

Was this reply helpful? Yes No
Suggested answer

Prashant Singh 8,802 on at

Like (0)

Report

I will suggest please check the currency code selection in currency display.

Regards,

Prashant Kumar

Was this reply helpful? Yes No
Tjoa on at

Like (0)

Report

I already add currency display, but balance in report is different with balance in general ledger transaction. Any suggest?

Thanks.

Was this reply helpful? Yes No