Use this function to create and manage analytical dimensions.

The analytical dimensions are the "management centers" designed to aggregate the accounting information for analytical and budgetary purposes.

Their nature depends on your analytical objectives, which determines the basis for analytical dimension types.

Examples:

Service dimension type

This dimension type can be used to break down the company's activity by service and is composed of one dimension per service.

Sector dimension type

This dimension type can be used to analyze the turnover/revenue by geographic area and is composed of one dimension per region.

Vehicle dimension type

This dimension type can be used for tracking the costs for operating company vehicles and is composed of one dimension per vehicle, etc.

The dimensions are created for a given dimension type. There can be up to 9 dimension types independent of each other. Click Dimension type to browse through each dimension type plan.

The analytical sections are associated with the analytical accounts. The analytical dimensions make up a reference element in the analytical (allocation of accounting entries) and budgetary (entry) management. They are mainly used to carry out comparisons between the "actual" and the "budget."
Entering budget elements on an analytical dimension can be prohibited.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

You can create as many dimensions as needed on an analytical dimension type. This dimension type is specified in the header. Click Dimension to choose an analytical dimension type.

Dimension type (field DIE)
Dimension (field CCE)
field DESTRA

Common title of the current record.
Short description (field SHOTRA)

Tab General

Other dimension types block

In document entry mode for invoices or payments, a dimension can be filled automatically depending on the previous dimension section.

Setting up the automatic loading of dimension types:

  • Setting up default dimensions.
    When entering documents, for example, use the default dimension code GACCEN1. To automatically load dimensions in a journal entry, the dimension type must be Previous dimension.
    This processes the previous dimension to update the current dimension
  • Linking the default dimension code in the Journal entry transaction.
    In the example, enter the GACCEN1 code in the Default dimensions field on the Dimensions tab.
  • On journal entry, the program suggests by default the dimension entered in the Default dimension column.

Accessibility

Active (field ENAFLG)

Select this check box so that the data can be used in other records (documents, parameters, etc.) or during a mass processing. If not selected, the data is considered to be inactive and it cannot be used in other records.
Access code (field ACS)

This access code is used to prohibit access to the dimension for certain users.
If this field is assigned, only the users who have this access code in their profile will be able to modify or enter this dimension. According to the rights assigned the following operations will be possible:
Enquiry: This is used to display the postings passed for this dimension (the display of the database record is always possible).
Modification : This allows the modification of the database record.
Execution : This is used to post the entries in this dimension.
Company/Site/Group (field FCY)

When this field is entered, the dimension can only be used for the designated entity. Sites are always financial sites and groups always include one or several financial sites.
Description (field LIBFCY)
Validity start date (field VLYSTR)

These dates define the period during which the dimension can be used.
If the start date is not given, the dimension can be used from the first day of the first financial year.
If the end date is not given, the dimension can be used from the start date without limit of time.
Validity end date (field VLYEND)
Restriction code (field AUZ)

Enter a restriction code at this level or set one up at the dimension-dimension, account-account, or account-dimension Restriction code level.

To ensure the coherence of postings, you can forbid the entry of associated accounts with specific dimensions, accounts with other accounts, or dimensions with other dimensions.

The principle is to define "forbidding code" pairs that are not compatible when posting. When an account and a dimension have incompatible codes, they cannot be used together for posting the same entry line.

Management

Carryforward (field FRW)

If you select the Carry forward check box, the balance for the current dimension is carried forward for the accounts for entries from this dimension (if these have RAN). This allows all the entries from a dimension to be carried forward from one period to another.

SEEWARNING This check box is not relevant if the no carry forward check box is selected at the dimension types level.
Budget tracking (field BUDTRK)

When this field is checked, a budget can be build in this dimension. Using some dimensions can thus be reserved to the analytical accounting.

Associated with the analytical accounts, the dimensions are the reference element in the analytical management (posting of accounting documents) and budgetary management (entry). They are mainly used to carry out comparisons between the "actual" and the "budget".
It can nevertheless be decided to restrict the entry of budget elements in an analytical dimension.
Chargeable (field IPT)

This field indicates if the dimension can receive entries.
If it is not the case, this dimension will be set aside for the budget accounting, that is if this dimension can be Budgeted.

Grid Other dimensions

Other dimension (field OTHDIE)

It is possible to initialize the value of a dimension type with respect to another. By specifying dimension types and associated dimensions, the current dimension can be used to initialize the dimension types concerned.
Default dimension (field DEFCCE)

Grid Nonfinancial units

Nonfinancial unit (field UOM)

This grid is used to define all the operation units and a value (permanent) assigned to the dimension for this unit.
This information will be used by the analytical distribution programme at a later point in time.
Quantity (field QTY)

Tab Controls

Grid Pyramids

Pyramid (field PYM)

Enter a dimension pyramid.

Principally used for reports and inquiries, dimension pyramids are used to characterize the summary (roll-up) level and order of the information to be retrieved. Their update is retroactive to the construction of the pyramids and need to be refreshed after creation and modification.

According to the analysis and roll-up objectives, you can attach each dimension to several pyramids to a single dimension type. On the other hand, a dimension can only be attached once to a pyramid (to a single dimension group).

It can also be done within the specifications of the groups of dimensions.

SEEREFERTTO See the documentation on Dimension groups.
Group (field GRU)

This field displays the Group for the analytical pyramid containing the analytical dimension.

Level (field LEV)

This field displays the Group definition level. This level must be less than 99, level 99 being reserved by convention to the dimensions. If the group is included in another group of the pyramid, the level must be greater than that of the group in which it is included. If the group contains sub-groups, the level must be less than that of the sub-groups.
Row (field PRNROW)

Printing order of the groups of a same level.

Screen (field CRI)

This field is not required.

If no screen is specified, the dimension is attached directly to the pyramid's group specified on the line. You can exclude it by deleting the line.

When a screen is entered, the dimension is automatically attached to this group and can be excluded only by modifying the screen in the group itself.

Use the following wildcards in the screen specifications:

  • * to replace any chain of characters
  • ? to replace a single character

Reports

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

  LISSEC : List of dimensions

This can be changed using a different setup.

Specific Buttons

Dimension Type

A dimension type can be chosen by means of the Dimension type button.
In the left list, the available distribution groups or analytical dimensions are displayed for the selected dimension type.

SEEINFO On opening, the function recovers by default the first dimension type (alphanumerical order) for which a distribution group or analytical dimension has been created.

Click this function to perform a dimension inquiry. A new screen opens to the current dimension type.

Click this function to view budget management. A new screen opens to the budget transaction whose first line corresponds to the current dimension.

Use this function to copy the dimension type associated with the current dimension.
Copying can be useful during a preparatory phase or, for example, for two separate companies to use the same dimension type, except for a few dimensions. In the latter case, it is more convenient to copy a chart of accounts and to introduce a few subsequent modifications.

Copy can be performed:

  • From the current folder to the current folder
  • From the current folder to another folder
  • From another folder to the current folder

SEEINFO 

Limitations

  • If you change a dimension code (Action panel > Utilities / Change the key) that exists in the Sage 50 import transcribe (GESKPS) function (KPYIMPTRAN table), that change is not reflected in the KPYIMPTRAN table.
  • You cannot delete a dimension that exits in another function or table, such as the KPYIMPTRAN table. If you try to delete such a dimension, the deletion is blocked.

Error messages

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

Mandatory field

It is mandatory that this field is completed by the user.

Incorrect date

This message can be displayed for instance if the validity end date entered is earlier than the validity start date.

Code already entered on line #

The entered pyramid has already been entered on line #.

Tables used

SEEREFERTTO Refer to documentation Implementation