Error 9: "Subscript out of range" in various tasks

Entry Type: Informational

Product: FRx

Application: FRx

Version Reported: NA

Subject:

Error 9: "Subscript out of range" occurs in various tasks.

Possible Resolutions:

There are several possible resolutions:

• Set the Output to DrillDown Viewer (Win95/98/NT).

1. In FRx, select the Catalog of Reports.
2. Select the report.
3. Click 'Output'.
4. Notice on the 'Output Options' there is drop-down box for selection.
5. Set the Output to DrillDown Viewer (Win95/98/NT).

• An account mask in the tree is incorrect. Verify that all the account masks in the tree are correct.

• If Row Linking is used in the report, verify Column I of the tree has Row Format information for all units of the tree including the Summary levels.

• Verify the company set in the catalog company field is a company that is included in the selection of units when generating the report. If not, either choose that company when selecting units or change the company in the catalog company field to a company that is included in the selection of units when generating a report.

• If the error occurs when generating a report to Excel via Ole, generate the report to DrillDown Viewer (Enhanced XML) and then try to generate the report to Excel via Ole from the DrillDown Viewer (.frd) file.

• Create a new catalog using the same row, column and tree used in problem catalog. If the error continues goes through the same troubleshooting steps outlined below by replacing the row, then the column, then the tree to see if replacing any report components identifies the problem component.

If error continues in new catalog use a different row format, one that works in another report, or create a test row format. If the error goes away then there is a problem with the original row format. If error continues create a test column layout with a DESC, GL CUR and GL YTD column and generate the report again. If error disappears then the problem is caused by the column layout. If the error continues and a tree is used in the report try using a different tree that works in another report or create a test tree. At some point the report should generate without error and recreating the row, column or tree resolves the issue or just recreating the catalog resolves the issue.

• This error message can be caused by leaving any of the first four rows in the Header or Footer empty while rows 2,3,4,5 or 6 contain text.

1. Open the catalog.
2. Click the 'Page Options' tab, then click the 'Headers / Footers' tab.
3. Select 'Page Headers'. Add text to any of the first four rows that are empty.
4. Repeat step 3 for 'Page Footers'.

• If the error occurs when generating a report for the 13th period, delete the company and re-create as a new company

1. In Company / Information, click 'Find'.
2. Locate the company that is causing the Error 9 and note all information, including the information on the 'System Specific' tab.
3. If the company is set as the default company, set a different company as the default company.
4. After noting all the information, delete the company.
5. Select File / Compact FRx Database / FRx System Database, and the database will compact.
6. Select Company / Information, and select 'New' to re-create.

• Add one future year in Fiscal Year Maintenance in Sage MAS 90 and 200:

1. Open General Ledger / Setup / Fiscal Year Maintenance.
2. Current fiscal year period information is initially displayed.
3. Click the 'Lookup' button to list all years.
4. Click 'Cancel'.
5. Enter the future year to be created in the 'Fiscal Year' field.
6. Enter the 'Number of Accounting periods'.
7. Click 'Accept'.

• If exporting to Excel 5 or above or Excel (Via OLE) using a tree, the company in the catalog must be in the tree.