Financials >  Current processes >  Dimensional allocations  

Display all Hide all

Use this function to calculate the dimensional allocation structures. When you run this function, the dimensional allocation journal entries are generated immediately.

SEEREFERTTO See the documentation on dimensional allocation structures for further information.

Because the final allocation criteria of expenses or revenues is not known at the time of the transaction, these expenses and revenues are assigned at a later point.

This is the case, for example, with dimensions for indirect expenses, such as advertising expenses. First, these expenses are allocated to a dimension (a department, for example) on entry. They can subsequently be allocated among the other departments of a company in proportion to the sales achieved by each of these services.

This processing generates the corresponding dimensional entries (which can be viewed and modified using dimensional MO entry screens).

It groups the allocation lines in the same entry, except for:

  • Entries with currencies different from those of the main general ledger
  • Allocation of several dimensions to a single receiving dimension and generates as many entries as there are dimensions
The Partner and Flow fields are initialized when the journal is generated.

SEEINFO Read the documentation for Partner initialization and Flow initialization.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Fields

The following fields are present on this tab :

Header

Enter or select a company or a group of companies to limit the generation of journals in the balance sheet or the result of a given company or group of companies.  

  • Ledger type (field LEDTYP)

Use this field to define the ledger type concerned by the journal balance. In this function, only Manual ledgers can be accessed.

You can read the balance on the selected ledger and balance the account for that ledger type. The propagation then initializes the accounts for the nonautomatic and nonprohibited ledger types. This initialization process is based on the entry type setup and account setup.

The propagated amount is the one calculated on the main general ledger in transaction currency. This amount is then converted into the currency of the propagated ledgers.

When generating the journal balance, the propagation is depends on the selected entry type.

The entry type used during the journal generation and the entry type used during the balance generation (actual mode) must be consistent.

If the two entry types are not consistent, the balance process must be launched on each non-propagated manual ledger where the account needs to be balanced.

Examples

Entry type

Authorized ledgers

Social

Analytical

IAS

Journal generation FRODG

SOC

ANA

IAS

Balance generation FRODG

SOC

ANA

IAS

Selected ledger type = Social, Generation type = Actual

In this case, when generating the balance, the propagation is global.

Entry type

Authorized ledgers

Social

Analytical

IAS

Journal generation FRODG

SOC

ANA

IAS

Balance generation FRODI

SOC

ANA

Selected ledger type = Social; Generation type = Actual

Here, the propagation is incomplete. The IAS ledger is not propagated. If you want to balance the account on the IAS ledger, relaunch the balance process for this ledger type using an entry type that only authorizes IAS ledgers.

For an automatic ledger type, the amounts in the currency transaction are not calculated from the balance.

They are the same as the currency amounts calculated for the origin manual ledger. The ledger amounts for the automatic ledger are calculated by converting its currency amounts according to the journal entry rates.

Grid Details

Enter the company code or use the Look up tool to search for and select the code.

Criteria

This field makes it possible to enter the name of an allocation structure that has been previously defined.

This code is used to identify the site concerned. It is unique for each site.

  • All users (field ALLUSR)

