Common data > General accounting tables > Analytical > Analytical allocations 

It often happens that several analytical allocations correspond to one accounting allocation. In that case, the "distribution" enables an amount entered to the general ledger to be distributed onto several analytical dimensions.

When the distribution terms are used on a regular basis, they can be saved by means of the setup of the budget weighting codes that can be recalled at any moment during entry.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

Dimension views

The Dimension views block is used to define the dimension views onto which the allocation will take place.

Close

 

Fields

The following fields are present on this tab :

Block number 1

The analytical distribution keys are used to automatically distribute the line amount of a posting in financial accounting over several analytical lines according to the weighting factor and this done in a single entry.

The analytical distribution key is composed of 1 to 10 alphanumeric characters.

  • Description (field DESTRA)

Title of the allocation code (alphanumerical, on 30 characters).

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.

SEEINFOThe connection language must be defined as a default language for thefolder.

  • Short description (field SHOTRA)

The short description replaces the standard description when display or print constraints require it.

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.

SEEINFOThe connection language must be defined as a default language for thefolder.

Accessibility

This access code is used to prohibit access to the analytical distribution key 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 use this analytical distribution. According to the rights assigned the following operations will be possible:
Enquiry: Used to view the postings that use this analytical distribution (the database enquiry is always possible).
Modification : This allows the modification of the database record.
Execution : Makes it possible to use this analytical distribution in posting entries.

  • Company/Site/Group (field FCY)

if this field is entered, then the analytical distribution key can only be used for this site.

  • Description (field LIBFCY)

 

  • Valid from (field VLYSTR)

These date define the period during which the analytical distribution key can be used.
If the start date is not entered, the analytical distribution key can be used from the first day of the first financial year.
If the end date is not entered, the analytical distribution key can be used from the start date without end date.

  • Valid to (field VLYEND)

 

Grid Dimension types

This field is used to enter or select any dimension view set up in the database.

Grid Dimensions

  • Coefficients (field COE)

This coefficient is used to calculate the amount to be assigned to the dimension that are defined later.
The total of the coefficients in this grid must not exceed 100%, the software calculates itself the relative weighting for the different lines with respect to the account posting amount.

Indicate, axis by axis, the analytical dimension that will be assigned to the accounting posting.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Close

 

Action icon

Pre-loading the dimension views

This function is used to transfer all set up dimension views at folder level.

 

Close

 

Reports

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

 LISDSP : Analytical allocation list

This can be changed using a different setup.

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 be completed by the user.

Dimension reserved to site XXX

The dimension has been set up with a limited access to the specified site. The "Selection" function should be used to look for another dimension or the "analytical dimensions" function, to directly access the analytical dimension setup.

Dimension XXX cannot be posted

The dimension has been set up as unable to be posted on entry. The "Selection" function should be used to look for a dimension that can be posted or the "analytical dimensions" function, to directly access the analytical dimension setup.

XXX prohibited with dimension YYY

The entered dimension has been given a prohibit code that prevents it from being combined with one or more other dimensions of the key. The "Selection" function should be used to look for another dimension or the "analytical dimensions" function, to directly access the analytical dimension setup.

Dimension mandatory for dimension view XXX

In the general parameters of the folder, it has been specified that the posting was mandatory on the dimension view concerned. The "Selection" function should be used to look for an existing code or the "analytical dimensions" function, to directly access the analytical dimension setup.

The sum of the coefficients must not be equal to zero.

The calculation of the amount to be distributed is carried out using a rule of three. A control is carried out on the denominator (it must be different from zero). Therefore the coefficients need to be corrected.

Incorrect date

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

 

Tables used

SEEREFERTTO Refer to documentation Implementation