Financial Reporter Error Messages

Learn more

Financial Reporter error messages fall into two general categories:

Error messages printed on financial statements. These messages report problems in formulas and report specifications, such as an account reference with too many account code segments. If Financial Reporter encounters a problem when generating a financial statement, it inserts a message in the report, and then continues to generate (and print) the rest of the statement.
Error messages displayed by Financial Reporter. These messages appear when you attempt to open Financial Reporter screens, or when report generation is canceled, and may appear under the following conditions:
- If Sage 300 cannot start Microsoft Excel.
- If the computer runs out of memory (RAM).
- If Financial Reporter cannot continue to generate the report. (For example, this may happen if the text or formula in a specification cell is too long.)

The following tables describe these error messages and possible solutions.

Error Messages Printed on Financial Statements

Error Messages Printed on Financial Statements
Message	Description
"Invalid account reference in cell. <cell location L> : <cell value V>"	The account reference you entered in column A is incorrect because it does not match the requirements for column A cells.
"Invalid selection criteria in cell. <cell location L> : <cell value V>"	You entered an incorrect selection criteria in this cell. Follow the criteria in column B to refine the account selection (for example, a filter that restricts the range of accounts to a particular account group, account type, or account name).
"Invalid zero-suppression formula in cell. <cell location L> : <cell value V>"	You entered an incorrect definition for a zero-suppression formula in this cell. Follow the criteria in column C to determine which lines are to be excluded.
"Invalid detail level in cell. <cell location L> : <cell value V>"	You entered an incorrect consolidation switch in this cell. Follow the criteria in column D for consolidating account ranges.
"Invalid formula or expression in cell. <cell location L> : <cell value V>"	This is a general message indicating that a formula or expression at the stated cell location cannot be interrupted by FR in generation.
Invalid specification line type in cell. <cell location L> : <cell value V>	Invalid spec line definition at cell location L with value V (not a comment line, or valid default line, or body line).
"FR cannot further generate any line for the worksheet."	Generated lines are almost over spreadsheet limit. Report generation has been stopped.
"Invalid consolidation of posted transactions on specification in row <Row R>. Consolidated details cannot be generated using the combination of detail level and sorting order."	The specified consolidation method for posted transactions on the spec lines in row R must match with a specific sorting order.

For more information, see About Columns in Report Specifications.

Error Messages when Starting G/L Statement Designer or Running Print Financial Statements

Error Messages when Starting G/L Statement Designer or Running Print Financial Statements
Message	Description
"Error in creating Excel object."	Make sure Microsoft Excel is installed.
"Page Break Preview is not available in Print Financial Statements (GL9100). Please go to Statement Designer (GL9200) to use this function."	The Print Financial Statements feature does not support Page Break Preview. Use the G/L Statement Designer instead.
"FileSystemObject object model cannot be initiated. Please make sure that Scripting type library is properly installed in Windows System."	Cannot find Microsoft Scripting Runtime Object - required when starting FR.

Error Messages when Starting Financial Reporter

Error Messages when Starting Financial Reporter
Message	Description
"cmdStart: <error message>"	If you receive error messages that are in this format, you may need to reinstall Microsoft Excel, or General Ledger, or System Manager. After reinstalling, restart the system, and then check to see if the problem has been resolved. If the problem cannot be resolved by reinstalling these programs, contact your system administrator. Tip: Before reinstalling Microsoft Excel, confirm that Microsoft Office is installed correctly. From the Programs and Features screen of Windows' Control Panel, right-click Microsoft Office, and then click Change. Select the option to add or remove features, and then confirm that Visual Basic for Applications is installed as part of Office Shared Features.
"Initializing FR Error (< error id>J): Failure in starting Statement Designer."	Failure to start Statement Designer.
"Initializing FR Error (<error id>): Failure in starting Print Financial Statements."	Failure to start Print Financial Statements.
"Internal error," "Insufficient memory," or "System error."	Write down the message, exit applications and Windows, restart your computer, and then try the task again.
"Incorrect procedure."	Most error messages pertaining to incorrect procedures arise when other tasks have locked the system or company database. Wait for the other task to complete, and then try again.