We previously introduced you to the Sage Intelligence Report Designer Add-in – an important tool in converting your old FRx reports to Sage Intelligence reports. The only time-consuming task that remained was the process of manually converting your reporting trees – but no more!

A new FRx Reporting Tree Conversion Utility converts FRx Reporting Trees into Sage Intelligence Reporting Trees. It’s a great complement to the Report Designer Add-in and together, they significantly speed up the conversion process.

Using the Reporting Tree Utility

Following are the steps for using the new FRx Reporting Tree Conversion Utility.

1. Download the FRx reporting tree utility and related conversion guide for Sage 100 ERP.

NOTE: The link above initiates a download of the zip folder containing the utility files and related documents.

2. Extract the FRxTreeConverter.zip files into a new folder.
3. Inside the new folder, run FRxTreeConverter.exe
4. Browse to the location of and select the FRx Specification Set you would like to load FRx reporting trees from.
5. Press OK
6. You will be prompted to select an output location for your FRx Reporting Trees. Browse to the location of your Sage Intelligence MetaData Repository and press OK.

NOTE: You can determine the location of this folder by opening the Report Manager module and looking at the folder path specified for the MetaData Repository Location as shown in the following screenshot:


7. All reporting trees associated with your FRx reports will be converted and available for use in Sage Intelligence.

Getting Help and Other Important Details

This utility will only convert FRx Reporting Trees which are associated with FRx Reports.  Any disassociated Reporting Trees will be ignored during conversion. Only Microsoft FRx 6.7 Service Pack 11 specification sets are supported.

Contact us if you’d like help converting your reports or download the FRx to Sage Intelligence Conversion Guide for Sage 100 ERP (PDF).

©2013 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.