This function is used to build the pyramid that has been created in the Accounts pyramid function, for any type of plan, be it general or analytical.

It is possible to entirely define the pyramid structure from this function (including the link with the basic posting accounts In the Accounts management function, it is also possible to set up the link between the pyramid and the basic allocation accounts.
The pyramid can be built from the graphical representation function.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Pyramid structure

For each accounts, as many dimension pyramids as required may be defined.

Use of an account pyramid

Level 10

Level 20

Level 30

Elementary accounts

 Margin

 

 

 

 

Other Costs

 

708*

 

Raw margin

 

 

 

Overhead costs

713327

 

 

Machine costs

713322

 

 

Material costs

713321

 

 

Labor costs

713326

 

 

Sub-contracting costs

713325

 

 Sales price

701*
702*
703*
704*
705*
706*
707*

 

 Discount

709*

The most comprehensive level concerns the global margin (level 10).

The "Margin" group is comprised of the "Raw margin", "Sales price", "Discount" and "Other costs" groups (level 20).

The "Raw margin" group is itself composed of the "Labor", "Machine", "Material" etc. production costs (level 30).

The 99 "virtual" level is comprised of the elementary accounts.

Each group is defined by the list of the sub-groups belonging to it, and/or possibly of the elementary accounts that are directly attached to it.

SEEWARNING If a given level of the pyramid is not comprehensive, the reports obtained for this level are only partial.The type of analysis can still have a meaning, if only some sections of the analysis need to be further specified.
Example:
Sub-level 30 only exists for the 'Raw margin' group.Reports for level 30 will not consider the contribution of the other accounts.

When an allocation is not mandatory on a dimension type, the groupings do not account for the missing account. This configuration corresponds to a voluntary choice by the user to exclude certain operations from the scope of analysis.

Entry screen

Block number 1

Pyramid (field VPYM)

Pyramid which the group belongs to. The modification of the pyramid for a group is impossible if:

  • the group contains sub-groups,
  • the group is itself a sub-group.
Chart (field VCOA)

This field recalls the chart of accounts on which the account or the pyramid (general, analytical, both) will be created or to which they will be attached.
Before creating an account or a pyramid, click Chart from the Actions panel to specify the chart of accounts to be attached.
Group (field VGRU)

Code identifying a group of accounts A group can be comprised of sub-groups and/or accounts.
A group belongs to a pyramid.
field VDESTRA

It is a title field.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for thefolder.
Parent group (field VPERE)

This field indicate the parent group code from which the account group comes from. If this field is not entered, the group is a first level group.

field VPDES

Identification

Short description (field VSHOTRA)

Title used in some screens or reports when there is not enough space to view the long title.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for thefolder.
Classification (field VCLSCOD)

Classification of the group accounts.

field VCLSNAM

Description linked to the Classification field name.

Management

Nonfinancial unit entry (field VUOMDAC)

It is possible to keep the analytical and budget accounts in quantities. If the alytical tracking of quantities is selected, each account group can be associated with a unit as well as a default quantity.
Nonfinancial unit (field VUOM)

Non-financial unit in which the quantity entered for this account group will be expressed.
Default value (field VDEFVAL)

The standard value indicated here makes it possible to pre-initialize the quantity according to the amount.
It is expressed in the common currency.
field VCURUOM
Budget tracking (field VBUDTRK)

If this box is checked, the group of accounts can be used in the different existing budgets.
Temporary distribution (field VTIMDSP)

The allocation key is used to define the allocation conditions of the annual budget, by assigning a weighing coeffcient to each month (refer to the Allocation documentation).
If the field is left empty, the same coefficient will be assigned to every month.

Position

Definition level (field VLEV)

Definition level of a group of accounts or a group of dimensions.
This level must be strictly less than 99, the level 99 being the finest level rewerved by convention to the accounts.
If the group is included in another group of the pyramid, the level must be strictly higher than the level of the group into which it is included.
If the group contains sub-groups, the level must be strictly lower than the level of the sub-groups.
Print row (field VPRNROW)

Printing order of the groups of a same level.
On inquiry of the analytical balance, specify the start and end print ranges.

Grid Subgroups

Subgroup (field VSBBGRU)

Account sub-group contained in the account group.
The sub-group must belong to the same pyramid as the group, it must feature a definition level strictly greater than that of the group, and it cannot be integrated to another group of the pyramid.
Description (field VSGRDES)

Title of the sub-group.

Grid Accounts

Account (field VACC)

Specify the account code.
It is possible to use the "*" and "?" wildcards to integrate several accounts corresponding to a template. The account must not have been already integrated to another group of the same pyramid.

Description (field VACCDES)

Account title.

Reports

By default, the following reports are associated with this function :

  GLGRP : GL journal account details

  GLGRPDEV : General ledger/currency

  PLAN : Chart

This can be changed using a different setup.

Specific Buttons

Pyramids

This button is used to browse through the various accounts pyramids recorded.
A new pyramid is selected in a grid listing the available accounts pyramids.
The information of the selected pyramid is then displayed in the initial screen.

This function is used to create a new pyramid based on an existing pyramid.

SEEINFO  This function is inhibited within the framework of operating budgets (dimensions coming from entities or envelopes) for the dimension groups.

This function is used to automatically generate a pyramid for a given chart of accounts. For each level of the pyramid, the length of the groups of accounts will be specified.

SEEINFO  This function is inhibited within the framework of operating budgets (dimensions coming from entities or envelopes) for the dimension groups.

Block number 1

Code of the pyramid to be generated. It has probably already been created.
This code will be used at a later time in all records.

This field recalls the chart of accounts on which the account or the pyramid (general, analytical, both) will be created or to which they will be attached.

Grid Details

  • Pyramid level (field NIVEAU)

The numerical value entered in the various available fields makes it possible to establish a hierarchy of groups present in the pyramid.

  • Account length (field LENLEV)

The numerical value entered in the various available fields is used to indicate the number of character(s) for each level of the pyramid.
For instance, if the number entered is 4 for the level 40, the length of the groups is of four characters.

Block number 3

  • Use wild-cards (field JOK)

When checked, this box is used to include any new account or dimension to the defined group.
This link is made by entering:

  • a screen,
  • a direct account number.

Example:
Let us consider a pyramid to be created for the SOC chart, grouping accounts 101 001, 101 002 and 101 003 :
1. box checked: the system uses wildcards and includes automatically any account of type 1010* (according to the screen entered). An account of type 101 004, corresponding to the screen, is thus included in the group.
2. box not checked: the system does not use wildcards. It includes only the existing accounts 101 001, 101 002 and 101 003. An account of type 101 004 is not automatically linked to the group.
  • Homogeneous levels (field HOM)

When checked, this box is used to plan the insertion of groups on a same level when they have different length so that each branch of the generated pyramid has the same number of levels.

This function is used to check that all the accounts from the ledger are referenced.

Limits

  • The number of sub-groups (in the Sub-group grid) is limited to 100.
  • The number of accounts (in the Accounts grid) is limited to 100.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Group of accounts: xxxxxx Record does not exist
The group of accounts has not been created for the selected pyramid.

Grouped in <parent group> > 10
The definition level of the sub group that has been entered must be strictly greater than the definition level of the parent group to which it is attached. For instance, greater than10.

Code already exists on line no. ##
The subgroup or group that has been entered on line no. ## has already been entered on line no. ##.

Tables used

SEEREFERTTO Refer to documentation Implementation