Importing allocations
Import Allocations allows the user to import allocations into the system from a .csv file. Allocations currently in the system can either be replaced by the contents of the .csv import file or they can be appended to.
Note: The Import Allocations app is an example app, which means the app could have been modified. This chapter assumes there are no changes to the Import Allocations app, however the content of the Import Allocations app can vary according to your implementation.
Accessing import allocations
- From the Tax, Close, Plan or Transfer Pricing module, select the Administration category.
- Expand Import and Export
- Click Import Allocations
Note: As Import Allocations is an example app, the location of the Import Allocations app can vary according to your implementation.
Importing allocations
Once the Import Allocations app is run, a dialog will appear allowing you to select the .csv file you wish to import. The import file should have the following columns:
Note: You can use the Export Allocations app to assist in creating a file with the proper format.
Note: Unless the import app has been modified, all standard columns from within the manage allocations table should be included in the import file except for the attachments column.
| Column | Description |
|---|---|
ID | The ID of the allocation. This field will be ignored on import as it will be auto generated by the app. |
ACTIVE |
|
CATEGORY | The category for the allocation, enclosed in double quotes. Note: The default categories are ‘”Corporate” and “Other”, but this can vary depending on your implementation. |
DESCRIPTION | The description for the allocation, enclosed in double quotes. |
MARKUPPCT | The markup % for the allocation. This is the percentage by which the source value will be adjusted prior to being allocated. |
ALLOCTYPE | The letter corresponding to the allocation type, enclosed in double quotes. Valid values are:
Note: By default, the allocation types are ‘Pattern’,‘Rate’ and ‘Direct Charge’, but this can vary depending on your implementation. |
ALLOCPCT | The allocation % for the allocation. This is the percentage of the source value that will be allocated to the target. Note: Only values greater than zero and less than or equal to 100 are allowed for allocation %, but this can vary depending on your implementation.. |
PROCESSORDER | The numeric value for processing order to define the order in which the allocations will be processed if multiple allocations are selected to run at the same time. Note: Only values greater than or equal to zero are allowed for process order. |
USESOURCEOF |
|
SOURCE | A semi-colon delimited list of symbols that define the source intersection of the allocation, enclosed in double quotes. Note: If no symbol is required (for example, timeperiods), substitute the symbol name with a dash (-) |
SOURCEEX | A semi-colon delimited list of symbols that define exceptions to the source data area, enclosed in double quotes. These are any symbols within the source data area that you do not want to allocate. Note: Only dimensions for which the source data area symbol is a parent can be set as a source data area exceptions. Note: If more than one symbol in a dimension need to be specified as exceptions, they must be delimited by a comma. |
SOURCEOF | A semi-colon delimited list of symbols that define the source data area offset for the allocation, enclosed in double quotes. The source offset is used to zero out the source value allocated so that allocated values do not change the original consolidated values. Note: The Source Offset can be left blank or will be ignored if Use Source Offset is set to 0 |
TARGET | A semi-colon delimited list of symbols that define the target intersection of the allocation, enclosed in double quotes. Note: If no symbol is required (for example, timeperiods), substitute the symbol name with a dash (-) |
TARGETEX | A semi-colon delimited list of symbols that define exceptions to the target data area, enclosed in double quotes. These are any symbols within the target data area that you do not want to allocate to. Note: Only dimensions for which the target data area symbol is a parent can be set as a target data area exceptions. Note: If more than one symbol in a dimension needs to be specified as exceptions, they must be delimited by a comma. |
PATTERN | A semi-colon delimited list of symbols that define the pattern data area, enclosed in double quotes. The pattern data area will be used to define how the source will be allocated to the target. Note: Pattern can be left blank or will be ignored if Allocation Type is set to Direct Charge (“D”). |
METHODOLOGY | The transfer pricing method that applies to the allocation, enclosed in double quotes. Note: Transfer Pricing Method only applies to Longview Transfer Pricing deployments. |
NOTES | Any additional notes for the allocation, enclosed in double quotes. Note: If no note is required, this can be set to “NULL” |
The import dialog contains a replace allocations checkbox.
If selected, all allocations in the system will be deleted and replaced with the allocations in the .csv file.
Caution: If the replace option is used to replace all allocations in the system, all file attachments currently associated with the allocations will be deleted.
If unselected, all allocations in the .csv file will be appended to the allocations currently in the system
Once you click OK on the import dialog, the .csv file will be validated prior to importing the allocations.
Note: No allocations will be imported if any allocation does not pass the required validations. Standard validations exist, but may vary depending on your implementation.