Multiple Rollups: You can summarize accounting
information from multiple perspectives by creating rollup groups.
Ranges: With a well-planned account structure, you can use ranges to group accounts in
reports,
specify security and cross-validation rules, define summary accounts and reporting
hierarchies.
Creating Vertical Structures
Consider summarizing your data according to your management [Link] a separate segment for the
lowest level in
the Accounting [Link] to use parent rollups within a single segment for reporting, rather than
creatingadditional
segments in the Accounting [Link] example, a child value of Company reports to Western Region
which reports to
European Division. Only Company is a posting level account in the Accounting Flexfield. Set up Western
Region as parent
of Company and Western Division as parent of European [Link] your company reorganizes frequently,
use parent/child
relationships for maximum flexibility.A child value can be in multiple parents. It is better to create new
parent structures
than to modify existing structures because changes can effect historical reporting. For example, if the
Western Region
contained five companies, reported year end results, and then had two more companies moved into its child
range, then
historical reports ran after the two additional companies were added would show different results.
Account Hierarchies Use various flexible parent/child account hierarchies to view
your business
according to product lines, geographical regions, organizational lines, or any other
combination of
factors you deem [Link] your hierarchy with as many vertical and horizontal
levels as you
need to effectively analyze your business or business segment. It is better to create new
parent
structures than to modify existing structures because changes can effect historical
reporting.
Accont Hierarchy Manager :
Graphically create,maintain & review account structure [Link] new parent ,child
segment values as
well as change parent/child [Link] rollup groups from the account hierarchy
manager & have you
changes reflected automatically in both key segment values & rollup group [Link] you are
creating large
hierarchies, creating numerous parents and children, or managing the attributes of many parents
and children, you
can use a spreadsheet template as a planning [Link] your spreadsheet template after the grid
format in the
Attributes window.
Attributes window.
(N) Setup > Accounts > Manager The Account Hierarchy Manager has security rules
that work
together. You can control read only or read/write access and control access to hierarchies,
segment
values, and charts of accounts
• Read Only, Read/Write Security • Segment Value Security • Chart of Accounts Security
Defining Shorthand Aliases
Defining Aliases to Represent Accounts An alias can represent the value for a single
segment, several
segments or an entire account [Link] can define an unlimited number of
aliases to represent
complete or partial [Link] aliases by navigating to the Shorthand Aliases
window.
(N) Setup > Financials > Flexfields > Key > Aliases
What are Summary Accounts and Rollup groups?
Summary Account is an account whose balance represents consolidation of
accounts
Rollup group is a collection / consolidation of parent accounts. e.g. Assets is a
total of Current assets and Fixed Assets. Current assets / Fixed assets in turn
are collection of assets.
Summary Account is an account whose balance represents the sum of other
account balances. You can use summary accounts for faster reporting and
inquiry as well as in formulas and allocations.
Rollup group is a collection of parent segment values for a given segment. You
use rollup groups to define summary accounts based on parents in the group.
You can use letters as well as numbers to name your rollup groups.
Summary accounts are consolidated balances of accounts and rollup groups is
collection of parent accounts.
Summary Accounts, Parent Values and Rollup Groups
What are Summary Accounts?
• A summary account is an account whose balance is the sum of balances from
multiple detail
accounts.
• Use summary accounts to perform online summary inquiries, as well as speed
the processing of financial reports and Mass Allocations, and Recurring journal
formulas.
• You do not enter or post transactions directly to summary accounts.
Summary Accounts Examples:
Company Segment - Summarize companies by major industry; by regions within
a country; or by country group.
Cost Center Segment - Track functional areas at a detailed level but produce
summary reports that group cost centers into one or more divisions.
Account Segment - Summarize your accounts by account type: Assets,
Liabilities, Equity, Revenue & Expense or more detailed: Current Assets.
Detail versus Summary Accounts:
• Summary Accounts are updated when journals are posted to a corresponding
detail account. They enable online summary inquiries and speed concurrent
processing.
• Detail Accounts allow direct posting of business transactions and journals.
Summary Accounts versus Parent Values:
Parent Values and Rollup Groups:
About Rollup Groups:
• A rollup group is a collection of parent segment values for a given segment.
• A value cannot belong to a rollup group unless it is a parent value that has
child values.
• Parent values and child values belong to the same value set, which is
attached to a key flexfield
segment.