The GL Alias Interface provides the ability to update an alias level or all levels of the alias on a GL by GL basis.
The upload file MUST be in comma or tab delimited format and the fields must be in the following order:
|
File Order |
Explanation |
|---|---|
|
GL |
GL can be loaded with or without dashes in the upload file |
|
Alias Level |
Alias levels begin at 1. Indicating a level of 0 will allow the entire alias to be loaded for a GL |
|
Alias Value |
The value of the alias being loaded on the GL, or if the level indicated '0', the entire alias. |
Enter File Location
-
Enter the disk and the directory where the file is located (ex. DKA100:[TRANSFER]) A defined 'logical' can also be used if available (e.g., SRB$TRANSFER) ( a logical is a shortcut to a directory).
Enter File Name
-
Enter the name of the file to be uploaded.
GL Year to Process
-
Enter the fiscal year that is to be updated.
Preliminary/Final
-
Enter 'P' to run a report only.
-
Enter 'F' to run the report and update the alias codes.
The upload process will verify the following conditions. If the condition is not met, the problem record(s) will not be uploaded. A status column in the report will indicate the problem.
-
GL account is valid.
-
Alias code(s) is valid (alpha values must be uppercase)
-
Alias level is valid
-
Correct number of columns in the upload file.
Note: If alias values are found that are shorter than the required length, as defined in the 'Alias Account Format' (atrieveFinance > Finance Setup > Profiles > Alias Account Format), the alias codes will have zeros applied to the beginning of the codes.