Report columns (form)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click Cost accounting > Setup > Expense distribution sheet. Select an identification line and then click Report columns.

Use this form to create, manage, or view the report columns that you want to print on the expense distribution sheet. Enter a number, name, and the column type that you want to print. The type that you decide determines which fields are open for input on the tab pages.

Note

You may see different tabs depending on the Column type that you select.

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Overview tab

Create and view all available columns.

General tab

View or change all base settings of the column that is selected on the Overview tab.

Formatting

Select or view formats of the column that is selected on the Overview tab.

Column dimension

Select or view the dimension and date intervals of the column selected on the Overview tab. This tab is displayed only for columns with the costs fixed, variable, total, and quantity column types.

Calculation

Select or view a calculation expression for a column calculation column type that you select on the Overview tab.

Column reference

Select or view a column reference for a 100% column type that you select on the Overview tab.

Fields

Field

Description

Column

Generate or view the column number.

Column name

Enter, manage, or view the description of the column.

Column header

Enter, manage, or view the column header which is shown on the report.

Column type

Select one of the following column types:

  • Line number - The line number of the report column.

  • Name - The name of the report column.

  • Costs, fixed - The realized or planned fixed costs on a report column.

  • Costs variable - The realized or planned variable costs on a report column.

  • Total costs - The realized or planned total costs on a report column.

  • Quantity - The realized or planned quantities on a report column.

  • Column calculation - A column that is calculated based on other columns. The current calculation is specified by a calculation expression in columns 1 and 2.

  • 100% - A calculation of the cost line's share of the 100% cost line in the column that is marked on the line in Percentage column.

Value type

Select one of the following value types:

  • Budget costs

  • Basic plan costs

  • Flexible plan costs

  • Target costs

  • Actual costs

Budget model

Select a forecast model.

Note

This field is not active when the Value type is like Actual costs.

Print

Select the check box if the column should be printed on the report. The column can be a component of other calculated columns.

Identification

Select the number or code of the report.

Number format

Select one of the following number formats:

  • Unchanged - This format is the default and shows the values without any changes.

  • In thousands - This format indicates whether the column should display the value in thousands.

  • In millions - This format indicates whether the column should display the value in millions.

Decimal separator

Select the sign that will be used as the Decimal separator.

Thousands separator

Select the sign that will be used as the Thousands separator.

Show zero

Select if the value zero is shown.

Invert sign

Select if the values should be inverted.

Sign

Specify how to show a sign for negative figures.

Number of decimals

Specify the number of decimal places.

Negative adjustment

Enter the number of positions that negative figures should be moved to the left.

Length

The maximum number of positions in the column when you print it.

Dimension

Select or view the dimension type.

Number

Select the dimension value for the column.

Evaluate division

Use this check box to select a division instead of a dimension.

Division

Select the division for the column.

Date interval code

Select the date interval code.

From date

Specify the from date if you left the date interval code blank.

To date

Specify the to date if you left the date interval code blank.

Calculation expression

Select the formula that is used for calculating a column using other already created columns. During calculation, #1 and #2 will be replaced by the currently specified columns Column 1 and Column 2. Select from the following options:

  • #1-#2 = the difference between the columns marked in Column 1 and Column 2.

  • #1+#2 = the sum of the columns marked in Column 1 and Column 2.

  • #1+...+#2 = the sum of the interval of columns marked in Column 1 and Column 2.

  • #1*#2 = the product of the columns marked in Column 1 and Column 2.

  • #1/#2 = the ratio of the columns marked in Column 1 and Column 2.

  • #1/#2 % = the ratio of the columns marked in Column 1 and Column 2, calculated as a percentage.

  • (#1-#2)/#2 % = the difference between the columns marked in Column 1 and Column 2, as a percentage of the column marked in Column 2.

  • (#1-#2)/#1 % = the difference between the columns marked in Column 1 and Column 2, as a percentage of the column marked in Column 1.

Column 1

Select a column with the first operand in the leading expression.

Column 2

Select a column with the second operand in the leading expression.

Reference column

Select or view the reference column number for the calculation.

Reference line

Select or view the reference cost line for the calculation.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).