Training: Manually Maintaining the Operational Chart of Accounts
- Adam Davis
Adding accounts
Accounts and Consolidations can be manually added to part of the Operational CoA that is not managed an Automation step. In this example, are going to add statistical accounts to the Operational CoA.
Repeat the same steps to add the following statistical accounts.
Quantity Consolidated
Quantity Unconsolidated
Memory Shipped in GB Consolidated
Memory Shipped in GB Unconsolidated
Click Process CoA Update button to update the FIN OCoA dimension.
Deleting an account.
Click the Delete icon next to an element to be deleted.
Confirm the element and click Delete Permanently. The element will be deleted the staging CoA. This only impacts the element itself; any children will remain in the account structure. If you intend to delete an entire tree, delete the accounts from the bottom up.
Moving accounts (Map).
The statistical accounts, Quantity Consolidated and Quantity Unconsolidated can be summed up into a consolidated element called Quantity using the Map function.
Remap the Memory Shipped in GB Consolidated and Memory Shipped in GB Unconsolidated statistical accounts to a new consolidation Memory Shipped under the Statistical Accounts rollup.
Map an account.
Click on Map icon net to the element that is to be mapped.
Element: The account or metric that is to be re-mapped.
From Parent:
You can choose to keep the existing parent relationship of the element.
Remove the element from the any existing parent.
To Parent:
Choose the target parent the element be mapped to. First choosing the primary rollup and then the specific parent in the primary rollup.
When you want to change the weight, you can also choose to re-add the element it to the exist parent.
Choose to remove the element from the selected parent only.
Weight: Set the weight of the between the element and the new parent element.
Changing the sort the account order.
Initially the accounts will appear in the order that they have been added. This can be change using Sort popup.
To change the order of the accounts, drag the accounts up or down list. Click on Save to update the order in the CoA.
Bulk Actions
Bulk Actions are used with the Bucket Attributes. Click on Manage Attributes to show the Bucket Attributes in the Operational CoA tab.
Delete multiple accounts.
Assign the accounts that are to be deleted to a bucket.
Select Actions > Delete… on the toolbar.
Select the Bucket to be used.
There is an option to backup the CoA before deleting the selected accounts.
Click on Delete All.
Map multiple accounts.
Assign the accounts that are to be mapped to a bucket. Select Actions > Map… on the toolbar. The mapping options are the same option for a single account, see above.
Map multiple account by attribute.
Use a value in an attribute to map the account.