If your business needs to produce financial reports for more than one statutory body, you must create a mapping between each corporate GLA and its local (or alternate) equivalent. If necessary, you can create a mapping from one corporate GLA to many local GLAs, or from one local GLA to many corporate GLAs. This means that when transactions are recorded, transaction line items are populated in all relevant GLAs, ready for the individual reports to be produced.
To create a mapping between a corporate GLA and a local GLA:
Click the Chart of Accounts Mappings tab. This tab lists corporate and local GLAs that can be mapped. Only GLAs in active chart of account structures are available for mapping.
In the Map Corporate GLAs section, click the radio button beside the corporate GLA that you want to map. You can search for a particular corporate GLA by typing its name into the Search field in this section.
Select a When Dimension if applicable.
In the To Local GLAs section, click the radio button beside the local GLA that you want to map to the selected corporate GLA. You can search for a particular local GLA by typing its name into the Search field in this section. The mapping is immediately added to the list in the Mappings section and is highlighted to indicate it has not yet been saved.
Continue adding more corporate-to-local GLA mappings as required.
[Optional] To remove a mapping, click next to the mapping in the Mappings section. You have the chance to undo the deletion.
Click Save to save the mappings.
[Optional] Click Export Mappings to export the mappings to a separate file. The supported formats are XLS, CSV, and PDF. The Microsoft Excel and CSV files are downloaded to your Downloads folder. The PDF is automatically displayed. Use the Save As feature to download the PDF to your local machine.
In the Mappings list, you can sort the information by selecting the Corporate GLA column or the Local GLA column.
Editing a Mapping
To edit either the dimension type or dimension value of a mapping:
To open the list of existing mappings click the Chart of Accounts Mappings tab.
Click next to the mapping in the Mappings section.
Make your changes to the dimension type or dimension value, or both if necessary. Edited fields are shown with blue sidebars until the chart of accounts mapping page is saved.
Enter a reason for your changes, then click Save.
Auditing a Mapping
You can see how a mapping has been changed by clicking the History tab in the GLA Details section. This shows when the mapping was created and the changes that have happened to dimension types and dimension values.
Reporting on Mapping History
You can create a report that shows a chart of accounts mapping history:
On the Reports tab click New Report....
Open the Other Reports folder and click Chart of Accounts Mapping Histories.
Click Create.
Drag and drop fields onto the report, for example:
Chart of Accounts Mapping. Group by this field
Action
Field
Old Value
New Value
Reason
Chart of Accounts Mapping History: Created By
Chart of Accounts Mapping History: Created Date. Sort by this field in descending order.
Click Run Report.
Click Save As to save the report to reuse later.
Overriding the Local GLA Mapping
If you discover that a corporate GLA has been mapped to the wrong local GLA and transactions have been posted:
Amend the chart of accounts mapping so that any future or "In Progress" transactions will be posted to the correct local GLA.
Raise a manual journal to move the net amount from the incorrect local GLA to the correct one.
Override the mapping on each individual journal line item by clicking the Analysis Details icon on the journal line item and using the Local GLA lookup to select the local GLA that will override the automatic mapping applied on post.
From your Chart of Accounts Mappings page, you can create a mapping from one corporate GLA to many local GLAs, or from one local GLA to many corporate GLAs by using analysis dimensions. The dimensions are listed in mappings documents, and local GLA values are included in post-processing documents such as invoices.
To create a mapping from one corporate GLA to many local GLAs:
On your Chart of Accounts Mappings page, in the Map Corporate GLAs section click the radio button beside the corporate GLA that you want to map.
In the To Local GLAs section, click the radio button beside the local GLA that you want to map to the selected corporate GLA. The mapping is listed in the Mappings section and highlighted.
To map the corporate GLA to another local GLA, select the corporate GLA, then select a Dimension from the picklist, then select a different GLA. You can select as many local GLAs as the number of dimensions.
[Optional] To remove a mapping, click next to the mapping in the Mappings section.
Click Save to save the mappings.
If you click Export Mappings the document displays the mappings with dimensions.
Resolving Mapping Conflicts
The icon shows when there are possible mapping conflicts. This icon appears beside either the corporate GLA or the local GLA in the mapping. Mappings are conflicting if they can both be a candidate for resolving the alternate GLA when posting a document. We recommend that you click the icon to check the mappings that may conflict with each other. However, you might decide that there is no conflict and leave the mappings as they are. Otherwise, if you decide there is a conflict, then you can remove a mapping by clicking the next to it.
For example, you see a icon if you create mappings from one corporate GLA that use more than one dimension type:
Mapping1 = Corp1, Local1, Dimension1 = Dim1
Mapping2 = Corp1, Local2, Dimension2 = Dim2
Mapping3 = Corp1, Local2, Dimension2 = Dim3
Mapping4 = Corp1, Local2
Mapping1 and Mapping2 conflict, but Mapping2 and Mapping3 do not. Mapping4 is a default mapping, where a dimension is not used. Default mappings are used to resolve conflicts and populate alternate accounts. If a default mapping does not exist, then the default local GLA on the company's chart of accounts will be used.
These examples describe resolving mapping conflicts from a corporate GLA to a local GLA. The process is the same to resolve mapping conflicts from a local GLA to a corporate GLA.
Payable Invoice Example 1
Using the mappings above:
If your payable invoice settings are GLA = Corp1, Dimension1 = Dim1
Then the system picks Mapping1 and populates the local GLA on the transaction line item as Local1
Payable Invoice Example 2
Using the mappings above:
If your payable invoice settings are GLA = Corp1, Dimension1 = Dim1, Dimension 2 = Dim2
Then the system sees that both Mapping1 and Mapping2 are candidates to populate the alternate account. This is a conflict. The system picks Mapping 4, as default, to resolve the conflict.
next to the mapping in the Mappings section. You have the chance to undo the deletion.
next to the mapping in the Mappings section. 
on the journal line item and using the Local GLA lookup to select the local GLA that will override the automatic mapping applied on post.
next to the mapping in the Mappings section.
icon shows when there are possible mapping conflicts. This icon appears beside either the corporate GLA or the local GLA in the mapping. Mappings are conflicting if they can both be a candidate for resolving the alternate GLA when posting a document. We recommend that you click the icon to check the mappings that may conflict with each other. However, you might decide that there is no conflict and leave the mappings as they are. Otherwise, if you decide there is a conflict, then you can remove a mapping by clicking the