When this box is checked, the data associated with all the users are involved by the process (if it is not checked, only the user whose code is given is involved (if no code given, the current user).

If a user code is entered in this field, the process only includes accounting documents entered by the user. If left blank, only accounting documents for the current user are included.

Generation

  • Starting allocation period (field STRDAT)

The period to be distributed is the period taken into account to calculate the amounts to be distributed.
On a dimension defined as the dimension to be distributed in the distribution structure, the program sums up all the postings completed over the period defined by this field. This total represents the amount to be distributed for this dimension.
SEEINFO By default the range for this period is that of the current financial year.

  • Ending allocation period (field ENDDAT)

 

  • Starting calculation period (field STRDAT2)

This field is used only for the allocation structures which use the following distribution types: "Calculated Amount" or "Calculated Quantity".
It corresponds to the reference period used in the calculation of the distribution coefficients. The principle of these distribution types is to distribute the balance (in amount) or the quantity (in non-financial units) of each selected dimension, into all the other dimensions, in proportion to the postings of the selected dimensions on a distribution nature.
The purpose of the Calculation period is to:

  • select only the postings for a given period,
  • calculate the distribution coefficients related to this period.

For instance:
Case of an "Administration" dimension to which advertising expenses have been posted (nature of the expenses to distribute: "advertising") from 01/01/07 to 31/01/07 for a value of EUR 5,000.
The aim is to distribute these expenses into the other departments in proportion to their sales (distribution nature: "Sales") recorded for the period ranging from 01/01/07 to 31/12/07.

The allocation period ranges from 01/01/07 to 31/01/07. The coefficient calculation period range from 01/01/07 to 31/12/07.

The advertising expenses posted to the "Administration" dimension are distributed into the Departments 1 and 2 in proportion to the sales achieved by these two departments over a period which ranges from 01/01/07 to 31/12/07. The distribution coefficients are calculated over this period.
The range of the coefficient calculation period matches the definition of accounting periods. It is possible to define a coefficient calculation period over multiple accounting periods of the same fiscal year. In that case, the range of these periods must be respectively the start date of the first accounting period and the end date of the last accounting period.
SEEINFO By default, the range for this period is that of the current fiscal year.

  • Ending calculation period (field ENDDAT2)

 

  • Generation type (field GENCAT)

Generation type. The journals to be generated can be of various types:

  • Actual: the actual accounting document can always be viewed and printed (General Ledger, Balance etc.).
  • Active simulation or Inactive simulation: A simulation journal, once activated, is also integrated to the inquiry and print screens.
  • Entry status (field GENSIM)

To generate a journal of actual type, specify the status:

  • Temporary,
  • Final.

The entry transaction must be selected before starting the entry of the journal.
The action "transaction", accessible by the menu Display/Choose the transaction, is used to open a selection window of the various entry transactions.
After selecting a transaction, only the documents entered via this transaction will be displayed in the left list (provided that the transaction setup authorizes it).

SEEWARNING According to the selected transaction, it will be possible or not to create, modify or view a journal.

SEEINFO The transactions with the type "Tab" do not allow the creation or the modification of journals.

The Transaction field is initialized according to the entry transaction selected.

Four standard transactions are delivered:

  • Standard tab (STD): only for inquiry and used to view all propagated, manual and automatic ledgers.
  • Standard column (STDCO): entry transaction used when the transaction is not specified in the automatic journal. This transaction is used to create, modify and view any journal stemming from a transaction in column.
  • Standard line (STDLI): transaction that has the same properties as the transaction in column but is not used as transaction by default for the automatic journals.
  • Customized column and line: only the journals created from these very transactions will be viewable.

A journal can only be viewed by means of:

SEEINFO A default entry transaction can be added to the user favorites.

This field is used to define the type of journal to be generated, and it is necessarily of analytical type.
SEEREFERTTO Refer to the documentation on the document types for further details.

This is the posting journal of the generated document. it must be consistent with the document type.
SEEINFO Any recalculation of the same allocation structure, for the same period or a period different from that of the initial calculation, will cancel the active simulation documents created during the first calculation and will generate either new active simulation documents or actual documents depending on the generation type chosen.
The analytical journal entered is the journal where the postings generated by the calculation of the structures are recorded.
SEEREFERTTO Refer to the documentation on the accounting documents for further details.

 Journal codes can apply to a specific company, a specific site or a specific group. This information is defined when the journal code is created but the selection window for this field (using the selection tool) does not take this into account. These controls will, however, be applied when you select or confirm the journal code. You can amend the journal code if an error message warns that it is invalid.

  • Entry date (field GENDAT)

Posting date of the generated entries.

  • Entry description (field GENLIB)

Enter a value in this field to initialize the header description of journal entries.

You cannot modify this field when the entry is final and the parameter value FRADGI - French fiscal regulation is set to 'Yes' for the company.

  • Log file (field TRC)

Select this check box to generate a log file.

 

Close

 

Batch task

This function can be run in batch mode. The standard task CPTDSPANA is provided for that purpose.

Specific Actions

Click this action to save the current settings in a Memo code to be reused later. The memo is linked to your user profile, not to the function or the screen.

If a memo code entitled STD is associated with the screen, it is loaded immediately on entering the corresponding function.

For further information on the advanced use of the Memo action, refer to the documentation on the General ergonomics of SAFE X3 software.

Click this action to enter a Memo code previously saved and change the setup.

Click this action to delete a Memo code.

Limitation

The management and generation of accounting documents using the double-entry method is not available for this function because it does not use an automatic journal process. Only functions that use an automatic journal process can use the double-entry method for a company.

The KRU - Russian legislation activity code must be active to use the double-entry method for a company.

Error messages

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

Document type XXXXX is not of single ledger type YYY'

"'XXXXX" corresponds to the entry type on which the processing is started.
"YYY" corresponds to the ledger type related to analytical balance on which the allocation entries will be calculated and generated.

This message is displayed to signal that one of the entry type chosen is not consistent with the ledger type called on the screen.

Tables used

SEEREFERTTO Refer to documentation Implementation