Management Reporter Glossary

&

See Ampersand (&).

?

See wildcard character (?, *).

*

See wildcard character (?, *).

account

The unique identifier for a record that holds the balance relating to any single asset, liability, owner's equity, revenue, or expense of the business.

See also account dimension, natural segment.

account dimension

In a dimension-based system, the dimension that describes the type of account (for example, asset, liability, revenue, expense, or retained earnings).

See also natural segment.

account filter

In a column definition, the specification of one or more segment or dimension values to restrict a column to specific financial data accounts.

Top of Page

account modifier

An operator used in a row definition to offset the reporting period or year for a specific row.

account set

A named group of accounts that can be used in multiple row definitions.

accounting period

A period of time, such as a month, quarter, or year, for which financial statements that measure flow, such as income statements, are prepared. At the end of each accounting period, all financial data accounts must balance. Accounting periods are defined in the financial data.

additional text

Custom text that is specific to a reporting unit. Additional text is a special form of auto text.

See also auto text, reporting unit.

alphanumeric characters

A combination of alphabetical and numerical characters, usually used in reference to a code, such as a report name, row code, or row description.

ampersand (&)

A special character that is used in the Structure cell of a reporting tree definition to specify the connection to the row definition. Ampersands are usually used in the natural account segment, but they are not limited to that segment.

apply date

The effective posting date of a transaction in the financial data source system. The apply date determines which financial data accounting period includes the transaction.

See also document date, entry date.

attribute filter

In a column definition, the list of attributes that limit the data that is available for a report.

See also attributes.

attributes

Additional pieces of information (financial and non-financial) that exist in the financial data source database. Management Reporter supports two types of attributes: account-based and transaction-based.

auto text

Text that Management Reporter updates each time a report is generated. Auto text can be used in report headers and footers, in row descriptions, and in column headers.

See also additional text.

base currency

See functional currency.

base period

The reporting period specified in the report definition. The column definition can refer to the base period in order to specify report columns for relative time periods. For example, if the column definition specifies BASE in the Period cell, then the actual period is defined at the time the report is generated.

Top of Page

beginning balances

The opening balances for a period or a year.

building block group

A group of row definitions, column definitions, reporting tree definitions, and report definitions. Each Management Reporter entity can have its own building block group, or several Management Reporter entities can share the same building block group.

CBR

Change Base Row. The format code CBR identifies the row to use as the base row for any percent calculations. This base row remains in effect until another CBR format code is used within the same row definition.

child unit

A unit in a reporting tree that is a subsidiary to a higher-level unit called a parent unit. Management Reporter can roll up data from child units to parent units to create summary reports.

See also parent unit, reporting tree.

column definition

The specification of the headings in the report columns and of the codes that define the type of information in a column: reporting periods to display data from the source system, calculations on the data in other columns, and so forth.

See also row definition, reporting tree.

Top of Page

column period offset (/CPO)

A switch used in a row definition when linking to Excel worksheets. If the worksheet contains multiple columns that represent different periods, the /CPO switch matches the accounting periods in the column definition with the appropriate columns in the worksheet.

See also row period offset (/RPO).

CPO

See column period offset (/CPO).

default entity

The entity currently selected for processing. The entity description appears in the status bar. Set the default entity in the Entities dialog box.

default printer

The printer chosen through the Printer Setup dialog box as the default. When no other printer is specified, the system sends print jobs to the default printer.

detail level

A selection in the report definition that refers to the level of detail in a report.

detail unit

A reporting unit that draws information directly from the financial data.

See also child unit, reporting unit, summary unit.

dimension

A reporting unit that draws information directly from the financial data.

See also dimension value, segment, and segment value.

Top of Page

dimension value

A unique identifier for a given dimension. The length of a dimension value is variable. The values for a given dimension can have different numbers of characters. For example, a division dimension might have values San Francisco and Denver.

See also dimension, segment, and segment value.

document date

The date that is assigned to a transaction document, such as an invoice. Often, the document date is the date that the document is entered into the financial data source system.

See also apply date, entry date.

effective dates

The date or period number for which a specific row definition, column definition, or reporting tree definition is used. Specify the effective dates in the report definition.

entity

The information about the source system that is needed for processing financial reports.

entry date

The date on which a record is entered into the financial data source system. The entry date defaults to the system date and cannot be edited.

See also apply date, document date.

financial data

A ledger of accounts that are reported in the financial statements. Posting a transaction updates the accounts in the financial data.

format code

A code that controls the appearance of a row in the generated report. Each row is interpreted as a financial data source detail row unless the Format Code cell in the row definition contains a format code. .

Top of Page

format override

A group of codes used in row definitions, calculations, and so forth that defines how monetary amounts are shown on reports. The override controls the symbols and placement of decimals and thousands separators, as well as the presence or absence of currency symbols and leading or trailing zeros.

See also numeric mask characters.

fully-qualified account

