Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

FRx viewer won’t open after generating report

February 10, 2016 by Wayne Schulz

FRX_Catalog

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.

Filed Under: Sage 100 ERP Tagged With: biznet, frx, renovo, sage 100, sage intelligence

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

 

 

Filed Under: Sage 100 ERP Tagged With: biznet, sage 100 upgrade, sage crm, webinar

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?

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

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.

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.

Length: 60 minutes
Instructor: Denise Hutchison

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

 

 

 

 

 

 

 

 

 

Filed Under: Sage 100 ERP Tagged With: biznet, denise hutchison, leanne lowe, Sage 100 ERP, sage crm, sql, webinar, webinars

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

Filed Under: BizNet Tagged With: BI, biznet, excel, reporting

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.

 

Register for our Free BizNet WebCast – January 18, 2012 – 1pm ET

 

 

 

 

 

Filed Under: Sage 100 ERP Tagged With: biznet, frx

  • 1
  • 2
  • Next Page »
Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Sage 100 & CRM – May 2023 Update
  • Sage 100 2023 LM7200T Patch Released To Resolve Prerequisite Issue
  • SOC Audit Reports For Sage 100
  • Sage 100 Payroll Users Must be On Sage 100 v2020 or Higher for December 2023 Update Compatibility
  • When Will Sage 100 2023 Be Released?
  • Sage 100 Updated TLS 1.2 Licensing Requirements ( February 2023 )
  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in