You’re offline. This is a read only version of the page.
Our company is in process of converting over the FRx Financial Reporting to Management Reporter on the Legacy version. We have two different company databases one for US Company and the other is Canadian.
The Balance Sheet accounts have one multi-currency rate while the Profit & Loss accounts have another currency.
When the Balance Sheet would be generated in FRx Financial Reporter it would use one rate to calculate the financial report. With Management Reporter it is two rates to calculate based on the posting type. This is causing a discrepancy between these two reports.
One rate is for the Trial Balance {Balance Sheet Rate} , but a different rate for the P&L. Can Management Reporter use a single rate for the whole trial balance?
Does anybody have a recommendation on this would be better handled?
*This post is locked for comments
I have the same question (0)Hi Kevin,
MR reads all the currency translation information from GP. In FRx, you would set up the rates in FRx and then use CCSPOT or CCHIST on the rows. So regardless of the type of account, you could set it to use a spot rate or a historical rate. In MR, it reads the rate type that is assigned to the account in GP. You won't be able to assign a rate to the report, since MR is reading the rate from GP and no set up is needed in MR.
The rate for account is defined on the Account Card, under Currency. If the balance sheet accounts are set up with Current and the P&L accounts are set up with Average, you'll get two different rates if those account type are on one report. To get them to use the same rate, you'd need to have both account types set to use the same rate. Either both Current or both Average. Or, you could set up the rate types (Current and Average rates) to have the same exchange rates.
KB 2575539 -- Consolidated Currency Translation with Management Reporter GP Legacy Provider -- covers how currency is set up in GP and how to create a currency translation report in MR.
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2575539
Share
Report
All responses (
Answers (
2,586
