Excluding Lines from Reports

Sage ERP Accpac General Ledger 6.0

Excluding Lines from Reports Based on Contents

Financial Reporter lets you specify conditions for excluding generated lines from a report based on the contents of the line. You define the criteria for excluding a report line by adding a formula to column C of the line.

Suppressing lines that have zero values

To specify zero line suppression, you enter the letter Z in column C. Financial Reporter will check all report columns to see if the values are zeros. If all values are zero, Financial Reporter will not print the line.

If you do not want to suppress zeros on a single line, but you specified Z in the default specification, enter the letter N in column C of the line you want printed.

If the formula = True, the line will not be printed

Alternatively, you can place a logical value formula (TRUE/FALSE) in column C. If the formula in column C returns a TRUE, the Financial Reporter will not print the line. If the formula returns FALSE, the line will be printed.

Let's look at another example:

=G12 < F12 * 10%

will check if the value in column F is less than 10% of the value in column G. Again, if the statement is TRUE, the line will be omitted from the report.

Default line

Note that anything that appears in column C on a default specification line will be used by all subsequent lines unless you specifically override it.

See also