PROGRAM ISSUE ** THIS INFORMATION HAS NOT BEEN VERIFIED **
Posting Comments do not export to Excel if the first line in the row format is a blank line or a DES line in FRx service pack 11.
Entry Type: Program Issue
Product: FRx
Application: FRx Desktop
Version Reported: 6.7.11027 (sp 11)
SMR#425650
Status:
This issue is being researched by Engineering.
This is a known issue with SP11 (6.7.11027). FRx SMR#425650.
Subject:
Posting Comments do not export to Excel if the first line in the row format is a blank line or a DES line in FRx service pack 11.
Steps to Duplicate:
In MAS:
In ABC company:
Preview the G/L detail report for G/L account 100-00-00 for the period of 5/31/2010.
- Expand General Ledger, Reports and double click General Ledger Detail Report.
- Select the following criteria:
- Period=05/01/2010 to 05/31/2010
- Account Number = 100-00-00
- Click Preview button
- Note: The posting comment for journal CD-000001 dated 5/31/2010 is 0001005 053003 Petty Cash
In FRx (service pack 11-ver 6.7.11027):
- In FRx Report Designer, setup ABC company and select ABC company as default.
- Create new Row Format with the following criteria:
- On Row Code 100: In the Description (column B) cell, enter Petty Cash, In the Fmt Code (column C) cell, select DES from the lookup
- On Row Code 130: In the Link to G/L (column H) cell, enter 100-00-00
- Save Row Format
- Create new Column Layout with the following criteria:
- Column A: Type = ACCT
- Column B: Type = DESC
- Column C: Type = T_ATTR, Book Code: Posting Comments, Column Width= 60
- Column D: Type = GL
- Save Column Layout
- Create new Catalog of Reports with the following criteria:
- Catalog ID: Test
- Detail Level: Financial & Transaction
- Row Format: select row format created above from drop down
- Column Layout: select column layout created above from drop down
- Report Date: 05/31/2010
- Save Catalog
- In the Catalog of Reports window, click Generate Report
- In the FRx Drilldown viewer, double click on the account to drill down into account and double click again on the account to drill down into the transaction details Note: Posting comment appears in FRx Drilldown Viewer
- From the Drilldown Viewer menu: Select File, Export, Worksheet File and click Excel (xls,xlsx)
- Save the Output File (make note of the location where the file is being saved)
- In the Export Selection window select the following criteria:
- Report Type = check the box for Detail (supporting) report and select Transaction Details radio button
- Click Ok button
- Open the Excel file created above. Note: The posting comment did not export.
Expected Behavior:
Posting comments should export to Excel when a blank or DESC line is the first line of the row format.
Possible Workaround:
Option 1:
- Insert a new first row setting Print Ctrl option to NP (Non-Printing Row)with a valid account in the Link to GL cell.
Note: We have seen inconsistent results with this workaround option.
Option 2:
- Remove any blank or DES lines from the top of the row layout until the top line contains a valid G/L account in the Link to GL cell.
Option 3: (Option 3 is only available for MAS 90/200 versions 4.30 and lower)
- Roll back to SP9. It is not recommended to roll back to SP10 as a similar issue exists there.
Below are the steps to roll back to FRx SP9:
- Make a backup of the shared SysData folder. You can confirm the location of this folder by going to Admin, Organization and selecting the SysData button in FRx Report Designer.
- While all users are out of FRx, go to Add/Remove Programs and uninstall the FRx service pack. If prompted, choose to roll back.
- Note: If FRx is installed locally (Fat Client), these steps must be completed on each workstation where FRx is installed. All workstations must be on the same FRx version.
- Once the service pack is uninstalled, start FRx Report Designer and confirm the Release Number by clicking on Help and selecting About.
- 6.7.141 - No SP
- 6.7.1013 - SP1
- 6.7.2013 - SP2
- 6.7.3073 - SP3
- 6.7.4031 - SP4
- 6.7.5014 - SP5
- 6.7.6062 - SP6
- 6.7.7032 - SP7
- 6.7.8069 - SP8
- 6.7.9111 - SP9
- 6.7.10343 - SP10
- 6.7.11027 - SP11
- If the service pack level is correct, continue to Step 5. If the service pack level is too low, download and install SP9. If the service pack level is still too high, fully uninstall the existing service and then download and apply SP9.
- Once FRx Report Designer is at SP9, you will need to run a HotFix to remove SP11 registry keys to prevent from getting an Error 91 when generating reports to Excel.
- Note: See attached file below.
- If FRx is installed on the server (Thin Client), you must run Client Setup from the workstation.
Related Articles:
How to install FRx service packs
How to apply service packs on a network (thin) client installation
