Modifying allocation basis

Glossary

Basics of using a typical web page

This page allows you to modify the details of an allocation basis. Tell me more.

The “Edit Allocation Basis” page appears.

The system displays the following:

Run No

The number identifying all the sequence of allocations that have been defined on a finance book for a particular accounting period.

Sequence No

The number identifying the particular allocation of the entire sequence of allocations that has been defined on a finance book for a specific accounting period.

Note: To modify allocation details, the combination of the run number and the sequence number displayed above must be in “Active” status.

Status

The status of the allocation which must be “Active”.

Finance Book

The code identifying the finance book that has been mapped to the run number.

Accounting Year

The accounting year in which the cost allocation is done.

Accounting Period

The accounting period present within the accounting year in which the cost allocation is done.

Note: The accounting period displayed here must be in “Open” status.

Source Cost Center

The code identifying the cost center from which the cost is allocated.

Note: The source cost center displayed here must be valid for the run number, sequence number, accounting period and the finance book.

Description

The description of the source cost center.

 

Zoom facility available

Target Cost Center From

The starting code in the range of codes identifying the cost centers to which the cost is transferred.

To

The ending code in the range of codes identifying the cost centers to which the cost is transferred.

Basis/Weightage

Use the drop-down list box to select the method in which the cost from the source centers is distributed among target cost centers. You can select from “Percentage”, “Ratio” or “Cumulative”.

 
  • Ratio – indicates that the cost is distributed to the target cost centers by means of ratio.

 
  • Percentage – indicates that the cost is distributed to the target cost centers by means of percentage.

 
  • Cumulative – indicates that the cost is distributed to the target cost centers on a cumulative basis.

Cost Element

The code identifying the target cost element that has been mapped to the target cost center (Alphanumeric, 32).

Note: Atleast one row of data should be present in the multiline. Cost elements entered in this field should not be duplicated.

The system displays the following:

UOM Code

The code identifying the unit of measurement.

Note: The unit of measurement is displayed in this field only if the cost element is of type “Allocation Cost Element” or “Activity Cost Element”.

Quantity/Value

Use the drop-down list box to specify whether the cost id distributed to the target cost elements based on value or quantity. You can select from “Quantity” or “Value”.

 
  • Quantity – indicates that the cost is distributed to the target cost elements based on quantity.

 
  • Value – indicates that the cost is distributed to the target cost elements based on value.

Note: If the cost element specified for this row has been specified as an “Allocation” cost element, then the value entered in this field should be “Quantity”.

If “Cumulative” has been selected in the “Basis Weightage” field then the values selected in all the rows of the multiline should be same.

If “Cumulative” has been selected in the “Basis Weightage” field and  “Quantity” has been selected in this field then the “UOM Code” of all the rows of the multiline should be the same.

Actual/Budget

Use the drop-down list box to specify whether the allocated cost is actual or budgeted. You can select from “Actuals” or “Budget”.

 
  • Actuals – indicates that the allocated cost is the actual cost incurred by the cost center.

 
  • Budget – indicates that the allocated cost is the budgeted cost incurred by the cost center.

Budget No

The number identifying the cost budget that has been mapped to the target cost center and cost element (Alphanumeric, 10).  This value must have been defined in the “Cost Budget” business component for the business unit and within the start date and the end date of the accounting period and must be in “Authorized” status.

 

Help facility available

Note: This field should not be left blank if “Budget” or “Both” has been selected for the allocation in the “Allocation On” field of the main page.

The type of the budget number entered here must be “CC-CE” and must period budget.

Also, the budget number entered here should be valid for the basis cost element and the target cost center.

Ratio/Percentage

The ratio or percentage of cost to be distributed to the cost element (Decimal).

Note: This field should not be left blank and value entered should not be greater than zero if “Cumulative” has been selected in the “Basis Weightage” field.

If “Percentage” has been selected in the “Basis Weightage” field then the sum of the values of this field in the mutiline must be equal to 100.

Reset Ratio/Percentage Values

Allocation Basis Flag Updation

Activate Ratio/Percentage Values

Allocation Basis Flag Updation

The system displays the following:

Created By

The login ID of the user who created the allocation details.

Created Date

The date on which the allocation details were created.

Modified By

The login ID of the user who modified the allocation details last.

Modified Date

The date on which the allocation details were modified last.

To proceed, carry out the following

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Modifying allocation basis – An overview

You can modify the details of the allocation basis that have already been created when the “Allocation Basis” flag has been set to “Yes” or create it newly when the “Allocation Basis” flag has been set to “No”. You can modify all the parameters pertaining to the allocation process like the means of distribution, the type of cost distributed and the quantity or value of the cost allocated for the various types of cost elements. The system saves the allocation basis and nullifies the ratio/percentage values that have already been set for the target cost center and cost element.

This page also allows you to delete an allocation basis that has been set for an allocation process. The system deletes the allocation basis details and activates the ratio/percentage values that have set for the target cost center and cost element. This can be done only when the percentages specified in the target cost center multiline satisfy the conditions which any new allocation has to satisfy like the sum of percentages/ratios being equal to 100/1 respectively. The system also updates the login ID of the user and the system date along with the modification details.