In a fully-qualified-account-based system, a unique identifier that includes a value for each defined segment.

See also segment and segment value.

functional currency

The primary currency in which an entity typically transacts business, also known as home currency or base currency.

home currency

See functional currency.

link

A Management Reporter feature that connects a row definition to an Excel spreadsheet.

mask

A format that keeps codes or numbers uniform. The mask can require a certain type of character, such as a number or a letter, and it can require a certain number of characters or digits. Structure masks are used in the financial data to keep the format of all account identifiers uniform.

See also numeric mask characters.

natural segment

In a fully-qualified-account-based system, the segment that describes the type of account (for example, asset, liability, revenue, expense, or retained earnings).

See also account dimension.

Top of Page

numeric mask characters

Mask characters define the masks Management Reporter uses for amounts.

0—A zero mask character inserts a zero (0) into the amount if the digit is not used. See the following example:

  • Mask 000.00

  • Amount $010.53

#—A number sign mask character does not insert a zero (0) into the amount if the digit is not used. See the following example:

  • Mask ##0.00

  • Amount $10.53

originating currency

The currency in which a transaction (such as an invoice) was conducted. The originating currency may be different from the functional currency.

parent unit

A unit in a reporting tree that has subsidiary, or child, units. Management Reporter can roll up data from child units to parent units to create summary reports.

See also child unit, reporting tree.

posting

The act of transferring financial transactions entered in journals and subledgers to the financial data source in order to update account balances.


Posting updates accounts that are tracked in the financial data source module with financial data entered in other modules, such as inventory and accounts payable, as well as financial data.

print control

An option in the column definition that enables special printing characteristics, such as non-printing and reversed credit and debit signs, when reports are generated.

provisional reporting

The provisional reporting options in the report definition determine whether Management Reporter includes posted, unposted, or both posted and unposted financial data transactions in the report. Posted transactions include activity from every module (accounts receivable, accounts payable, and so on) in which a financial data update has been run.

regional options

The settings that determine the currency symbol and formatting of amounts for an entity. The settings are determined by the Microsoft Windows operating system.

Top of Page

report definition

The specification of the parameters for generating a report. The report definition names the row definition, column definition, and optional reporting tree definition that combine to create a financial report. The report definition also specifies the base period and year, report output destination, and other report-wide settings.

See also row definition, column definition, and reporting tree.

report definition language (RDL)

A Microsoft SQL Server file type for sharing reports.

report library

The top-level folder in which Management Reporter stores generated reports.

report output location

The report output location specifies the destination of the generated report. When the report is generated, it is automatically saved in this location.

Report Wizard

The Management Reporter tool for creating a basic report.

reporting currency

A currency used for financial reporting purposes. This could be the functional currency or is typically the currency of the parent entity.

reporting tree

A visual representation of an organization's structure, showing levels in the corporate hierarchy, such as entities, divisions, departments, projects, and tasks.

See also column definition, reporting tree.

Top of Page

reporting unit

A reporting tree level that represents either an individual department that draws data directly from the financial data or a summary unit. The use of multiple reporting trees can facilitate different financial reports without affecting the financial data.

See also detail unit, summary unit.

responsibility segment

The segment or dimension of the financial data account identifier that refer to the overall organization of an entity. Examples are departments, divisions, projects, tasks, and so forth.

row code

An alphanumeric code that identifies a row in a row definition.

row definition

The specification of the text and amounts in the report rows.

See also column definition, reporting tree.

row modifier

See account modifier, scenario modifier.

row period offset (/RPO)

A switch used in a row definition when linking to Excel worksheets. If the worksheet contains multiple rows that represent different periods, the /RPO switch matches the accounting periods in the column definition with the appropriate rows in the worksheet.

See also column period offset (/CPO).

RPO

See row period offset (/RPO).

scenario modifier

A modifier in a row definition that limits a row to a specific financial data source scenario.

segment

In a fully-qualified-account-based system, a category for storing financial data. For example, you might have natural, division, and department dimensions.

See also dimension, dimension value, and segment value.

Top of Page

segment value

A unique identifier for a given segment. The length of a segment value is fixed. All values for a given segment contain the same number of characters. For example, a division segment might have values 1100 and 1200.

See also dimension, dimension value, and segment.

structure

A mask that determines the segment values or dimension values that are stored in the row definition. When a report uses a reporting tree, the structure also determines which segment values or dimension values are pulled from the reporting tree.

See also mask.

summary unit

A reporting unit that summarizes data from lower-level units. The lower-level units can be either detail units or other summary units.

See also detail unit,reporting unit.

transaction

In general, a business event which can be measured in currency and can be entered in the accounting records.

tree

See reporting tree.

wildcard character (?, *)

A special character that stands for one or more possible characters; a placeholder. For example, the question mark (?) is a wildcard character in an account mask for a fully-qualified-account-based system, and the asterisk (*) is a wildcard character in an account mask for a dimension-based system.

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!

×