Options

  1. Specify this information:
    Apply to Total Without Printing

    Set this on Line or Continuation row types to add the print line values to the report totals, T1 to T7, without printing the line itself on the report. See Excluding Unwanted Rows.

    Include/Exclude

    Set this on Line, Continuation or T1 to T7 Total rows to include or exclude the print line depending on whether the actual balance (BA) column is a debit or credit. See Excluding Unwanted Rows.

    This is useful if you want to include a line in different sections of a report depending on the balance. For example, it allows you to include the Bank account in the Current Assets or Current Liabilities section of a Balance Sheet, depending on its balance. See Reporting Depending on Account Balance.

    The Include if Credit option excludes lines with a debit balance or zero balance. Similarly, the Include if Debit option excludes lines with a credit balance or zero balance.

    Note:  If the Reverse Sign option is set, the test for debit or credit is made after sign is reversed.
    Apply to Individual Account Balances

    Select this option to suppress individual accounts using the Include/Exclude choice above. If this option is selected, the balance of each individual account chosen by the selection criteria is checked, rather than the actual balance of the print line. See Reporting Depending on Account Balance.

    Column Change

    This allows you to change the column values for this row and is only used with row types Line and Continuation. For example, it allows you to show year-to-date profit figures in the middle of a balance sheet. See Changing Column Value Types for a Row.

    Reverse Sign

    This is normally left blank. If selected, this option deducts the value for the Account codes identified on the line from the line total before it is printed. See Excluding an Account from a Range.

    Business Unit

    The business unit code of the subsidiary ledger from which account transactions are taken for the report line. If you leave this field blank, data is taken from the current business unit.

    Note:  When column revaluation codes 1-6 are used in conjunction with subsidiary ledgers, it is the setting of the Recalculate Base Amount field that determines whether the base amount is recalculated.
    Recalculate Base Amount

    This applies to line types Line and Continuation only. Select this option to recalculate the base amount on all of the transactions.

    If the Subsidiary Ledger field is blank, then the transaction amount shows the base amount from the subsidiary business unit, whilst the base currency code is taken from the business unit setup of the subsidiary ledger. The base amount is then calculated from the transaction amount using the currency period rates in the current business unit.

    If this field is set, then the transaction amount and currency code are taken from the subsidiary ledger but the base amount is calculated from the transaction amount using currency period rates in the current ledger.

  2. Save your changes.