Selecting Rows for the Report

You can select the rows to display on the report. You can change these selections at any time.

The rows can display Entity Currency, Entity Curr Adjs, Entity Curr Total, Parent Currency, Parent Curr Adjs, Parent Curr Total, Parent Adjs, Parent Total, Proportion, Elimination, Contribution, Contribution Adjs, and Contribution Total.

The columns display the amount, Custom accounts, ICP, debits, credits, ID, or remarks.

You can suppress the display of some transaction details or dimensions by deselecting the applicable options. For example, if you want the report to show only the journal details, you can deselect all other row display options, leaving only the journals option selected. If you want to also suppress the Custom columns because they are not used for the account, you can deselect these options from the column display.

The Value column contains all of the Value members. If the currency of the parent member is the same as the currency of the entity, the system skips the display of the Parent Currency related Value members because it is duplicate information. The Amount column contains the amount from the data subcube. The amounts for each transaction detail are stored in the Debit or Credit column, depending on the sign of the data cell.

The Remarks column contains additional information about the amount. Depending on the Value dimension, you can have several possible remark comments such as whether the amount is Input, Calculated, or Derived, or uses the Nature parameter for auditing transactions. It can also contain information about prior records. One of the main purposes of the Entity Detail Transaction Report is to show all of the transaction records that made up the amount stored in the database. Prior LID, Journals, and Transactions remarks indicate that the amount stored in the database could be from line item details, journal adjustments, consolidation eliminations, as well as derived data from prior periods.

To select report rows: