January 2007

Jan.

30

2007

FRx Works With Lots of GLs

by Jan Harrigan CPA

Did you know that FRx integrates with about 50 different GLs?

Folks are often surprised that there are this many installations of FRx. The ones I see most often are in the MBS Dynamics series, Great Plains and Solomon, probably due to my previous years as an MBS consultant working with accounting implementations, and probably also due to FRx’s parent company Microsoft. I expect to see more Axapta and Navision shortly since that link is finished.

But I also see FRx used with Sage (MAS 90 and MAS 200), Epicor, Viewpoint, Platinum, Clarus (aka SQL Financials), Epicor iScala, and even JD Edwards a few years back. There are close to 50 in all. [click to continue…]

{ 2 comments }

Jan.

29

2007

Recreating your Excel Financials in FRx

by Jan Harrigan CPA

Lots of things to consider if you’re recreating your Excel financials in FRx. Here’s what makes the short list.

As an aside, a lot of reports are in Excel because they contain statistical information that’s not in the GL. Can you book this information to the GL? It will make your life simpler. [click to continue…]

{ 2 comments }

Jan.

29

2007

Top 12 FRx Tricks

by Jan Harrigan CPA

See 12 of the top FRx tips, trick, techniques and shortcuts updated in 2010.

I’ve been consulting with FRx since 1995, and these are a few of the top tips and tricks I’ve run across over the years. [click to continue…]

{ 30 comments }

Jan.

9

2007

What in the World is XBRL, and How To Implement It in FRx

by Jan Harrigan CPA

The basics of XBRL with FRx.

XBRL? It stands for Extensible Business Reporting Language. In short, it is a way to report financial results in a manner that is universally readable electronically. In this article I’ll show how FRx has implemented XBRL. [click to continue…]

{ 1 comment }

Jan.

4

2007

Early Registration for Convergence 2007

by Jan Harrigan CPA

Early registration for Microsoft Convergence closes on January 9, 2007. After that, the price goes up $200 or more. Convergence is the annual customer conference for users of Microsoft Dynamics general ledgers (Great Plains, Solomon, Navision, Axapta). Dates are March 11-14, 2007, and it’s in San Diego this year! Here’s the link: www.MSConvergence.com.

{ 0 comments }

Jan.

3

2007

Color Coded Budget Variances Using FRx and Excel

by Jan Harrigan CPA

Using conditional formatting in Excel to fool with FRx budget variances

Well, here’s where we’re going to go today: ‘stoplights’, or red color coding, for unfavorable budget variances. You do know we’re going to Excel for this, right?

Here’s the initial budget variance report in FRx, and I’ll explain some of the primary concepts, then we’ll flip over to Excel for the fun color coding part. (OK, conditional formatting.) [click to continue…]

{ 0 comments }