Dimensional allocations

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.  

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 non-automatic and non-prohibited 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 depends on the selected entry type.

The entry type used when creating a journal and the entry type used during the balance generation (actual mode) need to 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:

Selected ledger type corresponds to Social, Generation type corresponds to Actual.

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

Selected ledger type corresponds to Legal, Generation type corresponds to 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 transaction currency are not calculated from the balance.

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

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

Enter the name of an allocation setting that was defined in Dimension structures.

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

Select this checkbox to include all users. To run this process for a single user group, leave it clear.

The current user is used if the user or group code is blank.

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

The period to be distributed is the period considered 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.

When these dates correspond to the exact fiscal year period start and end dates, the generated journal entries are identical whether Processing based on balances is selected or not. See the limitations when the allocation has multiple lines.

This field is only used for the allocation structures that 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 purpose 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.

Example:
For an Administration dimension to which advertising expenses have been posted (expense type 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.

Select the generation type:

• Actual: The actual accounting document can always be viewed and printed, such as general ledger, balance and so on.
• Active simulation or Inactive simulation: A simulated journal, when activated, is also considered on the inquiry and print screens.

When the generation type is Actual, you also need to select:

• Temporary
• Final

The entry transaction must be selected before starting the journal entry.

The action Transaction, accessible from the Display/Choose the transaction menu, opens a selection window with all the entry transactions.

After selecting a transaction, only the documents entered through this transaction are displayed in the selection list, provided that the transaction setup authorizes it.

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

Four standard transactions are delivered:

• Standard tab (STD): Only for inquiry. It is used to view all propagated, manual, and automatic ledgers.
• Standard column (STDCO): An entry transaction used when the transaction is not specified in the automatic journal. It is used to create, modify, and view any journal from a transaction in column.
• Standard line (STDLI): A transaction that has the same properties as the transaction in column. It is not used as transaction by default for the automatic journals.
• Customized column and line: Only the journals created from the same transactions can be viewed.

A journal can only be viewed:

• Through the transaction used to create it.
• Through the adapted generic transaction, specified in the Column Entry Transaction and Line Entry Transaction parameters.

The type of analytical journal to be generated.

This is the posting journal of the generated document. It must be consistent with the document type.

Any recalculation of the same allocation structure, for the same period or a period different from the initial calculation, cancels the active simulation documents created during the first calculation. It generates either new active simulation documents or actual documents, depending on the chosen generation type.

The postings generated by the calculation of the structures are recorded in the entered analytical journal.

The posting date of the generated entries.

Enables the header description for the journal postings when a value is entered.

Generates a log file if the checkbox is selected.