Skip to Content

1. A category scenario provides the following:

a.       The data entry environment i.e. the structure of the data managed by Finance:

b.      For entering data in the package via schedules or journal entries.

c.       For central manual journal entries.

2.    2.The different types of automatic data processing involved in consolidation:

a.       Converting data.

b.      Impacting scope changes on data.

c.       Applying the consolidation rates selected for the flows.

d.      The automatic generation of opening balances.

3.     3. The controls to be run on the following:

a.       Packages.

b.      Manual journal entries.

4.     4.To access the Category Builder view, click on the Category Builder menu in the Setup domain.

BOFC_1.JPG

Following Nine Steps have to be defined in the Category builder.

1.             Open the Category Builder view in the Setup domain and click on File –> New.

BOFC_2.JPG

In In the Definition step, select the Category and the Version then enter the descriptions.

BOFC_3.JPG

Chart of Accounts

The chart of accounts is a hierarchical representation of the accounts assigned to the category scenario. You may organize the hierarchy of accounts by dragging and dropping them. Additionally, you may adjust their calculation properties if necessary.

Organizing accounts into a hierarchy enables you to perform rollup calculations on local or consolidated data. This type of organization also enables you to define the properties of an account and automatically assign these properties to its sub-accounts.

BOFC_4.JPG

A hierarchical Chart of Accounts can be defined in three ways:

a.       Manually define the hierarchy by dragging and dropping the accounts and the aggregated items.

b.      Using an account hierarchy that is present in the Dimension Builder.

c.       Copying an account hierarchy used in another category scenario.

           Click on the Create Chart of Accounts Hierarchy Button and Choose the method accordingly in the dialog window which appears.

          BOFC_5.JPG

            BOFC_6.JPG

        

You define the accounts’ calculation properties in the chart of accounts in the Calculation tab.

a.       The Data entry sign is the sign in which amounts are generally expressed (usual data entry sign).

b.      The Rollup sign is the sign used for the aggregate calculations (rollup).

c.       The Journal entry sign is automatically set by Finance. It sets the debit or credit sign depending on the account type and data entry sign.

In the Calculation tab, you can define the account type, the data entry sign and the rollup sign. The journal entry sign (debit/credit) is deduced from these properties.

           BOFC_7.JPG

Options

Journal Entries Tab

The Journal Entries tab of the Options step allows you to define where in the data collection process journal entries may be created. There are two options from which to choose:

a.       Central manual journal entries: adjustments can be entered in the form of central manual journal entries.

b.      Adjustments in packages: package adjustments will be authorized.

Once you have determined the basic location where journal entries are accepted, you may then specify how those journal entries may be managed:

c.       The Authorize replacement of manual journal entries option: you are able to change a manual journal entry without having to reverse it.

  

d.      The Require reversal of manual journal entries option: if there are manual journal entries at central site and/or in the package, you will prevent them from being deleted or modified. Rather, to counteract the mistaken journal entry, you must create another journal entry that is the exact opposite of the first.

e.      In schedules: it is possible to enter adjustments in the package schedules.

f.        Apply package rules box: the package rules will be applied to the entries.

BOFC_8.JPG

Data Entry Tab

In the Data entry tab of the Options step in standard mode, you can define the default data entry environment for packages, i.e. the default data entry folders and how the controls work.

The environment you define apply to all of the reporting IDs and packages associated with the category scenario.

  

In the Data entry tab, define the package environment:

a.       Windows and Internet folder: Select the folder used by default for entering package data in Windows and via the web, if there is no internet-specific folder. You can select any data entry folders not linked to the other categories.

b.      Internet-specific folder: Select the folder that will be used by default for entering package data via the web. You can select any data entry folders not linked to the other categories.

c.       Set of controls: Select the set of controls that will be run on the package by default. You make this selection from the sets of controls defined for the category scenario.

d.      Control level to be reached: specify the level to be reached to validate the package. You can make this selection from the control levels defined for the category scenario.

e.      Blocking: You can specify whether the control level to be reached is blocking: if you select this option, all of the controls at the specified level or lower must run successfully for the package to be published.

f.        Lock on publication: Select the locking status of the package. Three types are possible:

                                          i.      All: The package will be locked and no further changes can be made.

                                         ii.      All except adjustments: The package will be locked and the data can only be changed by making local adjustments (by manual journal entry or in the schedules).

                                         iii.      None: The package will not be locked and changes can be made. This locking status is selected by default.

g.       Set of rules: Specify the set of package rules that you want to assign by default.

BOFC_9.JPG

Integrate zero balances: if you check this box, the “0” values that are either entered directly or calculated will be integrated in the pre-consolidated data.

Periods

When you define periods, you can specify the start of the data entry period, i.e. the start date (in year.month format) and the periods in the data entry period.

A category version can be for one period only (the data only refers to one period in each data entry period) or for several periods (if the data refers to more than one period in a data entry period).

BOFC_10.JPG

Flow Analysis

Now go to the flow analysis options and assign the relevant flows to the relevant accounts.

BOFC_11.JPG

Dimensional Analysis

The dimensional analysis describes the analysis levels and dimensions used to break down the data.

BOFC_12.JPG

  

Decide on how the data will be broken down depending upon the partner, profit center , functional area etc and create dimensional analysis and assign the relevant accounts.

Controls

This step contains the manual and automatic controls set up in the category scenario. They are grouped into subsets of controls,which are in turn organized into sets of controls.

BOFC_13.JPG

Once the category is validated, it must be distributed. Distributing a validated category scenario makes it available for use.

BOFC_14.JPG

BOFC_15.JPG

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Udo Lindemann

    Thanks for the overview. It is not mentioned that you have to choose the extended mode for this category scenario. I think it is helpful to know how to create dimensional analysis and controls with practical examples.

    (0) 
    1. Srinivas Hemadri Post author

      Hi Udo

      I will be modifying that to include extended mode and dimensional analysis also. I have published some more docuemnts. Request you to please advise if I need to add something more.

      Thanks

      Srini

      (0) 

Leave a Reply