Options

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.

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.

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.

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.

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.

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.

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.

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.

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.