FRxBuzz

Learn Management Reporter Faster

  • Home
  • Management Reporter
  • FRx
  • Courses
  • About
  • Contact
You are here: Home / FRx / FRx Currency Translation with Excel

FRx Currency Translation with Excel

December 28, 2006 By Jan Lenoir Harrigan CPA Leave a Comment

Overview of FRx currency translation using Excel

This is going to be just a brief overview! There are a couple of ways to handle currency translation with FRx. One way is by linking to an Excel worksheet. (I had to do this in London a few years back…tough job but someone’s gotta do it.)

So here’s what a working copy of your report might look like, with Functional currency on the left, translation rate in the middle, and reporting currency on the right:

Working copy of FRx currency translation report with translation rates from Excel

And here’s the row for the above report:

Row for above report with link to Excel for exchange rates

The link to Excel is to the far right. See the nonprinting legend: (c) refers to the spot rate in row 8 of the excel file. The ‘/CPO’ in the Excel link forces the system to look at the correct column for the report period, so your translation file will have January through December in columns left to right. Then the Translation Gain or Loss is handled through Edit > Rounding Adjustments in the row format. Note that the translation rates change as the Excel links change.

One final note: this report must use a tree because that’s where the location of the Excel exchange file is specified.

Another way to handle currency translation is using DAX, but that’s in another post!

Filed Under: FRx Tagged With: Currency, Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

"I'll teach you the simplest & fastest way to use M-R and still wind up with accurate reports."

Search—try this 1st!

View Cart

View Cart

About

Hey! I'm a CPA and I specialize in Management Reporter and FRx. [Sometimes with a side of snark.] I've been doing this for 22 years (yikes). But when I'm not working I can be found reveling in live music & pizza trailers at home in Austin Texas! —Jan Lenoir Harrigan More

Learn Management Reporter

Why fight with Microsoft's manual? Life is too short as it is.

My first manual—4 foundation reports:
covers-i-2d
My second manual—12 more reports:
covers-ii-2d
My third (and hopefully last) manual—cashflow:
covers-iii-2d

Connect

  • Facebook
  • LinkedIn
  • RSS
  • Twitter

Subscribe by Email

Don't miss a trick—subscribe.

All Hat, No Cattle?

Watch out—a few unscrupulous consultants are lifting copyrighted original content from several sites, this one included, and passing it off as their own. I'm hacked off and I don't mind naming names. Bottom line—be very careful about whom you hire!

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
—Red Adair

Who I Work With

I work with zillions of companies who run Dynamics GP, AX and SL.

And lots of other consultants.

So I work with accountants who need accurate financials to help close the books. Not to mention present to the Board.

I don't sell or install MR. [How smart am I?]

FRx is Toast

FRx is toast—and I hope you're getting rid of it soon—but just in case someone still needs to learn it:

  • FRx in 8 Hours—Introduction 
  • FRx in 8 Hours—Intermediate

BTW, if you're on Dynamics, you can migrate to MR, but you should know there are other options. Choose what's best for you.

New to MR?

Here are 3 essentials to know before you start.

Background—back in the day, FRx was a famous midmarket report writer from a small agile company in Colorado. Then it got acquired. [Sigh]

Now it's owned by Microsoft. They rewrote it and rebranded it Management Reporter.

The two are very much alike and much of the FRx content here also applies to MR.

Copyright © 2025 Jan Lenoir Harrigan CPA · Protected by Copyscape Plagiarism Checker · Do Not Copy