Rules

  • All dimensions are restricted to a single member.
  • All lines for the selected Schedule dimension are shown if the Suppress Zero Rows check box is not selected. When the Suppress Zero Rows check box is selected, lines containing all zeros or blank values are not shown on the main report, including the ownership data. The Suppress Zero check boxes do not apply to the Detail report.
  • Formula lines are treated as data lines. When running the report using the Consolidation % option, formula lines are factored like data lines. Any formula line that should not be factored, such as ratio formula lines, should not be included in the Unit Contribution report.
  • Opening balance, beginning balance, ending balance (except acquisition lines) amounts are displayed for the selected unit only when running the Unit Contribution report with the Consolidation % option. Acquisition lines are included in the OB/BB/EB suite but there are no restrictions on their processing at Consolidation %.
  • No ownership information is displayed for the selected unit. Ownership information is relative to a parent unit and there is no parent node information for the selected unit.
  • Effective control percent, effective ownership percent and minority interest percent are only relevant to applications using the ownership process. Those are blank when reading ownership data specified in Architect.
  • The consolidation method is set to Full on the report with all other ownership lines blank when the ownership process is turned on and there is no ownership data available for the unit and selected period. In that case, amounts are effectively not factored when displaying at Consolidation %.
  • The Journal Name column of a Detail report can contain more than a journal name.
    • Reported identifies a reported amount. Note that an Intercompany transaction amount is considered a Reported amount for an IC line and a leaf unit.
    • Indirect Adjustment identifies an adjustment amount rolled up to the selected unit/line from another unit/line that was directly adjusted.
  • When details of Intercompany adjustment are requested for an Elimination Unit and a given Intercompany line, the individual Intercompany transactions that contributed to the IC adjustment amount are displayed. Any remainder and/or proportional amounts contributing to the selected unit/line IC adjustment amount are summed up and displayed by IC journal.
  • Balance sheet lines and Consolidation %: YTD and Periodic. If the selected period is a parent period, the report determines the last period that data exists for the selected unit and any line in the schedule. This period, "the driving period", is used to read the data for the remaining units and lines in the report scope. The parent period data is calculated as the driving period data multiplied by the driving period consolidation percent.
  • Profit and loss lines and Consolidation %:
    • Periodic. If the selected period is a parent period, the periodic data is calculated as the sum of the parent period's leaf period descendants' data multiplied by the corresponding consolidation percent for the leaf periods.
    • YTD. If the selected period is a parent period, YTD data is calculated as the sum of all leaf periods prior to the parent period data multiplied by the corresponding consolidation percent for the leaf periods.