Share via


FRx 6.7 Service Pack 11 for Microsoft Dynamics GP

FRx 6.7 Service Pack 11 for Microsoft Dynamics GP is now available.

(One must apply SP9 first then go to SP11)

The certification of FRx SP 11 and GP2010 is complete. The existing SP for GP 10 can be used for those customers upgrading to GP 2010 and staying on FRx. New customers to GP2010 must use Management Reporter, if this is an issue then the Microsoft Dynamics Business Desk will need to be contacted.

This release does NOT include the following GP 2010 features:
• Filtering on Reporting Ledgers
• Budget Transactions and Unposted Budgets

If customers need these features, they are available in Management Reporter

Overview

FRx® 6.7 Service Pack 11 for Microsoft Dynamics GP is now available. This affects FRx 6.7 Professional for Microsoft Dynamics GP only. Listed below are the situations that are resolved with FRx 6.7 Service Pack 11 along with installation instructions.

BUGS FOUND SINCE SERVICE PACK 11 WAS RELEASED (more than 1 occurrence)
Bug # - Description


System Requirements

Application Server Requirements

Internet Information Services (IIS) is not required software on the Application Server.

Web Server Requirements

Microsoft Java Virtual Machine (MSJVM) is required on the Web server where WebPort will be installed.

Mail Services (Outlook or any MAPI compliant email software) is not required on the Web server.

Office (productivity component) is not required software on the Web server.

OLAP Analysis is not performed on the Web server and so neither SQL Server™ 2000 Analysis Services Client nor SQL Server™ OLAP Services Client are required.

FRx Web Server functionality requirements

Specific to Windows 2000 Servers.
Add the local EVERYONE user to the root web directory and make sure ALL objects under it “Inherit From Parent Object”.

Installation Notes

BUGS FIXED WITH SERVICE PACK 11

FRx Report Designer
168356 - CCAVG not working when using account types and YTD
168373 - A report using CCHIST in the row and a YTD column not calculating as expected
168374 - Error when using CCHISTin a row: Balances do not match the DAX table
168382 - CCHIST calculates incorrectly when an Account Type is used
168275 - Incorrect exchange rate used for /BB rows and columns
168284 - XD print control in row causes incorrect currency translation
202978 - No amounts generated for translated YTD column when you use CCAVG with account categories
348626 - Receive an 8512 error or Error 13 when using a combination of CCAVG, T_ATTR and a YTD column
325196 - XO print control in the column layout will hide columns with data when exported to Excel
363006 - Transaction detail code columns display on the parent level when printing a report
196839 - Error when generating a chain of reports to Formatted Excel in SP 10 using Windows Server 2003: "Error 988672 Access
228139 - When exporting formulas to Excel a TOT row that contains a range of NP rows will not display the formula
167919 - Subtotal on segment causes calc/percentage columns to be ignored at account detail level and added up when printing
168269 - Excel output and Export formulas checked results in wrong amount for CAL rows
194596 - Transaction Detail Code information not appearing for all child units except the last unit after exporting to a Formatted
168312 - 0.00% column format mask does not display when using the rounding option
168293 - When using rollup by period dates to consolidate companies with different calendars, incorrect data is retrieved for
212217 - Column layout does not use special format mask of percentage when CS print control is used in the row format
199746 - CBR calculation doesn't work for rows above referenced CBR row when referencing a CALC column in the column layout
301742 - Unposted adjustments in PFW are not included in CUR or YTD columns.
309037 - Any column after 'BK' does not work in a range calculation.

FRx DrillDown Viewer
205411 - Tree units display in the reverse order when you drill down from a summary level in FRx 6.7 on SP 10
168297 - Scrolling up and down in the DrillDown Viewer causes subtotals to recalcuate
293825 - CS Rows do not display amount correctly when using alpha characters in place of the currency symbol within the

FRx Report Manager
168255 - Report Manager security is inconsistent when published to WebPort
168260 - 2146826259 Error occurs when emailing a link in Report Manager.
168268 - Report Manager folder group security not working.
251637 - Only the user that installed FRx SP10 can Print/Print Preview Report Books from Report Manager.
294310 - When a report book with security is published to WebPort, the user name is assigned to the folder instead of the user
386533 - Report Manager getting errors after installing R11 Service Pack

FRx Report Server
217064 - Error 438 message will appear for Report Server when using Forecaster columns.
168350 - Report Server gives "Invalid Procedure call or Argument" when generating report

FRx WebPort
242704 - Windows Auth FRx security users are not added to new groups in Web Admin when synced from FRx
309221 - Update Report in WebPort Administrator only shows a strip of the Remove pane when opened.
242539 - Receive Error "Unable to open specified source file" using tree security when a Windows Auth user, not in a group,
301059 - Rreceive an Error 9060 Invalid userID/password when printing a report to PDF from a Windows Authentication user in
239621 - Webport Drilldown data shows transaction data from a different version of the same report
234804 - Incorrect opening balance at transaction level when publishing to WebPort
194683 - 'Report Failed to Load' in WebPort when using two column headers and WKS columns with print contol
168326 - 'Report Failed to Load' in WebPort when spreading column headers on NP columns
353196 - Column header spreading over NP column causes headers to shift in WebPort browser display
360467 - Unable to view reports in WebPort when using Java Version 6 Update 12 or later installed on Windows XP

