Which Accounts Balances Will Columns Include?

You determined that you want columns in your statement to include account balances for these time periods:

• Current

• Last month end

• Last year end

You also want to include columns to show the change in amounts from the last month end to this month, and from last year end to the current period. Because the JD Edwards EnterpriseOne system does not store these balances, you must set up columns in the Layout Editor that will calculate the amounts.

You have already determined that your row definitions will include data selection over the account ranges that you want to include in the statement. You also decided when you began your analysis that you will set up data selection for the company and business unit at the statement version level so that the data selection will apply to all rows and columns on the statement. So, you do not need to set up data selection for your column definitions.

You will analyze the column setup for the calculated-amount columns when you create your layout. See Balance Sheet Case Study: Add Calculated Columns to the Layout

To set up the column definitions to include the account balances that you want to include, you must specify the balance type of each column definition, whether to offset the period or year, and the ledger type for the column definitions.

To create the column definitions in the Column Definitions program (P09320) that will generate the balance sheet statement in this case study, you need to set up column definitions with the following attributes:

Purpose of Column	Column Balance Types	Offset	Ledger Type
Current period amounts	Period	N/A	AA
Last month end amounts	Period	-1	AA
Last year end	Cumulative to Date	-1	AA

See also: Creating Column Definitions.Balance Sheet Case Study: Set Up Column Definitions.