The Manage Allocations app allows you to create and modify allocation cycles. Additionally, templates can also be effectively utilized.
You can use this feature to download a preformatted CSV file template. It will help you to create new allocation cycles and segments or edit the ones you have already created. You work in Microsoft Excel and once you have done changes to the file, you can use the same function to upload your finished template.
There is a certain number of elements to specify. Each tab of the file corresponds to a part of the cycle, which will be detailed in the following section
The Excel template already contains a predetermined format and includes specific fields and tabs. These should not be rearranged or deleted. If a field or sheet doesn’t need to be filled out, it should remain empty. The following sheets are included within the template:
Cycle: High-level definition, including ledger assignment, company code, and controlling area. It also contains processing indicators and field groups.
Segment: High-level definition, including description, sender rules, and receiver rules.
Senders: Combination of sending objects for the cycle and segment. In Field, you define the sending object type (example: RCNTR for cost center). The selection can be a single value (From Value), an interval (From - To Value), or a group (Group ID).
Receivers: Combination of receiving objects for the cycle and segment. In Field, you define the receiving object type (example: RCNTR for cost center).
Receiver Basis: Basis on which values are sent to receivers when the receiver rule is Variable Portions. You must also specify the variable portions method.
Derivation Rules: Used to rewrite the default setting for derivation rules in an allocation cycle. The checkbox has an impact on functional area derivation for the receiver side of the allocation. If the checkbox Derive Functional Area is selected, in the cost center context, the functional area is derived based on the receiving cost center or WBS element. If the checkbox is not selected, then the functional area is inherited from the sender.
Description: Useful in case of enhancement with new elements. Contains the list of values (codes and descriptions) to use for columns in the template.
Field List: A list of characteristics that can be used as sending and receiving objects. It is a standard list of database fields. (Note: Not all fields are compatible with each allocation type and context).
When entering data on the Senders and Receivers sheets within the file, specifying a From Value without specifying a To Value means you are entering a single value.
Do not change the order of the sheets within the file, it should remain as they were when you downloaded the template.