- 4 Minutes to read
- Print
- DarkLight
- PDF
Account Mapping Enhancements for Template Setup
- 4 Minutes to read
- Print
- DarkLight
- PDF
With enhanced mapping in the template setup, you can view and select the rollup members along with the leaf members of a hierarchy while doing history and reference account mapping in the template setup, making the account mapping process easy and quick.
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.
Post enablement, you can choose the rollup member instead of individual leaf members in one row of the mapping, and then delete the other rows that have the related leaf members mapped to that rollup.
Destination Account Mapping
Click the edit icon from column J aligned to the desired row, and select Destination Account to open the Destination account mapping screen. On this screen, you can perform Posting account mapping based on your requirement for each column. 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.