Sage 100cloud Consulting
Confused by exactly what Sage Intelligence report writing components are included with your Sage 100 maintenance? You’re not the only one. We’ve received calls from a number of customers in the process of researching FRX financial reporting alternatives.
One great option is to use the included Sage Intelligence reporting, a portion of which every Sage 100 customer on maintenance has access to.
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):
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:
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.
Sage has just turned on their landing page for the new release of Sage 100 ERP 2013.
This release of Sage 100 ERP 2013 is available entirely by download. There are no disks sent by mail. Luckily the process for downloading the 2.29 GB file is very simple (see instructions below) and takes under an hour (depending upon your connection speed).
Once downloaded you will have a single self-extracting EXE file which when clicked creates a folder holding the entire installation disk (including Crystal Reports). Separate downloads are needed if you use Sage CRM or Sage Intelligence reporting.
Once downloaded you can install your upgrade (we strongly recommend consulting your Sage business partner first) from the source files on your server.
Schulz Consulting / DSD Business Systems customers should not worry about downloading the file as we’ve already secured copies and will transfer this file (as well as all other files needed to upgrade) onto your servers via the use of Dropbox which will synchronize the files overnight for you.
CUSTOMERS:
Sage 100 ERP customers on a Business Care plan can download your copy by logging on to the Customer Portal, and then clicking on www.Sage100ERP.com/download2013. Before you download, Sage recommends that you check with your certified solution provider to assist with your upgrade.
PARTNERS:
Sage 100 ERP certified Business Partners can download your copy by logging onto the Partner Portal, and then clicking on www.Sage100ERP.com/download2013.
For a more in-depth description of new features in this release – please review either of the PDF files
Sage 100 ERP – At-a-Glance Version Enhancements Version 2013 (PDF)
Sage 100 ERP 2013 Detailed Release Guide (PDF)
Need help understanding your upgrade options? Contact Us.