FRx Direct Link and the Microsoft Forecaster Integration
168360 - Forecaster 7.0 information does not display when using Account Type in the Link to GL
184082 - Ranges are not pulled in properly when using non-natural segments defined in row and tree layouts for Forecaster 7.0
168349 - DirectLink error running a Forecaster 7.0 report with more that 1498 rows
168352 - Error:8900 occurs when logging into a Binary Forecaster 7.0 database
190180 - DirectLink ignores department when department and account numbers are the same
259331 - Forecaster Directlink scripts need to support Case Sensitive SQL Server
168351 - Receive error when running the create table scripts for Forecaster 7.0 on a binary database

Issues specified to Microsoft Dynamics™ GP 9.0 and 10.0
168357 - Incorrect report date displays when less than 12 periods within the fiscal year
168358 - Not able to define multiple years when using one budget book code for GP10

*Please make a backup of the entire SYSDATA folder before applying the service pack*

  1. Download and save the file FRxsp6711027_gp.zip.
  2. Click on the file and extract the contents of it to the FRx code folder on the c drive of each workstation with FRx installed.
  3. View the Release Notes .PDF file included in the download.
  4. Double click on FRx6711027.exe in the FRx code folder to begin the installation of the service pack.
  5. After reading the disclaimer on the first screen, click next.
  6. Select the appropriate FRx Product you wish to install the Service Pack on and click next.
  7. Locate the path to the FRx code on the c drive of the workstation and click next.
  8. You will now be ready to install the service pack. It is recommended you verify all other applications are closed at this point in time to ensure proper installation of the Service Pack. From there, click next.
  9. The service pack will begin to install. Please note, you will see a dos window open and all of your FRx *.dll files will be registered during the install of the Service Pack.
  10. Click finish on the last screen. It is recommended that you reboot the workstation upon successful completion of the installation.
  11. Apply the service pack to all other workstations with FRx installed.

FRx WebView Printing (BCL Printer Driver) Installation

Note: The BCL Printer driver is now certified on Windows Server 2003. A new printer driver has been created for Windows Server 2003

  1. Install FRx 6.7 Service Pack 2 or higher to the FRx WebView installation located on the IIS Server.
  2. In Windows Explorer, browse to the FRx WebView installation folder on the IIS server and locate the BCL folder that was installed with the Service Pack.
  3. Open the BCL folder and find the BCLeasyPDFFullAuto.exe.
  4. Double-click on the executable, and it will quickly install the components needed for the printing functionality from FRx WebView.
  5. After this process is complete, you must reboot the server to complete the installation.

After Installing BCL easyPDF

  1. Go to Start | Settings | Printers and Faxes
  2. Click on the BCL easyPDF to open the BCL easyPDF window
  3. Go to File | Printing Preferences
  4. Click on the Folders tab
  5. Clear the Open Output File after conversion check box
  6. In the Default output folder section, click Specify
  7. Browse to the PDFTemp directory located in the FRx WebView installation directory.
  8. Click Apply, and then click OK.

FRx WebView Printing: Installing BCL easyPDF on Windows Server 2003

The BCL easyPDF setup is easy to understand and complete. However, if you are installing BCL easyPDF on Windows Server 2003, you must follow these steps prior to installing the easyPDF in order to get the driver installed for web printing:

  1. Go to Start | Run and type "gpedit.msc" to bring up the Group Policy
    Object Editor Window.
    a. Select the Local Computer Policy\Computer
    Configuration\Administrative Templates\Printers folder.
  2. Right click on "Disallow installation of printers using kernel-mode drivers"
  3. Right Click and select Properties.
  4. Select the “Disabled” radio button then click OK.
  5. Close out of the Group Policy Object Editor Window and then
    REBOOT Windows Server 2003.
  6. Install the updated BCL easyPDF driver (version 3.10.016) located with this service pack.

For additional information, please see the following Microsoft knowledge base article:
282011 - Printer Driver Is Not Compatible If a Policy Is Enabled on Your Computer

Important Notice to Customers

We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hot fixes. It is important to verify that your environment is compatible with the service pack(s), (es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solution.

Downloads

Download Description File type (size)
FRxsp6711027_gp.zip Version: 6.7.11027 - 12/11/2009 Winzip (53.9 MB)
FRX67011027_aa.zip If using FRx 6.7 Analytical Accounting add-in please download the following SP11 install (Do not use the 1st one) Winzip (53.9MB)

We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hotfixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solution.

Support Information

For technical support questions, contact your partner or direct your questions to the Support for Business hub: https://serviceshub.microsoft.com/supportforbusiness/create