Maintaining the Chart of Account Structure
The chart of account structure can either be maintained manually, i.e. account by account, or via the "Bulk Load" feature, which will be quicker for the initial setup and also allows you to automate the entire build of the account in case a source system (e.g. your ERP) is supposed to lead the structure. The Bulk Load and Automation will be explained in a later section. In this section the main tools to manually build the CoA will be explained.
Selecting a starting point
When you open the Chart of Accounts - Operational CoA screen you should find the subset "FPM Reporting Rollups" pre-selected, which is typically a good starting point. How to work with subsets themselves will be explained later. Any custom rollups, including the C3_MGMTTB should generally be created directly under the node "Reporting Rollups".
Adding a new account
Click the "+" icon ("Add") in the row of the element you want to create the new element in, which will open a popup. Enter the name of the new element and choose the type (a consolidated element is a total that can contain children, a numeric element is the lowest level on which data can be stored). The position the new element should be mapped into is already pre-selected by clicking on the element to open the popup but you can select a different parent node if necessary. The weight is important for the signage and will normally be 1 to include the data as is, -1 if the sign should be reversed. After confirming the dialogue with "Add" the new element should appear in the correct position (you might have to expand the parent to see it).
Deleting an account
Click the delete icon next to an element to open a popup. When you click "Delete permanently" the element will be deleted. This will only impact the element itself, any children will remain in the account structure. If you intend to delete an entire tree this has to be done from the bottom up.
Mapping or moving an account
When opening the map dialogue you can perform different actions using the available parameters:
From Parent: You can choose whether and from which parent it should be removed (in case it has multiple parents). Not removing it will add it to another parent additionally.
To Parent: Choose the target parent to map the element to by firstly choosing the rollup and secondly the specific parent within this rollup. You can also choose to re-add it to the same parent if you only want to change the weight/signage.
Weight: Choose the weight/signage
Sorting accounts
When adding new accounts to a parent they will appear in the order they have been added in when you expand the parent. To change the order you can use the "Sort" dialogue by clicking the icon next to the parent. The popup will show the direct children in their current order. Use the mouse to drag and drop the child elements in the desired order and confirm with "Save".
Bulk Actions
In order to execute bulk actions, Bucket attributes need to be used. Actions button will expand bulk functions:
Bulk Delete
Assign the accounts you want to delete to a bucket. In the bulk delete popup, select the bucket and when clicking “Delete All” the marked accounts will be deleted. It is recommended to make use of the backup option, which is pre-selected by default.
Bulk Map
Multiple accounts that have been assigned to a bucket can be added to a new parent at once. They can be removed from a common parent as well
Map by attribute
Accounts can be mapped to a parent based on an attribute value that contains the parent element. The process allows to optionally remove the elements from the current parent within a reporting rollup.
Copy attribute values
A simple utility process that will copy the values from one attribute to another.