Data drilldown in financial statements - main

To view a statement account structure:

  1. Select a statement account, if required.
  2. Click the View Tree button or, from the appropriate menu, select View Tree.
  3. In the Statement Account Structure window, do any of the following:

    • Use the appropriate command on the View menu to display the financial statement by column or by statement account.
    • Where the statement account or statement colum is preceded by a ‘+’ sign, you can click that line to display the next hierarchical level. In this way, you can drill down until you reach the statement accounts with sublevel 0 (the posting level).
    • For each statement column a line is displayed with the formula. You can click each variable, to display the ledger accounts that are linked to that statement account. Any dimensions linked to the ledger account are displayed on the next level. To summarize these lines by dimension type, use the Aggregate to Dimension command.
    • Double-click or right-click the lowest level (the finalized or non-finalized line), to start a session that displays the individual transactions that make up the balance of that line.
    • Use the Finalized Transactions and Finalized Transaction Lines commands on the appropriate menu, to view the details in the standard General Ledger sessions.
    • Right-click the statement column variable line to start the related transactions session, in which you can use the appropriate menu to access the transaction and document details sessions.