Asterisks appear in financial statement columns
Description
Cause

In Financial Statements, asterisks indicate there's a problem in displaying a field.

Unlike Report Designer, Financial Statements don't use asterisks to indicate 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 the design can calculate 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. See steps to print financial statements for prior years.
  • An Account type is incorrect. The Account type on the full account type doesn't match the Account type on the base account.
  • You selected Entity Comparison 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, you've activated the feature. If no checkmark appears next to Entity Comparison, you've turned the feature 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 isn't 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. Each line should have the setting Calculate-then-add.
  • Printing a text field referring to the number of months, quarters, or periods, and the statement consolidates prefixes with mixed fiscal dates. Make sure all prefixes you're consolidating are in the same current period. Or use entered text rather than system-generated text fields.
Steps to duplicate
Related Solutions

Asterisks show in the preview of my financial statement