FRx viewer won’t open after generating report

February 10, 2016 by Wayne Schulz

I just ran into an issue with Sage 100 v2013 and FRX. The customer was using Terminal Service / Citrix for each user. Some users would be able to access FRx however when they printed the report there was no report preview. The previewer was blank ( or appeared to have “ hung “ ).

The fix in this issue was somewhat straightforward and it was all related to a set of local files that each user has stored in their profile as described below.

Search for drildown.ini (NOTE: One l in drildown ) on the local machine.

Open this file in Notepad, and check the AppSize setting. BE CAREFUL making changes in this file as you can cause more problems than you’re trying to fix…but try setting the AppSize to say AppSize=0/0/640/464.

Note: The AppSize appears to be set dynamically by FRx. I observed that when I logged into the system the numbers would change. The above numbers seem to be a good startign point (0/0//640/464).

Location of this file (Note: Change out {insertusername} for the name of the user on the PC)

C:\Users\{insertusername|\AppData\Local\FRx Software\FRx 6.7 folder

Applied fix and it worked.

In a Terminal Server / Citrix environment the two key files (stored under local profiles):

DRILDOWN
FRX

If there is something wrong in either I found that it can cause FRx not to launch although you may get the prompt to login. Once you login you see the FRx Desktop on the taskbar but no program launches as you might expect.

If you have a user that can start FRx in a TS/Citrix environment, and another who cannot. Try taking a copy of the above files from the profile that’s working ( C:\Users\{insertusername|\AppData\Local\FRx Software\FRx 6.7 folder ) and moving it to the profile of the user where FRx won’t start.

Be sure you backup any file you change — BEFORE you change it. And remember, FRx is no longer supported so you should really look at migrating to another of the recommended reporting tools:

Sage Intelligence
BizNet
Renovo

Email me at wayne@s-consult.com or text 860-516-8990 and I can get you information on alternatives to FRx or provide a price on helping you make the switch.

August 2012 Webinars: Sage CRM, Sage 100 v4.5, BizNet Reporting

July 9, 2012 by Wayne Schulz

Our webinar calendar for 2012 has just been released. Below are the free sessions we will host during the month of August 2012:

Session 1: How Integrating Sage CRM with Sage 100 ERP (formerly MAS 90 | 200) Drives Business Growth

With Sage CRM and Sage 100 ERP (formerly MAS 90 | 200), you can unify the sales and marketing aspects of your business. CRM supports the whole sales process — from your initial marketing campaign, lead and opportunity generation, quotes, to winning the sale, and finally, to fulfilling the order and providing outstanding customer service. Your marketing department will be able to justify the costs of their campaigns just as your salespeople will be able to track their forecasted sales. Plus, sales managers have a full view of their team’s productivity. Your staff will work more effectively because every aspect of your operations will be connected while your limited or expensive resources are optimized.

Sage CRM integration with Sage 100 ERP (formerly MAS 90 | 200)
Sage CRM integration with Microsoft Outlook
Forecasting within Sage CRM

Date: Tuesday August 14, 2012 – 10 am PT / 1 pm ET – 60 Minutes – REGISTER HERE

Session 2: What’s New in Sage 100 ERP Version 4.5 (formerly MAS 90 | MAS 200)

Sage 100 ERP version 4.5 (formerly MAS 90 and 200) is here, and everything you’ve heard about the new features and benefits are all true and ready for you when you upgrade. In fact, there is so much for everyone that one hour isn’t enough time to cover all of the tremendous enhancements and inclusions, so we will be taking a broad look at the main points that everyone should know about, such as National Accounts for Account Receivable, integrated Customer Relationship Management, and the Reporting Tree capability for financial reports. We’ll also discuss the option to migrate to Sage 100 Premium ERP (SQL server).

Date: Wednesday August 8, 2012 – 10 am PT / 1 pm ET – REGISTER HERE

Session 3: Meet the next generation excel-based, financial reporting solution for Sage 100, 300, 500 ERP.

BizNet’s award winning Excel® Business Information Suite is the most innovative and intuitive reporting solution on the market. It is a business reporting and analytics platform that provides real-time access to your business data from Microsoft Office Excel®. It delivers simple, yet powerful capabilities to anyone who uses spreadsheets to gather and analyze business information. With over 200 Partners, over 9 ISV’s, and Customers in over 14 different countries, BizNet has been selected as a top reporting solution by industry analysts.

Contact Jeff Keirns at 800-627-9032 x123 to book a demo

Our Upcoming Sage Webinars: Trade-Ins, Sage CRM, MAS v4.5, BizNet

March 12, 2012 by Wayne Schulz

Here are the current list of upcoming Sage webinars for the period March 20 through April 12, 2012:

Learn how to take advantage of the Sage Cash for Clunkers Promo and trade in your old Sage MAS 90/200 for the NEW Sage 100 ERP v4.5 and get up to 50% Off!*

FINAL DAYS – expires 3/31/2102 – no extensions!

Sage ERP MAS 90 and 200 version 4.5 is here, and everything you’ve heard about the new features and benefits are all true and ready for you when you upgrade. In fact, there is so much for everyone that one hour isn’t enough time to cover all of the tremendous enhancements and inclusions, so we will be taking a broad look at the main points that everyone should know about, such as National Accounts for Account Receivable, integrated Customer Relationship Management, and the Reporting Tree capability for financial reports. We’ll also discuss the option to migrate to Sage ERP MAS 200 SQL.

Length: 60 minutes
Instructor: Leanne Lowe

Days/Times:

Tuesday March 20, 2012 – 10am PT / 1pm ET – register

Wednesday March 28, 2012 – 10am PT / 1pm ET – register

How Integrating Sage CRM with Sage ERP Drives Business Growth

With Sage MAS 90 | 200 and Sage CRM, you can unify the sales and marketing aspects of your business. CRM supports the whole sales process — from your initial marketing campaign, lead and opportunity generation, quotes, to winning the sale, and finally, to fulfilling the order and providing outstanding customer service. Your marketing department will be able to justify the costs of their campaigns just as your salespeople will be able to track their forecasted sales. Plus, sales managers have a full view of their team’s productivity. Your staff will work more effectively because every aspect of your operations will be connected while your limited or expensive resources are optimized.

Sage CRM integration with Sage MAS 90 | 200
Sage CRM integration with Microsoft Outlook
Forecasting with Sage CRM

Length: 60 heart pounding minutes
Instructor: Leanne Lowe

Tuesday April 3, 2012 – 10am PT / 1pm ET – register

What Is New in Sage MAS 90 | 200 Version 4.5?

Length: 60 minutes
Instructor: Leanne Lowe

Wednesday April 4, 2012 – 10am PT / 1pm ET – register

BizNet Excel-Based Financial Reporting for Sage ERP

Are you looking to enhance your reporting and analytics capabilities for Sage MAS 90 | 200, Sage MAS 500, or Sage Accpac?

Meet the next generation excel-based reporting solution.

Length: 60 minutes
Instructor: Denise Hutchison

Thursday April 12, 2012 – 10am PT / 1pm ET – register

BizNet Announces First Annual User Conference – October 28-30, 2012

February 24, 2012 by Wayne Schulz

BizNet, publishers of a business reporting and analytics platform that provides real-time access to your Sage 100 ERP (formerly Sage ERP MAS 90 and 200) business data from Microsoft® Office Excel®, announces their first annual user and customer conference October 28-30, 2012 in Dallas, TX.

Dubbed “Excelapalooza” by the company, the agenda promises:

Learn From Excel Experts On Topics Including:

Excel Reporting – Best Practices
Dashboarding
Pivot Tables
Budgeting & Forecasting
Tips, Tricks & Techniques
Advanced Capabilities

Training Sessions on BizNet’s Ground-Breaking
Excel Business Information Suite:

Introductory & Advanced Reporting
Automated Report Distribution
Tips & Tricks – Best Practices
Earn CPE Credits!

BizNet has gained some fans from the Sage Partner Channel for it’s ease of use. The product reads financial and non-financial data from Sage 100 ERP and updates cells in Excel with the resulting values in real time. Most users find that with a few hours training they’re able to create new reports.

Excelapalooza

FRX Replacement WebCast: BizNet Excel Information Suite for Sage ERP MAS 90, 200, 500

December 15, 2011 by Wayne Schulz

Business Reporting and Analytics for Sage MAS 90/200/500

Are you struggling with finding a suitable replacement for FRx? Why not use what every company already utilizes today – EXCEL! BizNet’s Excel Business Information Suite is the next generation reporting solution and was designed with the assistance of FRx professionals. BizNet’s Reporting solution is pre-built for MAS 90/200/500.

100% Excel
Fills Top 10 FRx Feature Gaps
Real Time Reporting & Business Intelligence
Drill to transaction detail
Drag and Drop Report Creation
Pre-built Connections, Content & Analysis
Utilize Single Excel Template for Multiple Report Distribution
Fully Deployed in Less Than a Day
No additional Hardware

Join us on Wednesday January 18, 2012 at 1pm ET for a one hour free presentation that highlights the BizNet reporting tool. You have an opportunity to see how an FRX report can be converted quickly to BizNet and how subsequent reporting happens entirely within Microsoft Excel.