Prior allocation keys
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
Refer to documentation Implementation
Screen management
Entry screen
Dimension views
The Dimension views block is used to define the dimension views onto which the allocation will take place.
Block number 1
Distribution (field DSP) |
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.
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. The 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.
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. The connection language must be defined as a default language for thefolder. |
Accessibility
Access code (field ACS) |
This access code is used to prohibit access to the analytical distribution key for certain users. |
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. |
Valid to (field VLYEND) |
Grid Dimension types
Dimension type (field DIE) |
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. |
field CCE1 |
Indicate, axis by axis, the analytical dimension that will be assigned to the accounting posting. |
field CCE2 |
field CCE3 |
field CCE4 |
field CCE5 |
field CCE6 |
field CCE7 |
field CCE8 |
field CCE9 |
field CCE10 |
field CCE11 |
field CCE12 |
field CCE13 |
field CCE14 |
field CCE15 |
field CCE16 |
field CCE17 |
field CCE18 |
field CCE19 |
field CCE20 |
Pre-loading the dimension views |
This function is used to transfer all set up dimension views at folder level. |
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.