Settings tab settings
The Settings tab of a report definition lets you specify the following report details:
The formatting and rounding amounts to use in the report.
The calculation priority of rows and column calculations.
The order that report components are processed.
The reporting units to use in the report.
The formatting for negative numbers in a report.
This topic contains the following sections:
Specify rounding options in a report definition
Specify calculation priority in a report definition
Adjust processing order in a report definition
Specify reporting units to include in a report
Specify other formatting in report definitions
Specify rounding options in a report definition
Rounding adjustments may be required if a report is generated in whole dollars or one of the other rounding options available in the report settings. How a report is displayed is also affected by the processing order of calculations with regard to rounding.
You can specify a level of rounding for the numeric values in a report on the Settings tab of the report definition.
If you select a rounding option for a report, you may have to make rounding adjustments, which involves setting the calculation priority and processing order.
For example, if calculations are performed before rounding, the balance sheet may balance, but not foot. If rounding is performed before calculations, the balance sheet will foot. However, the two sections (assets compared to liabilities and equity) may not balance. For more information about rounding adjustments, see Specify calculation priority in a report definition.
Note
The term foot means to total down to the row calculation. The term cross-foot means to total across, rolling up the child units to the parent unit.
Change the level of rounding used in your report
In Report Designer, open the report definition to modify. Click the Settings tab.
In the Rounding precision field, select a rounding option for the report. For a description of rounding options and examples, see the rounding options and the example later in this topic.
Rounding options
The following table describes the rounding options.
Rounding option |
Rounding example |
|---|---|
No Rounding |
$1,117,691,601.48 |
Whole Dollars |
$1,117,691,601 |
Nearest Hundred |
$1,117,691,600 |
Thousands (000.0) |
$1,117,691.6 |
Whole Thousands (000) |
$1,117,692 |
Millions |
$1,117.7 |
Whole Millions |
$1,118 |
Billions |
$1.1 |
Whole Billions |
$1 |
Examples of rounding reporting units
When you round a report, you can select to round the report values before or after totaling, and you can select to round the reporting units before or after rolling up to the parent unit. The following table identifies the different rounding option combinations and the effect on rounding differences.
Rounding selections |
Foot? |
Cross-foot? |
|---|---|---|
Roll up Rounded Values in the Tree |
No |
Yes |
This section shows examples of how totals and roll ups perform using the different rounding option combinations. In all cases, Management Reporter consistently totals the parent unit rows after rolling up the child units.
The following table displays report values that are not rounded. All reports foot and cross-foot to the Combined report.
Accounts |
U.S. |
Canada |
Combined |
|---|---|---|---|
Cash |
1413.48 |
1201.20 |
2614.68 |
Accounts Receivable |
287.37 |
100.40 |
387.77 |
Prepaid Expenses |
112.47 |
200.05 |
312.52 |
Total Current Assets |
1813.32 |
1501.65 |
3314.97 |
The following table contains two examples that use rounded values in calculations and totals.
|
|
Example 1
|
Example 2
|
||||
|---|---|---|---|---|---|---|
|
|
Roll up Rounded Values in the Tree
|
|
||||
|
|
U.S. |
Canada |
Combined |
U.S. |
Canada |
Combined |
|
Cash |
1413 |
1201 |
2614 |
1413 |
1201 |
2615 |
|
Accounts Receivable |
287 |
100 |
387 |
287 |
100 |
388 |
|
Prepaid Expenses |
112 |
200 |
312 |
112 |
200 |
313 |
|
Total Current Assets |
1813 |
1502 |
3313 |
1813 |
1502 |
3315 |
Specify calculation priority in a report definition
If you select a rounding option for your report, you may have to make rounding adjustments that involve setting the calculation priority and processing order. For more information about processing order, see Adjust processing order in a report definition. For example, if calculations are performed before rounding, a balance sheet may balance, but not foot. If rounding is performed before calculations, the balance sheet will foot. However, the two sections (assets compared to liabilities and equity) may not balance. You can use the calculation priority setting to indicate the order in which rows and columns are calculated.
Note
The term foot means to total down to the row calculation. The term cross-foot means to total across, rolling up the child units to the parent unit.
Specify calculation priority
In Report Designer, open the report definition to modify. Click the Settings tab.
Under Calculation priority, select one of the following options:
Perform column calculation first and then row – Perform the column calculations before the row calculations. This option might be necessary when a column calculation (CALC) intersects a total (TOT) or calculation (CAL) row, and the row calculation should overwrite the column calculation.
Perform row calculation first and then column – Perform the row calculation before the column calculations. This option works best for the following situations:
Report with a CALC column or with simple calculations
Row definition and column definition that use only simple mathematical operator (+ and -).
Adjust processing order in a report definition
Use the Processing order options to specify the order in which rollups, calculations, and rounding are completed when a report is generated. The following processing order options are available.
Option |
Description |
|---|---|
Rollup values in reporting tree |
Rounds the reporting unit values and then rolls up the results into the summary unit. When you use this option, every report in your tree correctly totals (foots). However, the totals in the summary report might not be the same as a similar summary report that does not use a reporting tree. |
Perform calculations |
Calculates rows and columns. |
Apply rounding |
Applies rounding to all values if you select any Rounding precision option other than None. |
Adjust the processing order
In Report Designer, open the report definition to modify. Click the Settings tab.
In the Processing order field, select a process, and then click Move Up or Move Down to indicate the processing order for the report.
Specify reporting units to include in a report
You can specify the reporting units that are included in a report in the report definition Settings tab.
Specify reporting units
In Report Designer, open the report definition to modify. Click the Settings tab.
Under Reporting unit selection, select one of the following options:
Select units at runtime - Displays the Select Reporting Units dialog box every time that this report is generated.
Include all units - Includes all reporting units in the report.
Include specific number of levels down from starting unit - Includes the specified number of reporting unit levels in the report.
Specify other formatting in report definitions
You can control the formatting and rounding of amounts at the report level by modifying the settings on the report definition Settings tab.
Specify other formatting options
In Report Designer, open the report definition to modify. Click the Settings tab.
Under Other formatting, select the formatting to use in the report.
The following table describes the available formatting options.
Option |
Description |
|---|---|
Use parentheses for negative numbers |
Indicates negative numbers by using parentheses ( ). If you do not select this option, the report indicates negative numbers with a minus sign (-). |
Display negative numbers in red |
Displays negative numbers in red font. If you do not select this option, the negative numbers appear in the font color that was selected for that row. |
Display digit separators |
Displays digit separators, for example, 120,346,000. |
Display currency symbol on first row |
Displays a currency symbol in all amount columns on the first row of each page. If you select this option, you do not have to enter a CS print control in the first row of the row definition. |
Display blanks for zero amounts |
Displays spaces instead of zeros for all zero balances in the whole report. |
Display rows with no amounts |
Displays rows with zero balances. By default, Management Reporter for Microsoft Dynamics ERP suppresses rows with zero balances in all amount columns. |
Display reports that have no active rows |
Generates a report for every unit of a reporting tree, even if no amounts appear. Empty reports might appear if title rows or other format rows are present. To prevent extraneous titles from printing on a report without amounts, relate each descriptive row to an amount row. For more information about how to relate rows, see the “Relate a format row to an amount row” section in Modify row definition cells. |
Include line numbers |
Displays line numbers for all rows in a report, or for detail and calculation lines only. By default, line numbers are not displayed. |
Extra lines between rows |
Changes the number of lines that are printed between the report rows. |
Spaces between columns |
Changes the default number of spaces that are printed between the report columns. In addition, in the Extra Spaces Before Column cell in the column definition, you can enter the number of spaces to use before a column. For more information, see “Add special formatting options” in Format columns. |
Report Settings dialog box
To change the layout, page numbering, and other details for a report, you must modify the settings in the Report Settings dialog box.
Open the Report Settings dialog box
In Report Designer, open the report definition to modify.
Click the Settings tab.
Click the Other button to open the Report Settings dialog box.
The Report Settings dialog box contains the following tabs:
Page Setup. For more information, see Page setup options.
Account and Transaction Details. For more information, see Account & Transaction Detail in report definitions.
Additional Options. For more information, see Additional options for report settings.
Page setup options in a report definition
You can change report setup options, such as margins, orientation, scaling, page order, and page size in the report definition Report Settings dialog box.
Change page setup options
In Report Designer, open the report definition to modify.
Click the Settings tab, and then click the Other button.
Click the Page Setup tab and select setup options, which are described in Page setup options.
Click OK.
Page setup tab
Option |
Description |
|---|---|
Margins |
The Left, Right, Top, and Bottom Margins boxes display the report page margin. To change the margins, select the margin value and type the new value. |
Orientation |
Management Reporter supports portrait or landscape orientation.
|
Scaling |
Displays the percentage of scaling in a report. To change the scaling, select one of the following options:
|
Page order |
Controls the layout of the report pages.
|
Paper |
Displays paper and copy settings. This option contains the following settings:
|
.gif "Page Setup Down Over")
.gif "Page Setup Over Down")
.gif "Note")
Note
Account & Transaction Detail tab in the Report Settings dialog box
You can select which account and transaction details to include in a report, such as displaying the row code or printing subtotals by period, by making modifications on the report definition Account & Transaction Detail tab in the Report Settings dialog box.
Note
Not all data providers support unposted transactions. For more information, see the data integration guide for your Microsoft Dynamics ERP system.
Configure account and transaction details
In Report Designer, open the report definition to modify.
Click the Settings tab, and then click Other.
Click the Account & Transaction Detail tab.
Modify the Account & Transaction Details settings 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, account total, and row total. |
Mark unposted accounts with * |
Displays an asterisk (*) for unposted balances or transactions. If you select this option, an asterisk appears at the transaction detail level for every unposted transaction. If you do not select this option, an asterisk appears at the account detail level for the unposted account balance, and at the transaction detail level for all unposted transactions. |
Include detail for non-printing rows |
Includes nonprinting rows that you defined in the Print Control column 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 BASEROW row 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 Periods 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 a message when the amount is larger than the number that you specify. |
Additional Options tab for report settings
There are additional options that you can include in a report, such as excluding inactive accounts. You can select these options in the Report Settings dialog box on the Additional Options tab.
Select additional options
In Report Designer, open the report definition to modify. Click the Settings tab.
Click the Other button.
In the Report Settings dialog box, click the Additional Options tab.
Select the additional options to include in the report, and then click OK.
For more information about the additional options sections, see the following tables.
Other options
Options |
Description |
|---|---|
Include amounts in future periods |
Includes amounts in columns that specify periods beyond the base period that is defined on the Report tab. If the future period amounts should not appear in the report, clear this box. |
Include missing unit warning |
Displays a warning message during report processing when a column or row is restricted to a reporting unit and the reporting unit does not exist or was not selected in the tree (the default). To use a restricted row or column in other reports and you do not want to see this warning, clear this check box. |
Exclude inactive accounts |
Generates reports that exclude inactive accounts if the Microsoft Dynamics ERP system supports the exclusion of inactive accounts. If you select this check box and the ERP system does not support inactive accounts, your reports are not affected. |
Other reporting tree options
Option |
Description |
|---|---|
Restart numbering with every unit |
Restarts the page numbering of each reporting tree unit throughout a report. To use sequential page numbering for all of the selected reporting units, do not select this check box. |
Allow rollup less than 1% |
Allows a rollup of less than 1 percent. If this check box is not selected, an entry of .25 in the Rollup % cell of the reporting tree indicates that 25 percent of each row should be rolled up to the parent. If this check box is selected, an entry of .25 would limit the roll up to one-fourth of one percent. |
Disable unit security |
Removes unit security so all users can drill down into all detail levels. |
Consolidate companies with different fiscal year ends
Option |
Description |
|---|---|
Rollup by using default company period number |
Rolls up accounts by period numbers in multiple-company reporting trees. |
Rollup by using default company period end date |
Rolls up accounts by period dates in multiple-company reporting trees. |