Use the Journal Detail report to review a detailed breakdown of all journal entries, including transaction dates, amounts, accounts, and descriptions.

Once you have selected the parameters, the report displays:

FieldDefinition
Columns
  • Intercompany: It displays Intercompany members under the selected Entity.
Rows
  • Accounts: It displays either Balance Sheet, Income Statement, or Cash Flow Accounts, depending on the source report.

The fixed dimensions of the report include:

DimensionMember(s)
AuditSelected audit member in the source report.
CurrencyParameter selected.
DataViewMember tagged as #AllDataviews.
DateParameter selected.
EntityElimination entity of the selected Entity parameter.
MeasureMember tagged as #Amount.
MovementMember tagged as #Closing.
ScenarioParameter selected
Any additional dimensionsDefault reporting member.

In the report, right-click on any cell and choose Calculation Lineage. This opens another report that shows a Consolidation Audit report for the intersection you chose.

Within the report, right-click on any cell and select View Data Intersections. This opens another report that displays data that makes up the cell you selected. 

For example, if you are looking at a parent Entity, you will see all the child entities that make up this data value.

Note: You can only view data intersections for standard consolidation dimensions. Any additional dimension, such as Products, aren't displayed.