Allocation Relation (tfcat4100s000)

Use this session to maintain the allocation relation details.

Field Information

Relation

The allocation relation data type that is applicable can be: actual or budgeted.

Note: The Budget Period relations are created after you enter a year budget relation and are deleted after you delete the corresponding year's budget relation.
Period

The year that the relation applies to.

Default value

The current financial year.

Period

The period to which the relation applies.

Budget

The budget that the relation applies to.

Allowed values

A single dimension budget that is not definitive.

Default value

The Actual Budget that is defined for the current financial company.

Dimension Type

The dimension type that will be credited.

Destination Dimension Type

The dimension type that will be debited.

Dimension

The dimension that will be credited.

Allowed values

A dimension with sublevel zero.

Destination Dimension

The dimension that will be debited.

Allowed values

A dimension with sublevel zero (0).

Reference Unit

The reference unit of the credited dimension.

Allowed values

If no reference units are linked to the source dimension the source reference unit can be skipped.

Destination Reference Unit

The reference unit of the debited dimension.

Allowed values

If no reference units are linked to the destination dimension the destination reference unit can be skipped.

Ledger Account

The source dimension's credited ledger account.

Allowed values

  • A Profit & Loss account with sublevel zero
  • The Allocation Type field must be Secondary Credit

Default value

The first secondary-credit ledger account in the ledger account structure of this dimension.

Destination Ledger Account

The destination dimension's debited ledger account.

Allowed values

  • A Profit & Loss account with sublevel zero (0)
  • The Allocation Type field must be Secondary Debit

Default value

The first secondary-debit ledger account in the ledger account structure of this dimension.

Sequence No.

The allocation relation number. By means of this number, you can create several allocation relations for one source/destination combination.

Distribution

The distribution by means of which the year budget will be distributed to the budget periods.

Allocation Type

The allocation type depends on the other chosen parameters of the source reference unit. You must use a uniform allocation type within combinations of relation, year, budget, period and source reference unit.

Allowed values

Reference Unit Type Quantity Based Amount Based
Planning type Retrograde Progressive Retrograde Progressive
Quantity yes yes no no
Amount no yes no yes
Percentage no yes no yes
Quantity

The quantity that is allocated to another dimension can be a part of

  • The performance budget per year
  • The performance budget per period
  • The actual performance
[

The quantity measurement unit that is defined for the source reference unit (if present).

Amount

The fixed amount that is debited to the destination dimension.

This field only applies if the Allocation Type field is set to Amount.

Percentage

The percentage of the budget or actual costs that must be debited from the destination dimension.

This field only applies if the Allocation Type field is set to Percentage.

Periodic Distribution Percentage

For the Budget Period relation and the Actual relation, this is the relationship between the period and year percentage or quantity.

Period / year x 100

for example:

20% / 80% x 100 = 25%

Valuation

A valuation can be done based on actual or budget figures. Budget relations are always based on budget figures. Actual relations are based on actual figures or budget figures, either from the Financial Budgeting System module or the Cost Accounting module.

Valuated Portion

The portion of the budget or costs that is allocated to the destination dimension.

Cost Category

The cost category by means of which the allocated quantity or percentage can be further distributed.

Note: For the valuation of the allocated quantity or percentage, only the amounts of those ledger accounts that belong to the entered cost category are taken into account.

Allocation Costs

The total account of secondary debit and primary accounts is the result of the valuated performance. These costs are calculated, after you enter a relation (preliminary calculation) and during the Process Cost Allocation (tfcat4210m000) session (exact calculation).

Cost Rate / Surcharge

The cost rate or surcharge per performance unit.

For actual allocation relations a figure can only be entered if the valuation is chosen as for the actual figures. If the allocation type is Amount, the cost rate/surcharge is set to zero (0).

Destination Variability

The variable part of the budgeted or actual costs that are debited from the destination dimension.

Costs definitive

LN automatically enters this field, when the following conditions are met:

  • An amount has been entered
  • The actual allocation relations are valuated by the budget figures
  • The Price Iteration session and Integration of Iteration Results sessions are started. This field indicates that an exact (not preliminary) calculation of the allocation costs. As long as the iteration results are not integrated, the costs can be changed. There is no connection between this flag and posting to the General Ledger module.
Text

If this check box is selected, relation text is available.