Asterisks appear in financial statement columns.
Description
Cause

In Financial Statements, asterisks indicate there is a problem in displaying a field. Unlike Report Designer, Financial Statements does not use asterisks to indicate that a number is too large for a column.

Resolution

Financial Statement Designer may print asterisks in the following cases:

  • Attempting to roll back a field farther than can be calculated using the information in the General Ledger master file. You can confirm which periods are available by going to General Ledger Setup, Accounts and checking the Activity tab.
    Note: You can only roll back to the first period of the prior fiscal year. To print statements from prior years, see How do I print financial statements for prior years?
  • An Account type is incorrect. The Account type on the full account type does not match the Account type on the base account.
  • Entity Comparison is selected on the statement. In Financial Statement Designer, from the Design menu, select Entity Comparison to toggle the option for the financial statement. If a checkmark appears next to Entity Comparison, the feature is activated. If no checkmark appears next to Entity Comparison, the feature is turned off.
  • Attempting to print a 13-period field for a fiscal entity using 12-periods.
  • Attempting to total an Add-then-calculate expression with another field that is not an Add-then-calculate expression. This includes totaling an Add-then-calculate expression and a Calculate-then-add expression.
  • The amount lines are cell overrides. Every single line should have the setting Calculate-then-add.
  • Printing a text field referring to the number of months, quarters, or periods, and the statement is consolidating prefixes with mixed fiscal dates. Make sure all prefixes being consolidated are in the same current period. Or use entered text rather than system generated text fields.


Steps to duplicate
Related Solutions

Asterisks are showing in the preview of my financial statement