Share via


Specify Row Modifier cell in a row definition

The content of the Row Modifier cell in a row definition overrides the fiscal years, periods, and other information that is specified in the column definition for that row. The selected modifier applies to every account in the row. You can modify each row with one or more of the following types of modifiers. To use the Row Modifier cell, see the procedure, Override column definition.

  • Account modifiers

  • Book code modifiers

  • Account and transaction attributes

Override column definition

  1. In Report Designer, open the row definition to modify.

  2. Double-click the Row Modifier cell in the row where you want to override the column definition. The Row Modifier dialog box opens.

  3. Select an option in the Account modifier field. For a description of the options, see Account modifiers.

  4. In the Book code modifier field, select the book code to use for the row.

  5. Under Attributes, add an entry for each attribute to be included with the row code as follows:

    • Double-click the Attribute cell, and select an attribute name.

      Warning

      Replace the number sign (#) with a numeric value.

    • Double-click the From cell, and type the first value for the range.

    • Double-click the To cell, and type the final value for the range.

  6. Click OK.

Account modifiers

When you select a specific account, Management Reporter usually combines the account together with the fiscal years, periods, and other information that you specify in the column definition. You can use different information, such as different fiscal periods, for specific rows.

The following account modifiers are available. Replace the number sign (#) with a value equal to or less than the number of periods in a fiscal year.

Account modifier

What is printed

/BB

Beginning balance for an account.

/#

Balance for the specified period.

/-#

Balance for the period that is # periods before the current period.

/+#

Balance for the period that is # periods after the current period.

/C

Balance for the current period.

/C-#

Balance for the period that is # periods before the current period.

/C+#

Balance for the period that is # periods after the current period.

/Y

Year-to-date balance through the current period.

/Y-#

Year-to-date balance through the period that is # periods before the current period.

/Y+#

Year-to-date balance through the period that is # periods after the current period.

Book code modifiers

You can limit a row to an existing book code. The column definition must include at least one FD column with a book code.

Note

The book code restriction for a row overrides the book code restrictions in the column definition for that row.

Account and transaction attributes

Some accounting systems support account attributes and transaction attributes in the financial data. These attributes function like virtual account segments and can carry additional information about the account or transaction, which might be account ID, batch ID, postal codes, or other attributes.

If your accounting system supports attributes, you can use account attributes or transaction attributes as row modifiers in the row definition. For information about how to override row information, see the procedure, Override column definition.

For information about how to use account attributes and transaction attributes in the column definition, see the ATTR column type definition in the “Column types” section in Specify a column type in a column definition. For information about how to use attribute filters in the column definition, see Specify a column type in a column definition.

See Also

Row definition