You can select which account and transaction details to include on a report, such as displaying the row code or printing subtotals by period, by making modifications on the report definition Account & Transaction Detailtab in the Report Settingsdialogue box.

Note Note

Not all data providers support unposted transactions. For more information, see the data integration guide for you Microsoft Dynamics ERP system.

Configure account and transaction details

  1. In Report Designer, open the report definition to modify.

  2. Click the Settingstab, and then click Other.

  3. Click the Account & Transaction Detailtab.

  4. Modify the Account & Transaction Detailssettings as needed, and then click OK. For descriptions of these options, see Account detail options and Account and transaction detail options .

Account detail options

The following account detail options are available.

Option

Description

Display account code or dimensions

Includes the segment or dimension values from the financial data system in the report. The segment or dimension value is added into the report description ( DESC) column at the account and transaction detail level.

Display account code or dimension description from chart

Includes the segment or dimension descriptions from the financial data system in the account and transaction detail report. As much of the description as will fit into the report description ( DESC) column is included.

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, Management Reporter for Microsoft Dynamics ERP displays the posted and unposted amounts on separate account detail line items for each account that has 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 *

Displays an asterisk ( *) for unposted balances or transactions. If you select the option, an asterisk appears at the transaction detail level for every unposted transaction. If you do not select the option, an asterisk appears at the account detail level for the unposted account balance, and also the transaction detail level for all unposted transactions.

Include detail for non-printing rows

Includes nonprinting rows that you defined in in the Print Controlcolumn in the row definition ( NP).

Sort by natural or main segment

Sorts multiple accounts that are listed at the same level. 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. By default, this option is selected because a report that has many accounts can take longer to process. If you include a base row calculation in the column definition, specify a BASEROWrow in the row definition. By using these specifications, the appropriate calculations are performed 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.

Option

Description

Subtotal by period

Prints the opening balance, period subtotals, and YTD total in the Periodscolumn. 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 a message when the amount is larger than the number that you specify.

See Also