FRX – Schulz Consulting

How to run or install FRX 6.7 for Sage 100 ERP (fka Sage ERP MAS90 or 200) with a 64 Bit OS (SOLVED)

August 28, 2012 by Wayne Schulz

As more customers have adopted 64 bit operating systems they’ve found that one of their core financial reporting tools – FRX – has refused to install. Even though Microsoft will stop the support ~~and upgrades~~ for FRX on December 31, 2012 the product is for all purposes already a lame duck.

If you’ve recently updated workstations and tried to load FRX for your Sage 100 ERP (formerly Sage ERP MAS 90 or 200) you may have found that you can load the FRX just fine but when you go to print the report you receive an error “Unable to process this output request for the following reason: C:\Windows\System32\Msxml.dll could not be found…”.

If you follow the suggestion and try to register the msxml.dll in the System32 you’ll receive a failure message.

The solution for most people has been to copy the DLL into the sysWOW64 and then use RegSRV32 to register it from that folder.

Double check the msxml DLL version as the one which has reportedly been working for most people is 8.0.5226. If you check the DLL version on your computer and it’s earlier than 8.0.5226 then try downloading and installing service pack 11 for FRX for Sage 100 ERP.

Here’s my 90 Minds KB entry for getting FRX to work under a 64-bit Windows operating system

Version(s): 4.x

Problem / Description:

FRX version 6.5+ will not usually install on 64 bit Windows OS. An error message may occur when trying to register msxml.dll from the System32 (as the Sage KB directs)

Resolution:

NOTE: Installing the below fix (registering MSXML) appears to get the FRX system running. Makie sure you have the latest FRX SP 11.

A. Install and register the 64 bit (put this in syswow64) using Regsvr (see attached file) v8.0.5226

After registering (used Regsvr32) I received:

“Runtime error -2147220503( 800403E9) fatal error language database (path)/FRxXML4.dll not found” when launching FRx

Resolution:
Register the .DLL files on the workstation.

In Window’s Explorer, go to the FRx program file directory.
Double-click on FRxReg.exe.
Date Created: 8/27/12
Created By: Wayne Schulz
Source: SC
Updated:

Source: 90 Minds Consulting Group

FRX Service Pack 11 (R11670) for MAS 90 (Download)

February 3, 2011 by Wayne Schulz

You may have tried recently to download the latest FRX service pack 11 from Sage. Unfortunately as of January 31, 2011 Sage is no longer able to distribute service packs due to Microsoft (who publishes FRX) discontinuing sales of FRX (support however extends to December 2012).

If you need to download FRX 6.7 Service Pack 11 (aka R11670) you can navigate directly to the Microsoft Knowledgebase via the link below.

frx for mas90 mas200 download service pack.jpg

Download FRX Service Packs For MAS 90 and MAS 200:

FRX Service Pack 10
FRX Service Pack 11

Can we assist you further ? Provide your name and contact information so we can contact you:

[wp-highrise-contact]

How To Convert FRX to Sage MAS Intelligence (SMI)

January 25, 2011 by Wayne Schulz

Struggling to convert your FRX financial reports to Sage MAS Intelligence (SMI)?

As you probably are aware, FRX was the reporting tool bundled with all versions of Sage ERP MAS 90 and 200. Starting in January 2011 Microsoft has stopped selling FRX. As of the end of 2012 FRX support will no longer be available. In response Sage have pledged to keep version 4.5 of Sage ERP MAS 90 and 200 backward compatible with FRX.

Beyond version 4.5 it’s anyone’s guess whether FRX will continue working with Sage ERP MAS 90 and 200. For this reason Sage have introduced a re-badged version of Alchemex (an Excel based report writer) as their FRX replacement. Marketed as Sage MAS Intelligence this reporting tool is being provided to every user of MAS.

Users of FRX have questioned whether their existing reports will migrate automatically to SMI. Unfortunately the answer ultimately is no. However Craig Juta from bxintelligence has posted this short 5 minute video that could give you an idea of the ease with which a person skilled with Excel can convert FRX reports.

FRX to Sage MAS Intelligence Conversion in 6 Steps (5 minute video)

Sage MAS 90 and 200 Business Intelligence Comparison

May 12, 2010 by Wayne Schulz

Sage just released a pretty helpful chart which shows the main differences between some of the most popular Business Intelligence products that companies have been using with MAS 90 and MAS 200.

As you may know Sage is preparing to release a new universal Business Intelligence product which will be used on the Sage MAS 90 and MAS 200 product line.

Their current release plans indicate that this will ship in Summer 2010 as outlined in a recent announcement:

Sage MAS Intelligence will soon be introduced as the ideal FRx replacement product for Sage MAS ERP. On target to be released this summer, Sage MAS Intelligence offers powerful and easy to use graphical financial reporting capabilities to access business-critical information, and makes complex reporting easy using a new report designer. Going beyond General Ledger reporting needs, Sage MAS Intelligence will provide Business Intelligence across the entire Sage MAS ERP system, including CRM and Abra.

The products compared are:

Sage MAS Intelligence (Sage’s NEW offering scheduled for Summmer 2010)
Sage MAS 90 and 200 Business Insights Dashboard
Sage MAS 90 and 200 Business Insights Reporter

FRX
BizNet
Crystal Reports
F9

The comparisons provide for ranking a wide range of features under the categories of Data Access, Report Security, Report Delivery and Distribution, Reporting Capabilities, Sorting, Aggregation and Drill Down, Database Support Provided, Operating Systems Support and MS Office Version Support.

SageMAS Intelligence Comparison- FRX, Biznet, Alchemex, Crystal, F9

FRX to Sage MAS Intelligence Conversion Tool Is In The Works

April 12, 2010 by Wayne Schulz

We’ve already discussed that the financial reporting tool used by MAS 90 and MAS 200, Microsoft’s FRX, is reaching the end of it’s life in 2012. Sales of the product will stop in December 2010 and support ceases two years later.

The replacement for FRX is Sage MAS Intelligence. It’s a private labeled version of a spreadsheet based solution from a company named Alchemex which is already in use with Sage’s Accpac product line.>/p>

We had an opportunity in March to take a first look at what was then termed Sage Insights Intelligence (since re-branded Sage MAS Intelligence).

One of the questions at the time was about how FRX reports would be converted. Many customers who are using FRX have created elaborate FRX layouts for their financial reporting. Understandably many users have been concerned about whether all of this data would transfer to the new Sage MAS Intelligence.

While we don’t know exactly what data will be converted (for example it’s unclear whether reporting tree structures will convert), we can report that last night Alchemex shared the following welcome news:

..nothing new other than we most definitely will release a utility that will convert FRx reports in MAS Intelligence format, but are in discussions with Microsoft regarding the password for the FRx database and using this, so may have some delays, but realize how critical this process/function will be and are paying attention to it.

So it looks as if at least some older FRX layout formats have a chance for automatic conversion to the new Sage MAS Intelligence layout. It’s still too early to tell exactly what will convert (and how accurately) however it’s comforting to know that a conversion option remains under active development.

Here’s my 90 Minds KB entry for getting FRX to work under a 64-bit Windows operating system

Contact Us