Create an expense distribution sheet
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
You must create an expense distribution sheet (EDS) before you can run an EDS report. In the EDS, you must set up the report lines and report columns that will appear in the report.
Types of EDS
There are two types of EDS: dimension statement and cost statement.
Dimensions statement – Use this EDS to report and compare results of different dimensions. Each column corresponds to one dimension.
Cost statement – Use this EDS to create a report for one or more dimensions or divisions. However, results for each dimension or division appear on a separate page, and columns compare actual and budget costs for each dimension or division.
Setup of EDS
To create a new EDS:
Set up a line structure. The line structure is the basis for report lines.
Set up a calculation type. The calculation type determines the cost balances that are considered for the report. Select from among the following calculation types:
Period calculation
Special calculation
Plan calculation
Set up a report type. The report type determines the type of EDS report, whether it is a dimension statement or a cost statement.
Set up a hierarchy. You must select a hierarchy if you want to use the cost statement for hierarchies.
Report lines
You can manually or automatically define lines that you want to view in the report by using the transfer lines function.
Report lines are identical to cost lines for the selected line structure.
If the lines are entered automatically, you can still modify them by deleting or changing their position in the report. Change their position in the report by using the up and down buttons.
Report columns
You can define columns that you want to view in the report.