| Info |
|---|
On September 03, 2024, we began the process of migrating the account mapping feature to Groups. See this release note to learn more about the migration. When your organization is migrated, you’ll perform the dimension-creation and account mapping task within the Groups feature, making the information on this page redundant. See Create sub-dimensions for accounts instead. |
In addition to customizing the top levels of your statementfinancial statements, you can add sub-levels to the statement gridstatements. To achieve this, you firstly create a new sub-dimension, then select General Ledger accounts and apply them to a list of entities that you create within the new dimension.
| Info |
|---|
A dimension is a level in your statement and an entity is a value within a dimension. For example, a dimension is Country and the entities are Australia, the UK and the USA. |
You can then add the new dimension to the statement grid, to gain within that dimension, you create entities that you apply to selected General Ledger accounts. Back in the statement grid, when you add the new dimension as a level, you will see the entities display as sub-levels underneath the applicable category row. This new dimension gives you a level of detail that you didn't have in your original dataset. For example, you might want to categorize costs under the Operating Expenses group, so you can drill down and see these details at a glance on the grid.
| Info |
|---|
When using this method to create a dimension, you cannot differentiate at a level lower than a General Ledger account, such as cost centrecenter. This However, this can be done via the Designer , based on your setupmodule. |
In the statement setup window, click the Accounts tab.
Create the dimension: Click the green plus button
, then enter a name for the new dimension, for example Cost Type, and click OK.
The
dimension
displays as a new column in the account grid.
Create the entities (sub-levels):
Select an account by clicking the number to the left of its name, then in the new dimension column header, enter the name of the entity that you want to apply to the account, for example, Client Driven, and press Enter.
Repeat the above step to add other entities to the dimension or select an entity from the list to apply to other accounts.
Set the order in which the entities display under the dimension:
Click the AZ button next to the dimension column name.
Expand the applicable category, for example, Operating Expenses.
Click and hold the entity's move button (a blue box displays around the row), then drag the entity up or down to its new position.
Repeat the above step to reorder the other entities as required, then click Apply.
Click Save.
If you are finished customizing the financial statement, click Close > Yes to rebuild the database and view your new dimension.
Related pages
Customize Add a financial level in the statement grid