Row Modifier in Management Reporter

The contents of the Row Modifier cell override 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:

Account modifiers

Usually when you select a specific account, Management Reporter combines the account 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.

Accou nt Modifier

Description

/BB

Prints the beginning balance for an account.

/#

Prints the balance for the specified period.

/-#

Prints the balance for the period that is # periods before the current period.

/+#

Prints the balance for the period that is # periods after the current period.

/C

Prints the balance for the current period.

/C-#

Prints the balance for the period that is # periods before the current period.

/C+#

Prints the balance for the period that is # periods after the current period.

/Y

Prints the year-to-date balance through the current period.

/Y-#

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

/Y+#

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

Scenario modifiers

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

Note:  The scenario restriction for a row overrides the scenario 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 a virtual account segment and can carry additional information about the account or transaction, such as 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 using account attributes and transaction attributes in the column definition, see the ATTR column type in Specifying a column type. For information about using attribute filters in the column definition, see Attribute filters.

Override the information for a row

  1. Double-click the Row Modifier cell.

    The Row Modifier dialog box opens.

  2. Optionally, in the Account modifier list, click an option.

    If necessary, replace the number sign (#) with a numerical value.

  3. Optionally, in the Scenario modifier list, click the scenario to use for this row.

  4. Optionally, in the Attributes table, add an entry for each attribute to be included with this row code:

    1. Double-click the Attribute cell, and then click an attribute name.

    2. Double-click the From cell, and then click the first value for the range.

    3. Double-click the To cell, and then click the final value for the range.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×