Consolidated Income Statement Case Study: Set Up Column Definitions

Tutorial (Release 9.2 Update): Click here to view a recording of this feature.

To create the column definitions for the consolidated income statement, you set up column definitions that the system will use in conjunction with row definition and the data selection to retrieve account balances.

According to the plan that you developed, you need to create column definitions to retrieve account balances from the actual account (AA) ledger for the current period, last year current period, year to date, and last year-to-date. You determined that you will not set up data selection for the columns.

You also want the statement output to include columns for the percent of revenue and the percent of change in account balances. Because those account balances are not stored in the JD Edwards EnterpriseOne tables, you will need to set up those columns and calculations in the Layout Editor to add those columns to your statement output.

Enter AA (actual amounts) for the ledger type for all column definitions, and use the information in the following table to set up your OVFS column definitions:

Column Name	Column Description	Column Title	Balance Type	Fiscal Year Plus or Minus
(initials) CURPER	Current Period	Current Period Actual	Period	None
(initials) LSTYRCURPER	Last Year Current Period	Last Year Actual	Period	-1
(initials) YTD	Year to Date	Year to Date Actual	Year to Date	None
(initials) LSTYRYTD	Last Year to Date	Last Year to Date Actual	Year to Date	-1