Excluding Unwanted Rows

The Exclude Zero Value Rows setting on Financial Statement Layouts (FSL) allows you to exclude any report lines for which all of the numeric column values are zero.

The Include/Exclude settings for a row in Financial Statement Rows (FSR) allows you to include or exclude a line based on the debit/credit sign or value of the balance actual (BA) column.

The following options are available:

  • Accumulate to a total without printing it
  • Include if Credit, that is exclude if debit or zero
  • Exclude if Credit
  • Include if Debit, that is exclude if credit or zero
  • Exclude if Debit
  • Include All, the default.

If a Line row is excluded, the line values are not added into the higher level totals. Continuation rows are excluded according to their preceding type Line.

The following Include/Exclude options are valid for a T1 - T7 Total row:

  • Apply to Total Without Printing
  • Exclude if Credit
  • Exclude if Debit.

If Apply to Total Without Printing is used on a total row, though the total is not printed, the value is accumulated into the higher level totals.

Excluding Rows Based on Account Balance

The Apply to Individual Account Balances setting allows you to suppress individual accounts using the Include/Exclude choices available. If this option is set, the balance of each individual account chosen by the selection criteria is checked for the debit/credit sign, rather than the actual balance of the print line as a whole.