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.

Looking for a replacement for your Sage 100 ERP FRX Financial Report Writer? We think you have two great options.

The first option that we’ll look at on August 7, 2013 is a solution from Renovo FYI which is best suited for users who are happy with the reporting that they receive from FRX and have little desire to expand that reporting (for example – to other non-financial files such as customers, vendors, inventory).

Renovo FYI offers an interface which is very similar to FRX and the company even offers direct data conversion of most FRX files for a low fee (a BIG plus for companies with lots of layouts that they don’t wish to re-create).

Renovofyi offers the following benefits:

100% Web Base – Access from any location, at time, with a browser!
FRx Conversion – All of your FRx reports can be converted. Imagine trying to rewrite them!
Component Based – Create Rows, Columns, Organizations – mix and match
Integrates with any GL – You can quickly and easily create consolidated financial statements, even when you are using different general ledgers
Automatic Packaging & Distribution – Reports can be grouped together, automatically run at the same time and distributed to the person who needs it. No need to select each report for the month end reports
Drilldown – Quickly drill-down to transaction details from any level of your financial statement!

Join us August 7, 2013 at 9am PT / 10am MDT / 12pm ET for a one hour demonstration of the Renovo FYI reporting tool – Register Now

FRx viewer won’t open after generating report

Financial Reporting Replacement for Sage 100 ERP FRX Users : Renovo FYI Web Demo – August 7, 2013

Contact Us