- 4 Minutes to read
- Print
- DarkLight
- PDF
Account Mapping Enhancements for Template Setup
- 4 Minutes to read
- Print
- DarkLight
- PDF
With enhanced mapping in template setup, you can view and select both rollup and leaf hierarchy members when doing history and reference account mapping. This enhancement option makes the account mapping process quick and easy.
A new column, J, has been added to the Template Setup screen, where you can directly start each row's destination account, reference account, or reference cube mapping process. You can find the following options when you click the edit icon in this new column:
- Destination Account
- Reference Account
- Reference Cube
If any line is already mapped, clicking the edit icon in column J will directly open the respective account mapping screen.
Once the feature is enabled, you can choose the rollup member instead of individual leaf members of the mapping.
Destination Account Mapping
Click the edit icon from column J on the desired row, and select Destination Account to open the Destination account mapping screen. On this screen, you can perform account mapping for posting lines, based on your requirements. The History account mapping is available in a separate column.
Clear Mapping
If you want to unmap all the current Destination Account mappings for the selected row, you can use the Clear Mapping option available at the top menu. However, the Clear Mappings option will only clear the Posting mappings but not the History mappings. To clear the History mapping, click Edit in the History column and update or delete the mappings manually. Refer to the History Mappings section for more information.
History Mapping
If there are no History mappings, you can use the Add option in the Destination Account Mapping screen > History column and a new screen will appear. You can select segment members (roll-up or leaf) from the hierarchy for each column based on your requirements for a given row.
Use the Add Row option if you want to create more rows for history mapping. Following are other options available against each row in the History screen:
- Add - Use this option to create new rows.
- Copy - Use this option to duplicate any existing row. Then, update the required segments in the copied row and change the mapping for each column in the new row.
- Edit – Use this option to edit the mappings.
- Delete - Use this option to delete any existing mapping.
Once you have finished the mapping, click the Keep Changed and Close option to save the mapping.
Apart from these options, you can use the Show errors only toggle to view any errors that might happen during history account mapping. Enabling this toggle will display only those mapping rows that have errors. You can hover over the highlighted error fields (red underline) to know the exact issue and fix it.
Reference Account Mapping
Click the edit icon from column J, and select Reference Account to open the Reference account mapping screen. Here, you can map the line to a template and also select segment members (rollup or leaf) for each dimension column from the hierarchy based on your requirements.
Following are the options available against each row in the Reference Account Mapping screen:
- Add - Use this option to create new rows.
- Copy - Use this option to duplicate any existing row. Then, update the required segments in the copied row and change the mapping for each column in the new row.
- Edit – Use this option to edit the mappings.
- Delete - Use this option to delete any existing mapping.
Apart from these options, you can use the Show errors only toggle to view any errors that might happen during reference account mapping. Enabling this toggle will display only those mapping rows that have errors. You can hover over the account column of the rows with errors to know the exact issue and fix it.
Supported Configurations
These updates apply to the following template types:
- Global Template Single Copy (GTSC)
- Allocation
- Global Temple Entity Copy
- Template Based HR
Unsupported Configurations
These updates do not apply to the following template types:
- > 12 period
- Shared Mode
Other Limitations
- AirliftXL will not be supported.
- Wildcard characters are not supported. Existing wildcard mappings will be expanded to the matching segment leaf members.