FRxBuzz

Learn Management Reporter Faster

  • Home
  • Management Reporter
  • FRx
  • Courses
  • About
  • Contact
You are here: Home / FRx / Setting Up FRx Currency Translation

Setting Up FRx Currency Translation

November 13, 2008 By Jan Lenoir Harrigan CPA 4 Comments

Today’s post is a very quick overview of the setup of FRx’s currency translation module.

This is an extra-cost add-on module used to, uh, translate foreign currencies.

After installation of this module, take a look at Admin>System Preferences. You’ll find the Default DAX Currency Table Location there. (DAX stands for Dynamic Automatic Currency Translation System.)

Over in the Company Information screen (Company>Information), you’ll see that a different rates database may be assigned to different companies. This setting overrides the setting in the System Preferences screen. The following shot is of the rates database for the demo company FW:

And this is a shot of the rates path and functional currency for the second demo company, FW Canada. Note that the rates databases are different (FRxRates_Demo.DAX above and FRxRates_FWC.DAX below):

The currency translation module can pull rates from your GL or from tables that you maintain from within FRx. This is a shot of the Currency Translation tab in the catalog, with the option to select different Spot rates sources and Historical rate sources. There’s only one selection here because I’m in FRx’s demo database:

This next section is an overview on maintaining tables. Choose Admin>Open FRx Rate Maintenance and choose the demo dax file:

This is a shot of the Daily Rates for US Dollar to Euro translation in the FRxRates_Demo.DAX database:

And this is a shot of the Historic Rates in the same database:

To create a brand new rates database, choose File>New, and the following screen is displayed:

That’s it for now!

Filed Under: FRx Tagged With: Currency, DAX

Comments

  1. John Lindgren says

    November 14, 2008 at 9:59 am

    This is great information. I just checked our system and I didn’t even know we had this installed. I can now set it up. How wonderful. I really love these letters with all this information. Thanks Jan.

    John

  2. Jan Harrigan CPA says

    November 14, 2008 at 10:05 am

    I got a kick out of that one John! Thanks for posting. Jan

  3. Fahad says

    April 25, 2011 at 2:35 am

    Is it possible to give access for a user that is not in the Administrator group to open and modify the FRx Rate Maintenance. Thanks and regards. Fahad

  4. Jan Harrigan CPA says

    April 26, 2011 at 9:56 am

    Hi Fahad…with security enabled, all commands on the Admin menu are unavailable to users who are not Administrator or part of the Administrators group. Rate Maintenance is on that Admin menu, so I think you’re toast. Sorry…Jan

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