The Account & Transaction Detail tab contains options for formatting detail reports.
Account Detail Options
The following list explains the options available:
Display account code/dimensions
Includes the segment or dimension values from the financial data system in the report. Management Reporter places the segment or dimension value into the report description (DESC) column at the account and transaction detail level.
Display account code/dimension description from chart
Includes the segment or dimension descriptions from the financial data system in your account and transaction detail report. Management Reporter includes as much of the description as will fit into the report description (DESC) column.
Display row code
Displays the row definition row codes in the account and transaction detail report.
Combine posted and unposted amounts
Combines posted and unposted balances in the account and transaction detail report. If you do not select this option, Microsoft Office PerformancePoint 2007 Management Reporter displays the posted and unposted amounts on separate account detail line items for each account with unposted activity.
Display underscore before totals
Displays an underscore line before each row total in account detail reports.
For transaction detail reports, select this option to print an underscore before and after each period total, each account total, and each row total.
Mark unposted accounts with *
Flags unposted balances or transactions with an asterisk ( * ). If you select the Combine Posted and Unposted Amounts option, an asterisk appears at the transaction detail level for every unposted transaction. If you do not select the Combine Posted and Unposted Amounts option, an asterisk appears at the account detail level for the unposted account balance, as well as the transaction detail level for all unposted transactions.
Include detail for non-printing rows
Includes non-printing rows that you defined in the row definition (NP Print Ctrl).
Sort by natural/main segment
Sorts multiple accounts that are listed at the same level.
Note: The overriding sort order for reports is determined by the account order in the row definition.
Display CBR calculation
Determines whether the calculation is performed if you select an account or transaction detail level report. This option is selected by default because a report with many accounts can take longer to process. If you include a base row calculation in the column definition, specify a CBR row in the row definition. With these specifications, Management Reporter attempts to perform the appropriate calculation on each row of the financial statement regardless of detail level.
Account and Transaction Detail Options
The following options are available for Account and Transaction Detail Reports:
Subtotal by period
Prints the opening balance, period subtotals, and YTD total in the YTD column. If you do not select this option, only the opening balance and YTD total prints on the report.
Display out of balance message when amount is greater than
Displays an out of balance message when the amount is greater than the number you specify.
To configure account details and transactions
In an open report definition, click the Settings tab, and then click Other.
Click the Account & Transaction Detail tab.
Change any Account & Transaction Details settings.