Finally, we have built the Operational CoA in the staging area. The actual Operational Chart of Accounts (FIN OCoA) is only updated when it is synchronised with the staging Operational Chart of Accounts. The chart of accounts can only be synchronised when the compulsory Fixed Accounts have been mapped to an account in the Management Trial Balance.

Add an automation step to sync the Operational Chart of Accounts.

Processing the Chart of Account update end-to-end

Click on the Process CoA Update button to build the FIN OCoA dimension.

Open

All Active Steps should be selected. Click on Process CoA Update button to execute.

Manually synchronising the Operational Chart of Accounts

The Operational Chart of Account can be manually synchronise using the Sync Dimension button on the Administration > Chart of Account > Operational CoA tab.

When the actual Operational Chart of Account are not the same as the staging Operational CoA the Sync Dimension button will be Orange. Synchronising the actual and staging Operational CoA will turn the Sync Dimension button green.

Click on the Sync Dimension to open the popup. It can take a few seconds while an update of the mandatory flag attributes happen in the background.

Rebuild option:

• Incremental Update: Only add new accounts. Existing rollups will not be changed. No elements will be deleted from the actual Operational CoA (FIN OCoA).

• Uwind: This is the default option. The parent-child relationships between elements will be broken, then reconstructed based on the mapping changes you have made in the staging Operational CoA. If you have deleted accounts in the staging Operational CoA, they will persist in the actual Operational CoA as orphan element in the dimension. This allow the ability correct account mapping back into the account structure without losing any data.

• Delete all elements: Use this option only if you intentionally want to deleted elements from the actual Operational CoA. Make sure that the content of the staging dimension is up to date. That data associated with the delete element is also deleted.

Update Hierarchies will reconstruct the technical rollups used by Apliqo FPM. This option should be set to Yes.

Override Element Type allow for the change of element type. Changing a N-type element to C-Type element could lead to loss of data. This option should be set to No, unless you know the impact of the change.

Delete Empty Consolidations will delete C-type elements that have no components. This reduces the actual Operational CoA to only include consolidations that have natural accounts. While maintaining a full Management Trial Balance in the staging Operational CoA.