Analytical dimension entry

The Analytical Dimensions page lets you capture financial transactions in more detail than just using account numbers in the Chart of Accounts. With analytical dimensions, you can enter data that breaks down the values of any account associated with dimensions across different groups.

 Note:  To add a large amount of dimensions, we recommend that you use the Import functionality.

To access the Analytical Dimensions page, click Data Entry > Manual Data Entry > Analytical Dimensions.

Enter analytical dimensions

  1. In the Company field, enter the company code or click to select it in the selection pop-up window.

  2. In the Account field, enter the account code or click to select it in the selection pop-up window.

  3. In the Dimensions Group field, if the group is not automatically selected, select an applicable group.

  4. Click to display data based on the selections (valid combination of company/account/dimension group) you made in the fields above.

    How the data is displayed is dependent on the number of dimensions linked to the account. By default, dimensions are displayed as follows:

    • dimension 1 is displayed in rows

    • dimension 2 (if any) is displayed in columns

    • dimension 3 (if any) is displayed as a combo list

  5. Optionally, use any one of these options to filter the data displayed:

    • See all lines - (default)

    • See only lines with amounts

    • See only lines without amounts

  6. In the table, enter the values for the dimensions. The sum of the values you enter in each row and column is displayed at the end of the corresponding dimension.

    The following amounts are displayed (as applicable) in their respective fields below:

    • Adjusted amount - amount from local books including local adjustments done in Financial Consolidation. This amount should be justified by dimension, so it should be equal to the total of all values from the detail area.

    • Local amount - amount from local books excluding local adjustments done in Financial Consolidation. This amount comes from the ERP, so it can be controlled by the end user with the local books. The difference between Adjusted amount and Local amount comes from the local journals.

    • Justified amount - the total of all values filled in for the combination of company /account /dimension group, including values that are not directly visible (when there is a dimension 3 for instance or a long list of codes not directly displayed in rows /columns).

    • Difference to justify - the difference between the Justified amount and the Adjusted amount.

  7. Click .