You have to create an expense distribution sheet (EDS) before you can run an expense distribution sheet report. In the EDS you must set up report lines and report columns that will be displayed in the report.

Types of EDS

There are two types of EDS: dimension statement and cost statement.

  • Dimensions statement - Is used to report and compare results of different dimensions; each column corresponds to one dimension.

  • Cost statement - Is used to create a report for one or more dimensions or divisions. However, results for each dimension or division are displayed on a separate page, and columns compare actual and budget costs for each dimension or division.

Setup of EDS

To create a new EDS:

  1. Set up a line structure. The line structure is the basis for report lines.

  2. Set up a calculation type. The calculation type determines which cost balances are considered for the report. Select between the following three calculation types:

    • Period calculation.

    • Special calculation.

    • Plan calculation.

  3. Set up a report type. The report type determines the type of EDS report, whether a dimension statement or cost statement.

  4. Set up a hierarchy. You have to 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. For more information about how to define columns for an EDS, see Set up the columns of a specific expense distribution sheet.

See Also