Cost accounting report (form) [AX 2012]

Updated: October 17, 2012

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.

Use this form to define, manage, and view the settings of expense distribution sheet reports.

You can choose between two different report types:

  • Dimension statement – Produces a classical view of the expense distribution sheet and compares the results of different dimensions.

  • Cost statement – Compares results within one dimension or hierarchy but over different periods and value types.

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




Copy the settings of a complete expense distribution sheet to a new sheet.

Report lines

Define, manage, and view the report lines that are used in the report.

Report columns

Define, manage, and view the report columns that are shown in the report.




Number or code of the report.


Short description of the report.

Report type

The expense distribution sheet (EDS) can be used for the different report types. Select from Dimension statement and Cost statement to define the report type.

Line structure

Select a line structure. Cost lines of this line structure are used as report lines for the report.

Calculation type

Select the calculation type that you want to use for this expense distribution sheet. You can select a period, special, or plan calculation.


The EDS can be used to report results of divisions also. If you want to report results in this manner, select a hierarchy in this field.

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