Normally, you implement FRx Financial Reporting for Microsoft Dynamics GP financial statements: Balance, Profit and Loss, Cash Flow and consolidated versions of these reports. FRx is very scalable and serves multiple accounting platforms: Great Plains, Axapta, Solomon, and others. For such reporting tool you should expect some required support budget. Normally, FRx installation, reports design and ongoing support is provided by your Dynamics GP Partner, or you could do self support, by searching Knowledge Base on your Microsoft Dynamics Customer Source. In this small publication we would like to share some typical FRx support questions and fixes:
1. You can only login FRx with sa user, and when you are trying Dynamics GP user login, password is not recognized. This problem happens when you installed FRx 6.7 from CD and didn't apply required service pack. Please launch FRx, login as sa, open Help->About FRx and read its version. If it is 6.7.141 - this is the case - no service packs applied. If you are on Great Plains 10.0, please apply at least FRx 7.6 Service Pack 9 6.7.9111, or current (June 2009) SP10 6.7.10343
2. You are trying to login FRx and system freezes on the Building/Verifying GL indexes. This means that your G32 file for the company is corrupt. In you Sysdata, locate *.G32 file with the name, resembling your company name, rename it and login FRx one more time. If you would like to rebuild G32 files for all of your FRx companies, please note, that it rebuilds on logon the file for Default company only, so in order to rebuild for all you should logon FRx, Company->Information and select default one by one all of your active companies
3. You cannot drill down to the line on your report Drilldown Viewer. This means that your detail level is set to Financial Report. Close Drilldown Viewer and return to Catalog, open Dropdown list next to Detail Level and switch it to Financial & Transaction
4. Exporting FRx report to Excel. Run report to open it in FRx Drilldown Viewer. Click File->Export->Worksheet file then select Formatted Excel (XLS, XLSX)
5. How to install new FRx workstation. Please, launch existing FRx installation, open Admin->Organization->Sysdata. Write down the path to Sysdata. Open Help->About FRx and write down release number. Contact your FRx consultant on confirming or obtaining exactly the same service pack for FRx. Then on the new workstation, install FRx with all defaults from CD, then do not launch FRx, but first apply appropriate service pack. Launch FRx, but cancel logon, open Help->About FRx and verify that release number is now the same as on existing FRx workstations. Then go to Admin->Organization->Sysdata and change sysdata path in New location line. You will get message that FRx will exit, login FRx again - you should be able to use this new installation at this point
6. If you need older FRx version support: 6.5 or older, please give us a call: 1-866-528-0577, help@albaspectrum.com
Andrew Karasev, Alba Spectrum LLC. http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577. Web portal: http://www.pegasplanet.com We are Microsoft Dynamics GP technology partner, ERP and software integrator, who serves you USA, Canada, Mexico and Latin America nationwide. Local service is available in Chicago, San Diego, Los Angeles, Houston: SAP Business One and Dynamics GP. We have customers in the following business metros: Phoenix, New York, Boston, Milwaukee, Buffalo, Rhino, San Jose, Miami, Atlanta, Minneapolis, San Francisco, Detroit, Montreal, Las Vegas, Oceania, Colombia, Caribbean, Poland, UK, New Zealand, Australia